Tom’s Tutorials For Excel: Going Home — Using the Home shortcut key
The keyboard’s Home key by itself takes you to the cell in column A of your active cell’s row, or with Ctrl+Home takes you to cell A1. If Freeze Panes is being used, Home takes you to the Freeze Panes column of the active cell’s row, and Ctrl+Home takes you to the Freeze Panes’ intersecting cell.
Using Home, go to column A of the active cell’s row.
Using Home, go to the Freeze Panes column of the active cell’s row.
Using Ctrl+Home, go to cell A1.
Using Ctrl+Home, go to cell B3 in this case, where Freeze Panes is set.
However, if you have the Lotus Compatibility / Transition Navigation Keys option checked (which some of us older geezers who started our spreadsheeting lives with Lotus 123 still prefer), pressing Home and Ctrl+Home will do the opposite to the above.
Actually I thought about that but didn’t even mention it. You’re right, but people like us (I’m 56 years old) who remember the Lotus days — not to mention who actually are aware that the Lotus Compatibility option is even in the dialog — are so small in relative user population that it wasn’t worth calling attention to a dinosaur option. But maybe I was wrong, if nothing else it’s a useful tidbit. Thanks for following my page and for pointing out what I did not put into the tutorial; it might help someone reading this.