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.

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.