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.
- Hit Alt-F11
This should open the VBA editor
- Hit Control-G
This should open a window at the bottom with the title “Immediate”
Type the following in the Immediate window and then press Enter: