Cheat sheets

Excel keyboard shortcuts on macOS

These Excel shortcuts never reach its menu bar, so reading the menus won't find them. Hold ⌘ and Keysi shows them next to everything it reads from Excel's own menus.

29 shortcuts · adds to what Keysi reads from the app's own menus · free, and not part of Keysi Pro.

Open in Keysi Don't have Keysi? Download free

Shows this sheet in Keysi's Settings ▸ Shortcuts, where it's already installed.

Moving around the sheet

ActionKeys
Jump to the edge of the data⌘↓
Select to the edge of the data⇧⌘↓
Select the whole column⌃Space
Select the whole row⇧Space
Select the current region⌘A
Next sheet⌃⇟
Previous sheet⌃⇞

Entering data

ActionKeys
Fill down from the cell above⌃D
Fill right from the cell to the left⌃R
Fill the whole selection with this entry⌃↩
Insert today’s date⌃;
Insert the current time⌘;
Edit the active cell⌃U
New line inside the cell⌃⌥↩
AutoSum⌥⇧=

Formulas

ActionKeys
Toggle absolute and relative references⌘T
Show formulas instead of results⌃`
Expand or collapse the formula bar⌃⇧U
Enter as an array formula⌃⇧↩

Formatting

ActionKeys
Currency format⌃⇧$
Percentage format⌃⇧%
Date format⌃⇧#
General format⌃⇧~
Format cells…⌘1

Rows, columns and cells

ActionKeys
Insert cells, rows or columns⌃⇧
Delete cells, rows or columns⌘-
Hide the selected rows⌃9
Hide the selected columns⌃0
Show the hidden rows⌃⇧9

Use this sheet

It's already in Keysi. Install the app and hold ⌘ in Excel.

Keysi lists it as Excel in Settings ▸ Shortcuts.

To change it, download the file below and put it in ~/Library/Application Support/Keysi/Sheets/ (Settings ▸ Shortcuts ▸ “Reveal Sheets Folder”). A sheet with the same id replaces the built-in one, so your edits stick. Or use Keysi's editor and skip the JSON.

Matches the app itself, by bundle identifier: com.microsoft.Excel.

Download the Excel sheet (JSON) Get Keysi — free

Cheat sheets for other apps