Problem with Huge Empty Cells

[Dolphinv4]

Hi,

I don't know what I did but somehow my worksheet contains
a lot of empty cells which I don't need - resulting in
the scrollbar becoming very small and the file size very
big.

I tried to delete the empty cells right till the end of
the sheet but the scrollbar remains very small and the
file size still very big.

What should I do?

Thanks a million!

 

[Gord Dibben]

See this info on "used range" at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Explains cause and cure.

Gord Dibben Excel MVP

 

[John Wilson]

Dolphin,

You need to delete the actual rows and columns (not the cells).
For some help with this, take a look here:

http://www.contextures.com/xlfaqApp.html#Unused

John