Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
Hi Are there any common tips for keep the excel file size down? -- zephyr_60 ------------------------------------------------------------------------ zephyr_60's Profile: http://www.excelforum.com/member.php...o&userid=29406 View this thread: http://www.excelforum.com/showthread...hreadid=491239 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Size
If formulas are not required once the calculation has already been done then
format them as values. Avoid colors, large fonts, toolbox objects on the sheet, blank worksheets. blank rows. Press ctrl+shift+end and see where the last cell is. if there are too many blank rows and columns between the last cell used and the location of the activecell then you might have to copy your data to a new sheet delete the old sheet then rename your sheet to whatit was. There is a way to delete blank rows and columns so that the last cell used is actually a used cell but I cannot remember, I think Debra dalgliesh site has an answer for that one. "zephyr_60" wrote: Hi Are there any common tips for keep the excel file size down? -- zephyr_60 ------------------------------------------------------------------------ zephyr_60's Profile: http://www.excelforum.com/member.php...o&userid=29406 View this thread: http://www.excelforum.com/showthread...hreadid=491239 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why did my Excel file suddenly balloon in size? | Excel Discussion (Misc queries) | |||
Any tips for reducing Exce file size with charts | Excel Discussion (Misc queries) | |||
File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
excel file size bloat | Excel Discussion (Misc queries) |