98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Helen has attended:
Excel Intermediate course
Excel
How do I reduce the size of an excell workbook with out losing data?
RE: excel
Hello Helen
Thank you for your question
Have you deleted columns/rows that contain no data. Press ctrl-end on each sheet to see if you have blank rows/columns. This will highlight the last active cell on the sheet and if it is on a blank row/ cell you know you have extra rows which are still being counted, even though they are blank. If so delete them (don't just clear them). When you save, your file should be smaller.
Can the file be split into more than one linked file? Are there lots of formula columns that could be condensed into one formula column that does the same thing?
Are there embedded graphics you can lose as they may take up more space?
Here is a link which may be able to give you more tips:
http://www.mrexcel.com/forum/showthread.php?t=76106
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |