Tom’s Tutorials For Excel: Going Home — Using the Home shortcut key

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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Going Home — Using the Home shortcut key
  1. Colin says:

    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.

    • Tom Urtis says:

      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.

Leave a Reply

Your email address will not be published.

*