Skip to main content

Excel Shortcuts

This page is a complete keyboard shortcut reference for Excel on macOS, covering all 95 shortcuts organized into 12 sections. Whether you’re new to Excel or looking to master advanced features, this cheat sheet has every key combination you need — from basic editing and navigation to app-specific power-user actions.

Keyboard shortcuts are the fastest way to work in Excel. Every time you use a shortcut instead of reaching for the mouse, you save a few seconds — and those seconds compound into hours over weeks and months. Start with the shortcuts you use most (copy, paste, undo, save), then gradually add app-specific ones as they become relevant to your workflow. Bookmark this page or download the PDF cheat sheet for quick reference.

Using keyboard shortcuts in Excel reduces context switching between keyboard and mouse, helping you maintain focus and work more efficiently. Research shows that shortcut-driven workflows can save up to 8 working days per year compared to menu-driven navigation. On macOS, most Excel shortcuts follow standard conventions — once you learn the modifier key patterns, new shortcuts become intuitive.

Tips for Learning Shortcuts

  • Practice one new Excel shortcut each day. Muscle memory builds faster when you focus on a single combination at a time rather than trying to learn them all at once.
  • Print or bookmark this page for quick reference while working in Excel. Having shortcuts visible nearby helps bridge the gap between looking them up and recalling them from memory.
  • Start with the shortcuts you use most. In Excel, common actions like copy, paste, undo, and save are worth learning first since they apply across nearly every workflow.

Frequently used29

ActionShortcut
Paste⌘V
Copy⌘C
Save⌘S
Undo⌘Z
Redo⌘Y
Cut⌘X
Bold⌘B
Print⌘P
Fill Down⌘D
Fill Right⌘R
Insert Cells⌃⇧=
Delete Cells⌘-
Calculate All Workbooks⌘=
Close Window⌘W
Go To⌃G
Format Cells⌘1
Find and Replace⌃H
Paste Special⌃⌘V
Underline⌘U
Italic⌘I
New Workbook⌘N
Save As⇧⌘S
Select All⌘A
Add/Remove Filter⇧⌘F
Expand/Collapse Ribbon⌥⌘R
Open Workbook⌘O
Insert Hyperlink⌘K
Create Names⇧⌘F3
Find⌘F

Windows and dialog boxes3

ActionShortcut
Full Screen⌃⌘F
Minimize Window⌃F9
Hide Excel⌘H

Move and scroll10

ActionShortcut
Move to Edge Up⌘↑
Move to Edge Down⌘↓
Move to Edge Left⌘←
Move to Edge Right⌘→
Move to Beginning⌃Home
Move to Last Cell⌃End
Scroll Screen Right⌥Page Down
Scroll Screen Left⌥Page Up
Next Sheet⌃Page Down
Previous Sheet⌃Page Up

Enter data9

ActionShortcut
Edit CellF2
Confirm Entry↩
New Line in Cell⌥↩
Fill Selected Range⌘↩
Confirm & Move Up⇧↩
Next CellTab
Previous Cell⇧Tab
Insert Note⇧F2
Threaded Comment⇧⌘F2

Cells and Formula bar10

ActionShortcut
Expand Formula Bar⌃⇧U
Array Formula⇧⌘↩
Formula Builder⇧F3
Define Name⌘F3
Toggle Reference Style⌘T
AutoSum⇧⌘T
Enter Date⌃;
Enter Time⌘;
Toggle Formulas⌃`
AutoComplete List⌥↓

Format and edit18

ActionShortcut
Create Table⌘T
Increase Font Size⇧⌘>
Decrease Font Size⇧⌘<
Align Center⌘E
Align Left⌘L
General Format⌃⇧~
Currency Format⌃⇧$
Percentage Format⌃⇧%
Date Format⌃⇧#
Time Format⌃⇧@
Number Format⌃⇧!
Outline Border⌥⌘0
Remove Borders⌥⌘-
Strikethrough⇧⌘X
Hide Column⌘)
Unhide Column⇧⌘)
Hide Row⌘(
Unhide Row⇧⌘(

Select cells6

ActionShortcut
Select Column⌃Space
Select Row⇧Space
Extend to Beginning⌃⇧Home
Extend to Last Cell⌃⇧End
Extend SelectionF8
Add to Selection⇧F8

Work with selection4

ActionShortcut
Delete Selection⌃-
Group Cells⇧⌘K
Ungroup Cells⇧⌘J
Next Corner of Selection⌃.

Charts1

ActionShortcut
Insert ChartF11

Sort and filter1

ActionShortcut
Sort Dialog⇧⌘R

Outline3

ActionShortcut
Toggle Outline Symbols⌃8
Hide Rows (Outline)⌃9
Hide Columns (Outline)⌃0

Drawing1

ActionShortcut
Toggle Drawing Mode⌃⌘Z

Frequently Asked Questions

Access Excel shortcuts from your menu bar

KeyShortcut detects the active app and shows its shortcuts instantly. No memorization needed.