How to reset the last cell in an Excel worksheet

After I’ve added/deleted/moved/copied… basically, done enough work in an Excel worksheet so that when I hit Control-End, Excel goes to a cell far, far away from any of my work, I do the following to reset the “last cell”

Hit Control-End to see what Excel considers the last cell before you perform the instructions below.

1. Hit Alt-F11

This should open the VBA editor

1. Hit Control-G

This should open a window at the bottom with the title “Immediate”

1. Type the following in the Immediate window and then press Enter:

   ActiveWindow.UsedRange

Now hit Control-End again and see how Excel jumps upwards and/or leftwards… you’ve done it!