Excel Keyboard Shortcuts for Windows and Mac (Cheat Sheet)

The shortcuts that save the most time in Excel, grouped by the task you are doing, with the Windows and Mac keys side by side. Finance interview guides single out a handful as the moves a timed test assumes: Ctrl + Shift + Arrow to select a block, F2 to edit, F4 to lock a reference, Alt + = for AutoSum, Ctrl + 1 for the Format Cells dialog. Learn those five first.

Mac keys: ⌘ is Command, ⌥ is Option, ⌃ is Control. Fn is needed for function keys on most Mac keyboards. A comma means press the keys in sequence.

Selection

TaskWindowsMac
Extend the selection to the edge of the blockThe selection move timed tests assume. Disabled in some simulations.Ctrl+Shift+Arrow⌘+Shift+Arrow
Select the current regionPress again for the whole sheet.Ctrl+A⌘+A
Select the whole columnCtrl+Space⌃+Space
Select the whole rowShift+SpaceShift+Space
Extend the selection one cellShift+ArrowShift+Arrow
Select to the start of the rowShift+HomeFn+Shift+←
Select to A1Ctrl+Shift+HomeFn+⌃+Shift+←
Select visible cells onlyAlt+;⌘+Shift+Z

Editing

TaskWindowsMac
Edit the active cellF2⌃+U
Enter and stay in the cellWith a range selected, fills every cell with the entry.Ctrl+Enter⌃+Return
New line inside a cellAlt+Enter⌃+⌥+Return
Copy, cut, pasteCtrl+C / X / V⌘+C / X / V
Paste SpecialThen V for values, T for formats.Ctrl+Alt+V⌘+⌃+V
Undo and redoCtrl+Z / Y⌘+Z / Y
Fill down from the cell aboveCtrl+D⌘+D
Fill right from the cell to the leftCtrl+R⌘+R
Insert the current dateCtrl+;⌃+;
Insert the current timeCtrl+Shift+;⌘+;
Insert rows, columns or cellsSelect whole rows or columns first to skip the dialog.Ctrl+Shift++⌃+I
Delete rows, columns or cellsCtrl+-⌘+-
Flash FillCtrl+E⌃+E
Insert a comment or noteShift+F2Fn+Shift+F2

Formatting

TaskWindowsMac
Format Cells dialogNumber formats, alignment, borders, fill in one place.Ctrl+1⌘+1
Bold, italic, underlineCtrl+B / I / U⌘+B / I / U
Currency formatCtrl+Shift+4⌃+Shift+4
Percentage formatCtrl+Shift+5⌃+Shift+5
Number format with two decimalsCtrl+Shift+1⌃+Shift+1
Date formatCtrl+Shift+3⌃+Shift+3
General formatCtrl+Shift+~⌃+Shift+~
Outline borderCtrl+Shift+&⌘+⌥+0
Remove bordersCtrl+Shift+_⌘+⌥+-
Hide the selected rowsCtrl + Shift + 9 unhides.Ctrl+9⌃+9
Hide the selected columnsCtrl+0⌃+0

Formulas

TaskWindowsMac
AutoSumAlt+=⌘+Shift+T
Cycle $ through a referenceWhile editing: B1, $B$1, B$1, $B1. Fn + F4 also works on Mac.F4⌘+T
Show formulas instead of valuesCtrl+`⌃+`
Recalculate all open workbooksF9Fn+F9
Insert a functionShift+F3Fn+Shift+F3
Expand the formula barCtrl+Shift+U⌃+Shift+U
Enter an array formula (older Excel)Not needed in Excel 365, where formulas spill on their own.Ctrl+Shift+Enter⌃+Shift+Return
Define a name for the selectionCtrl+F3Fn+⌃+F3

Filters, tables and data

TaskWindowsMac
Turn AutoFilter on or offCtrl+Shift+L⌘+Shift+F
Open the filter menu of the active headerAlt+↓⌥+↓
Create a tableCtrl + L also works on Windows.Ctrl+T⌘+T
Data validation dialogWindows ribbon sequence; on Mac use Data > Data Validation.Alt+D, L—
Remove duplicatesWindows ribbon sequence; on Mac use Data > Remove Duplicates.Alt+A, M—
Sort dialogWindows ribbon sequence.Alt+A, S, S—
Group rows or columnsAlt+Shift+→⌘+Shift+K
UngroupAlt+Shift+←⌘+Shift+J
Create a PivotTableWindows ribbon sequence; on Mac use Insert > PivotTable.Alt+N, V, T—

Sheets, windows and files

TaskWindowsMac
New worksheetShift+F11Fn+Shift+F11
Freeze panesWindows ribbon sequence; on Mac use View > Freeze Panes.Alt+W, F, F—
Rename the sheetOr double-click the tab on either platform.Alt+H, O, R—
SaveCtrl+S⌘+S
Save AsF12⌘+Shift+S
Open and new workbookCtrl+O / N⌘+O / N
PrintCtrl+P⌘+P
Switch between open workbooksCtrl+Tab⌘+~
Close the workbookCtrl+W⌘+W

What is different in Excel for the web?

Excel for the web runs inside the browser, so shortcuts that the browser claims come first: Ctrl + F opens the browser search unless Excel has focus in the grid, Ctrl + W closes the tab, Ctrl + P prints the page. Most cell shortcuts (Ctrl + Arrow, Ctrl + Shift + Arrow, F2, Ctrl + 1, Alt + =) work; the Alt ribbon sequences (Alt, then letters) do not. Use Alt + Q or the Tell Me box to run a command by name instead.

Browser-based test simulations go further: Criteria states that most selection and command shortcuts, including Ctrl + Shift + Arrow and Ctrl + C, are not supported in its simulation, while arrow keys and Enter are; SHL-type tests disable many shortcuts as well. Practise the mouse route to each command as well as the keys.

Which shortcuts do Excel tests ask about?

Multiple-choice screenings ask about shortcuts directly: iMocha's basic test lists keyboard shortcuts as a topic, Mettl's intermediate test asks for the AutoSum shortcut, and CFI's free test asks what F4 and F2 do. Investment-banking modeling guides expect keyboard-only speed and name Ctrl + Shift + Arrow, Ctrl + Alt + V, Ctrl + 1, F2, F4 and Alt + = specifically.

In our exercises every shortcut in the grid works on both platforms, and the Check button has one too: Ctrl + Enter on Windows, ⌘ + Enter on Mac.

Questions about Excel shortcuts

What is the shortcut to lock a cell reference in Excel?

F4 while editing the formula, with the cursor in the reference. Each press cycles B1 to $B$1, B$1, $B1 and back. On a Mac, ⌘ + T or Fn + F4.

What is the shortcut for AutoSum?

Alt + = on Windows, ⌘ + Shift + T on Mac. It inserts a SUM over the numbers above or to the left of the selected cell.

Do Excel shortcuts work on a Mac?

Most do, with ⌘ in place of Ctrl for file and clipboard commands and ⌃ for many cell commands. The Alt ribbon sequences (Alt, then letters) are Windows only; on a Mac use the menu bar or the ribbon with the mouse.

Do shortcuts work in Excel for the web?

Cell shortcuts mostly do; ribbon key sequences do not, and a few keys go to the browser first. Test simulations that run in the browser disable more of them, so know the mouse route too.

Try it in a real spreadsheet

Free, no account and nothing to install.

Excel is a trademark of the Microsoft group of companies. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria and other marks are the property of their owners. GridBelt is independent and is not affiliated with, endorsed by or sponsored by any of them.