How do you reset the position that pressing CTRL-END moves you to?

P

PeterB

In Excel, pressing CTRL-END moves the cursor to the furthest
bottom-right-hand used cell in the s/sheet.

Suppose this is AZ1000. Delete 500 (bottom) rows and press CTRL-END again.
This still takes you to cell AZ1000, and not AZ500 as you might expect.

Having deleted rows/columns in a s/sheet, how does one reset the position of
the 'END' cell that Excel stores?
 

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

CTRL-END 3
Changing position of last used cell 4
Reset End Cell - Excel 2007 2
Navigate Excel--Tab key is functioning like ctrl-->, how to fix 1
how to manually copy text from one cell to end of other text cell 3
Different "end" on different sheets 2
Changing the end of a worksheet (Ctrl+End) 2
Because of row/column deletions, how do you reset the last cell? 3

Top