The 20 shortcuts that save the most time, for Windows and Mac. Read the list, then test yourself with the drill.
Cheat sheet
Basics
What it does
Windows
Mac
Copy the selected cellsCopies the selected cells so you can paste them somewhere else. The original stays where it is. Repeating a value, formula or block of formatting elsewhere in the sheet. A moving dashed border shows what is on the clipboard. Press Escape to clear it.
Ctrl+C
⌘+C
Paste what you copiedPastes the last thing you copied or cut into the active cell. Placing copied data or formulas. Formulas adjust their references to the new position. To paste only the values and drop the formulas, use Paste Special.
Ctrl+V
⌘+V
Undo your last actionReverses your last action. Press it again to keep stepping back. Right after a mistake, such as deleting the wrong column or overwriting a formula. Saving does not clear the undo history in most cases, but closing the workbook does.
Ctrl+Z
⌘+Z
Redo the action you just undidBrings back an action you just undid. When you undid one step too many. On Windows, F4 also repeats your last action when you are not editing a cell.
Ctrl+Y
⌘+Y
Save the workbookSaves the workbook under its current name. After every meaningful change. Make it a habit. A file that has never been saved opens the Save As box first.
Ctrl+S
⌘+S
Formatting
What it does
Windows
Mac
Make the selection boldSwitches bold on or off for the selected cells. Making headers and totals stand out. Select the whole header row first, then press it once.
Ctrl+B
⌘+B
Open the Format Cells boxOpens the Format Cells box with number, alignment, font, border and fill options in one place. Setting a number as currency or a percentage, or fixing how a date looks. This is faster than hunting through the ribbon for every formatting task.
Ctrl+1
⌘+1
Data
What it does
Windows
Mac
Turn filters on or offTurns the filter arrows on or off for the header row of your data. Narrowing a long list down to one region, status or date. Click inside your data first so Excel knows which table to filter.
Ctrl+Shift+L
⌘+Shift+F
Open FindOpens the Find box so you can search the sheet for a value or text. Locating one entry in a large workbook. Use the Options button to search whole workbooks or match case.
Ctrl+F
⌘+F
Selection
What it does
Windows
Mac
Select the entire columnSelects the whole column of the active cell. Formatting, widening, hiding or deleting an entire column. On a Mac, use the Control key, not Command, for this one.
Ctrl+Space
Ctrl+Space
Select the entire rowSelects the whole row of the active cell. Inserting, deleting or formatting an entire row. Combine it with Ctrl and plus to insert a new row above.
Shift+Space
Shift+Space
Select all the cellsSelects all the data around the active cell. Press it again to select the entire sheet. Copying a whole table or applying formatting to everything. Click inside your table first. One press selects the table, two selects the sheet.
Ctrl+A
⌘+A
Select down to the last filled cellExtends the selection from the active cell down to the last filled cell in the column. Selecting a long column of data in a single move, however many rows it has. Press it again to jump past a gap to the next block of data.
Ctrl+Shift+↓
⌘+Shift+↓
Navigation
What it does
Windows
Mac
Jump to the last filled cell on the rightJumps the cursor to the edge of the current block of data, in the direction of the arrow. Moving to the end of a long row or column without scrolling. Add Shift to select everything on the way.
Ctrl+→
⌘+→
Go to cell A1Jumps straight back to cell A1 at the top left of the sheet. Returning to the start after working deep in a large sheet. On a Mac, use Function and Control with the left arrow on most laptops.
Ctrl+Home
Fn + Ctrl + ←
Editing
What it does
Windows
Mac
Edit the active cellPuts the cursor inside the active cell so you can edit it without retyping. Fixing part of a long formula or label. While editing, F4 cycles the reference lock on a selected cell reference.
F2
Ctrl+U
Fill the cell above down into the selectionCopies the value or formula from the top cell of your selection down into the rest. Filling a formula down a column after writing it once. Select the cell with the formula and the empty cells below it first.
Ctrl+D
Ctrl+D
Insert today's dateTypes today's date into the cell as a fixed value. Logging when something happened, such as a delivery or a payment. It does not update tomorrow. Use the TODAY function if you want a date that changes.
Ctrl+;
Ctrl+;
Formulas
What it does
Windows
Mac
Cycle a reference between $A$1, A$1, $A1 and A1 while editing a formulaWhile editing a formula, cycles a cell reference through $A$1, A$1, $A1 and A1. Locking a reference so it stays put when you copy the formula down or across. Click on the reference inside the formula first, then press it.
F4
⌘+T
Insert an AutoSum formulaWrites a SUM formula for the cells above or beside the active cell. Totalling a column or row in a second. Check the range Excel suggests before you press Enter.
Alt+=
⌘+Shift+T
Common questions
What are the most useful Excel shortcuts to learn first?
Start with Copy, Paste, Undo and Save, then learn how to select a whole column or jump to the end of your data. They save the most time every day.
Are Mac shortcuts the same as Windows ones?
Mostly the Control key becomes Command, but not always. This cheat sheet lists both, and a few differ, such as the key for editing a cell.
Why practise shortcuts instead of reading a list?
Shortcuts are muscle memory. Pressing the keys, and being told when you are wrong, is how they stick.