Empty Cells Causing Huge File Size

[Guest]

Hi

I do not know what I did, but one of my excel sheet seem to have a lot of "empty" cells which doesn't seem to go away, ie, it is causing the scrollbar to become very thin vertically. I tried doing a Ctrl+Down Arrow to go to the last row of excel then select all rows beneath my data, then I tried delete rows, clear format, clear contents and all don't work

1) What caused this
2) How do I salvage this

Thanks!

 

[A.W.J. Ales]

Dolphinv,

Most of the time it is caused by (temporarely) entering something in a cell
"far away" from your real datacells or formatting such a cell.
Go to the end of your data and select all the rows under it and delete those
rows.
Then (if necessary) do the same with the columns to the right of your data.
After deleting both rows and columns save and close your file and reopen it.

(Excel keeps track of your last cell (the one you jump to if you press
CNTRL+END, but sometimes makes a mess of it. It doesn't "reset" it
automaticly if you reduce the size of your data area).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Hi,

I do not know what I did, but one of my excel sheet seem to have a lot of

"empty" cells which doesn't seem to go away, ie, it is causing the scrollbar
to become very thin vertically. I tried doing a Ctrl+Down Arrow to go to the
last row of excel then select all rows beneath my data, then I tried delete
rows, clear format, clear contents and all don't work.

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlfaqApp.html#Unused
to clear the unused range