Free guides / Excel
20 Excel keyboard shortcuts every beginner should know
Updated 17 November 2026
You don't need hundreds of shortcuts. These 20 cover what most people do every day in Excel on Windows. On a Mac, use Cmd where you see Ctrl for most of them.
Move around fast
- Ctrl + Arrow key: jump to the edge of your data.
- Ctrl + Home / Ctrl + End: go to the first cell / the last used cell.
- Ctrl + Page Down / Page Up: next / previous sheet.
Select
- Ctrl + Shift + Arrow key: select to the edge of the data.
- Ctrl + Space: select the whole column. Shift + Space: the whole row.
- Ctrl + A: select the whole data block (press again for the whole sheet).
Edit and format
- F2: edit the active cell.
- Ctrl + 1: open Format Cells.
- Ctrl + ;: insert today's date. Ctrl + Shift + ;: the current time.
- Ctrl + -: delete cells, rows or columns. Ctrl + Shift + +: insert them.
- Ctrl + Z / Ctrl + Y: undo / redo.
Formulas and data
- Alt + =: AutoSum the cells above or to the left.
- F4 (while editing a formula): lock a cell reference with
$signs. - Ctrl + D: copy the cell above down into the selection.
- Ctrl + T: turn your data into a Table.
- Ctrl + Shift + L: turn filters on or off.
Mac users: some shortcuts differ (for example, AutoSum is Cmd + Shift + T, and F-keys may need the fn key).
Questions
What is the shortcut for AutoSum in Excel?
Alt + = on Windows. On a Mac it is Cmd + Shift + T.
How do I lock a cell reference in an Excel formula?
While editing the formula, click the reference and press F4 to add $ signs, for example A1 becomes $A$1.
More: VLOOKUP in Excel: a simple guide with examples · How to make a pivot table in Excel (beginner guide)