excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.08 secs.