Few VERY IMPORTANT tips to reduce your size of Excel (check this... it is very useful);
1. Press Alt + F3 .... if there are any Errors in Name delete those Names by selecting all items and press delete
2. on a worksheet press Alt + Backspace... it will move you to last active cell of the excel... now check is it actual last cell of your worksheet ??? if not then select the rows from that cell to act...ual last cell and delete those Rows and do similar things for columns... (now check the same for all the worksheet)
3. If there are many Pivot tables then try to minimze the Pivot tables and keep the requried Pivot table only
4. Save the file with *.xlsx or *.xlsb... don't worry your files will work properly it is just advance way to store the details.
Try these things.. and if you has any others please add to this list
1. Press Alt + F3 .... if there are any Errors in Name delete those Names by selecting all items and press delete
2. on a worksheet press Alt + Backspace... it will move you to last active cell of the excel... now check is it actual last cell of your worksheet ??? if not then select the rows from that cell to act...ual last cell and delete those Rows and do similar things for columns... (now check the same for all the worksheet)
3. If there are many Pivot tables then try to minimze the Pivot tables and keep the requried Pivot table only
4. Save the file with *.xlsx or *.xlsb... don't worry your files will work properly it is just advance way to store the details.
Try these things.. and if you has any others please add to this list
No comments:
Post a Comment