Changing the end of a worksheet (Ctrl+End)

  • Thread starter Thread starter Loren
  • Start date Start date
L

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you reset the position that pressing CTRL-END moves you to? 2
CTRL-END 3
Excel Cannot delete empty cells/rows 4
Changing position of last used cell 4
Different "end" on different sheets 2
Excel Error Help 1
Error message "cannot shift nonblank cells off the worksheet" 2
End of document 3

Back
Top