Exceljet

Quick, clean, and to the point

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).

222 Excel Shortcuts for Windows and Mac

Related videos

How to build a simple summary table

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.

Shortcuts to hide/unhide rows and columns

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.

I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!! -Annette

Move to first cell in worksheet

Related videos

Download 200+ Excel Shortcuts

Excel video training