Prev: How do I copy a formula with the cell increasing by increments?
Next: Conditional formatting, coloring the whole row
From: beata on 3 May 2010 15:46
Hi. I'm using a workbook that someone else created from a download. It has
23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it
appear that it's only 10% from the top.
In the past I've deleted all of the rows - going down to the full million -
and then gone back to A1 and hit "save". Usually that refreshes the space.
It's not working. I can delete them. And go to A1 and save - even tried
resaving with another name.. but it (Excel) still thinks it's bigger than it
is. Any ideas?
From: Dave Peterson on 3 May 2010 16:23
Usually that technique works.

Debra Dalgleish documents it here:
http://contextures.com/xlfaqApp.html#Unused

But I've seen times where it doesn't work.

If it really bothers me, I'll create a new worksheet and copy|paste just the
data/formulas/headers/names/formatting (all that stuff) to a new sheet.

Then I'll check it by hitting ctrl-end (to get to what excel thinks is the last
used cell). Then I delete the original sheet.

Be careful if you have formulas that point to that sheet to be deleted. You may
have more work to do first!

beata wrote:
>
> Hi. I'm using a workbook that someone else created from a download. It has
> 23,600 rows -- yet the vertical scroll bar.. when on the last row.. makes it
> appear that it's only 10% from the top.
> In the past I've deleted all of the rows - going down to the full million -
> and then gone back to A1 and hit "save". Usually that refreshes the space.
> It's not working. I can delete them. And go to A1 and save - even tried
> resaving with another name.. but it (Excel) still thinks it's bigger than it
> is. Any ideas?

--

Dave Peterson
 | 
Pages: 1
Prev: How do I copy a formula with the cell increasing by increments?
Next: Conditional formatting, coloring the whole row