Excel File Clean Up Excess Space?

[Al Franz]

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.

 

[Gord Dibben]

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