Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I reduce the size of my Excel file without zipping it?
I have some rather large excel files (16 MB) and woud like any tips you have
to reduce them. I've already removed links and checked that there was no formatting accross the entire workspace. Are there any other simple house-keeping tips out there? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I reduce the size of my Excel file without zipping it?
It is possible that Excel thinks the last used cell is farther
down that it really is. Select the row header of the line after the last cell you use in your workbook, hold down the SHIFT key and press the END button then the DOWN ARROW button. Right-click a row header while these cells are selected and choose the DELETE option. (Using the DELETE key won't do it.) This will cause Excel to truly delete the rows, rather than clearing their contents. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sizerd" wrote in message ... I have some rather large excel files (16 MB) and woud like any tips you have to reduce them. I've already removed links and checked that there was no formatting accross the entire workspace. Are there any other simple house-keeping tips out there? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
deleted bitmaps and still have huge excel file size | Excel Discussion (Misc queries) | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Any tips to reduce excel workbook size? | Excel Discussion (Misc queries) | |||
How do I reduce the size of an exel file? | Excel Discussion (Misc queries) |