Removing Blank Cells

[Jeff Mortenson]

I would like to know if there is a way to remove the blank
columns and rows from a worksheet. There really is no
need for this many blank rows in the workpaper I am
working on and I assume it contributes to the overall size
of the spreadsheet.

Thanks in advance.

 

[Frank Kabel]

Hi
you can't remove them (you can hide them if you like9. Also they do not
add up to the size of your worksheet 8at least as long as your used
range is correct)

 

[David McRitchie]

The real check is Ctrl+End which will show you what
Excel is actually using. If you have your last cell
way out into empty space then you would be wasting
space. Another way of doing a cursory examination
would be to look at the scroll bars as you go down or
across.

If you need to make another cell your last cell to drop
of unused rows columns that Excel thinks you are using
see Make Last Cell in
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

If you have 3 sheets and use only 2 sheets you could drop that
unused sheet to make the file smaller.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm