exceptionally large excel spreadsheet, great space, run slow speed, how to lose weight to the Excel workbook? In addition to workbook macro virus itself (on how to identify macro virus, the end of this article has made it clear), the There are several reasons the following may lead to abnormal expansion of workbook

a worksheet format is too complicated

(such as a variety of fonts, multi-color, conditional formatting, etc.)


As we all know, a working table 65536 * 256 cells, the very large a scope. We are in the application of a number of format settings, often for the convenience of a direct line in the whole or entire column, or in a multi-line and multi-column applications, this fact is not right. I believe that very few people will use over the entire column, or the whole line. Did not use a large number of cells was combined with a number format, Excel does not always know that cell is no need for, and often will include in the calculation of these cells. In addition, the diversity of format (including fonts, colors, etc.), it is bound to result in large Excel file size, which is understandable.
Less exhausted style format, such as fonts and colors, after all, the advantages of Excel is not the instrument, the layout of the display (it is Word, PowerPoint and other strengths)
To delete "empty" cells. Table to find a job in the lower right corner of the cell (Please note: Unless you have self-confidence, please do not place undue reliance on Excel's "Location" => "last cell" by the results to you), I find that you can manually the cell. Then select all the cells in the right column, and then the implementation of the menu command: "Edit" => "clear" => "All", then select all the cells below the line, the same implementation of the menu command: "editors "=>" clear "=>" All ", and then save

Second, pictures or other graphics graphics more, or chose not to appropriate picture format


select the appropriate image format
¡¡¡¡
Cited in the document in general there are three picture formats, BMP, JPG, GIF. BMP format high fidelity of the picture, but the size of the other two formats are often several times to several times, and photographs, scanned images, such as GIF format using the distortion is very serious, it is proposed to adopt JPG picture format , and then introduced into the document, this format is not only the image size is much smaller than the BMP format, and often also small GIF format, and BMP format and fidelity are not very different.

use "insert" the introduction of picture

There are two ways to insert a picture, the first is saved as a JPG image file, select "Insert ¡ú Picture ¡ú From File", open the "Insert Image" dialog box, select the required picture file inserted, click "Insert" button. The other is the "drawing", "Microsoft Photo Editor" and open the JPG file, select and copy, and then in the document click on "Paste" to insert. We strongly recommend using the first method, although the two methods is the same as the picture quality, but formed by the first method the size of the document may be several times smaller than the second!