Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I shrink an xlsx file after cutting a big data worksheet?
I deleted an Excel 2007 worksheet that contained lots of data (approx. 40% of
initial spreadsheet size). It resaved to the disk at its previous disk size. What do you do to save the file in its new, smaller size, i.e. compress it? I'm new to Excel 2007, previously using Excel XP, so I figure there is some option to check/uncheck to make this work. I just haven't found it yet. Thanks for the pointers. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I shrink an xlsx file after cutting a big data worksheet?
If you deleted a worksheet itself the file size will be smaller.
If you simply cut or cleared the contents of a worksheet then Excel thinks those cleared cells are still being used. Select all rows below your data and delete them. Select all columns to right of your data and delete them. Do not just "clear contents". You must delete. Now Save the file. Gord Dibben MS Excel MVP On Thu, 29 Oct 2009 14:46:01 -0700, smoore716 wrote: I deleted an Excel 2007 worksheet that contained lots of data (approx. 40% of initial spreadsheet size). It resaved to the disk at its previous disk size. What do you do to save the file in its new, smaller size, i.e. compress it? I'm new to Excel 2007, previously using Excel XP, so I figure there is some option to check/uncheck to make this work. I just haven't found it yet. Thanks for the pointers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
Excel File Shrink | Excel Discussion (Misc queries) | |||
Compact or Shrink down excel file | Excel Discussion (Misc queries) | |||
How can I shrink a file size w/ a pivot table and many formulas? | Excel Worksheet Functions | |||
How to shrink file sizes after eliminating worksheets in file | Excel Discussion (Misc queries) |