This time, let's share how to slim down Excel.

At work, you may find files with similar contents, some are several k, some are several m.

This is a thousand times different.

What caused this?

How can we avoid it?

How do we lose weight?

Let's learn and answer the above questions.

0 1 How to lose weight?

Before slimming: 45M=46354K.

After slimming: 17K

Reduced by more than 2700 times.

Now talk about the operation method, it is easier to look at the picture.

1. Take a look at the largest line with content at present, select it from the next line (blank line), then hold down CTRL+SHIFT on the keyboard, don't let go, press this key with the other hand, and all blank lines up to the largest line in Excel will be selected and right-click to delete.

2. Deleting a column is the same, except that you need to change the word "hold ↓" to "hold →" and delete it in the same way.

3. Delete the color of the table, especially the whole line.

4. Remember to save.

A picture is worth a thousand words;

02 causes and solutions

After 2007, Excel has 1048576 rows and 16348 columns. If you fill an entire row or column with color every time, it will consume huge memory.

Solution: Avoid the whole line arrangement operation.

As long as it involves setting cells, don't do the whole row and column operations, such as setting cell colors, setting font colors, setting conditional formats, borders, etc. ...

Compared with other objects, the temporary memory is larger, too many pictures are inserted into Excel, and the volume of Excel will also increase sharply, and it will get stuck when it is opened.

Solution: Save the address corresponding to the picture instead of saving it, that is, manage it by inserting hyperlinks. If you must insert a picture, it is recommended to store it after compression.

Twitter: Excel files suddenly increase in size and get stuck when opened, which are all caused by incorrect usage habits or methods. As long as you pay attention to it at ordinary times and reduce the operation of the whole row and column, you can basically avoid the problem of sudden increase in trading volume.