Excel shortcut keys: a focused Windows and Mac reference

Last updated: 5 Oct 20262 min read

how-to

Excel shortcuts depend on platform, keyboard layout and context; a short tested set is more useful than an undifferentiated key dump.

Move and select

On Windows, Ctrl + Arrow moves to the edge of a data region; Ctrl + Shift + Arrow extends the selection. On Mac, Command + Arrow and Shift + Command + Arrow cover the corresponding navigation pattern. Test the command in a disposable sheet because blanks and merged cells affect the stopping point. Do not use a large selection in a destructive command without checking its borders.

Edit and format

Ctrl + 1 opens Format Cells on Windows; Command + 1 does so on Mac. Ctrl + T creates a table on Windows, while Command + T is available on Mac. F2 edits an active cell in Excel, though function keys on some laptops need an Fn modifier. A table gives filters and structured ranges a clearer boundary. Filtering still requires the headers and data types to be checked.

Work with formulas and filters

On Windows, F4 cycles reference forms when a cell reference is selected in a formula. Ctrl + Shift + L toggles a filter. On Mac, Command + Shift + F or Ctrl + Shift + L can add or remove a filter. Confirm the active application and cell mode first; browser, operating-system and Excel shortcut handlers can compete for the same keys.

Build a personal set

Choose five repeated tasks: move to an edge, select a range, edit a cell, format it and filter a table. Practice each in an expendable workbook and write down the platform that was tested. Sheets shortcuts overlap in places but are not a drop-in substitute for Excel, especially for function keys and browser commands.

Common Mistakes

Do not assume Windows and Mac modifiers are interchangeable.
Do not use F4 reference cycling unless the cursor is on a formula reference.
Do not apply a filter to an incomplete or headerless range.