Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Clean Up Excess Space?
Using Excel 2007. Can files get overly large from extended use, is there a
cleanup function within Excel? Also what is the best way to delete all blank rows and columns at the ends of the spreadsheet. Seem to have blank data out there which is making my ranges highlight excessive rows and columns. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel File Clean Up Excess Space?
You can manually delete rows and columns below and right of data range.to
reduce worksheet size. You can also use VBA to clean it up. See Debra Dalglesih's site for both methods. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Tue, 28 Apr 2009 18:23:41 -0700, "Al Franz" wrote: Using Excel 2007. Can files get overly large from extended use, is there a cleanup function within Excel? Also what is the best way to delete all blank rows and columns at the ends of the spreadsheet. Seem to have blank data out there which is making my ranges highlight excessive rows and columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete excess pages from a file? | Excel Worksheet Functions | |||
Importing a space-delimited txt. file right-justified into Excel | Excel Discussion (Misc queries) | |||
Clean non printable characters and replace with space | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
eliminate white space in Excel file | Excel Discussion (Misc queries) |