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

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?

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

Try clicking save first. This should reset your range.

"PeterB" wrote:

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?

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

Peter

Try saving the workbook and then using Ctrl+End

Richard


"PeterB" wrote in message
...
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?