Move to first cell in worksheet
Windows shortcut
CtrlHome
Mac shortcut
Fn⌃←
If freeze pane is enabled, this shortcut will go to the upper left cell in the current pane. If freeze pane is not enabled, this shortcut will go the cell upper left cell in the worksheet (A1).
Related videos
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.
In this video, we look at the shortcuts you can use to hide and unhide both columns and rows. These are very handy for hiding data you don't need to see, and just a taste of Excel's 200+ shortcuts.