computer

Long-term EXCEL file

Methods/steps

Find a very long EXCEL document and check its size, as shown in the figure.

As shown in the figure after opening, I deleted all the data on the surface and opened an empty document with only table rows, but the figure above shows that the document is more than 2M.

Use the shortcut key Ctrl+G to open the dialog box as shown in the figure. Select positioning conditions and objects.

As shown in the figure, there is a lot of junk data of object attributes. Is it horrible? In the selected state, select the delete key and save it. I'm here to save it as a 2 file.

five

As can be seen from the figure below, the file has changed from more than 2M to 28K. Isn't it amazing? Other complicated formulas will also take up more memory. When slimming, the fewer formulas, the fewer formats set and the less space occupied.