Changing the end of a worksheet (Ctrl+End)

[Loren]

If I have data in Cell A1 through Z200 and I press Ctrl +
end my cursor jumps to cell Z200. If I delete all rows
after row 100 then cell Z100 is my last active cell.
However, when I press Ctrl + End Excel still remembers my
last used cell as cell Z200. How can I clear this so that
I can use Ctrl + End to move to the last active cell I
have instead of the last active cell I had used at one
time in the past.

Thanks in advance.

 

[Anders S]

Loren,

Save the file and you'll be OK. With some earlier versions of Excel You have to
close the file and reopen it as well.

HTH
Anders Silven

 

[Gord Dibben]

Loren

See Debra Dalgleish's site for resetting the used range.

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

Gord Dibben Excel MVP