Excel reference

Excel Shortcuts

Every Excel shortcut from the library, in one place. Search, jump by letter, or filter by topic — then open any item for the full example.

237 Shortcuts listed
237 Windows keys
203 Mac keys
17 A–Z groups

Directory

Browse all shortcuts

Filter the full set without paging through the old category archive.

A

Shortcut Windows Mac
Accept and Apply Enter Return
Accept Function With Auto-Complete Tab Tab
Activate Access key Alt —
Activate Filter Alt + Down Arrow Alt + Down Arrow
Activate or Open Selected Control Space OR Enter Space
Add all Borders to all Cells in Selection Alt + H, B A —
Add Border Around Selected Cells Ctrl + Shift + & —
Add Non-Adjacent Cells to Selection Ctrl + Click Cmd + Click
Add or Remove Bottom Border Alt + H, B O Cmd + Alt + ↓
Add or Remove Left Border Alt + H, B L Cmd + Alt + ←
Add or Remove Right Border Alt + H, B R Cmd + Alt + →
Add or Remove top Border Alt + H, B P —
Align Bottom Alt + H, A B —
Align Center Alt + H, A C Cmd + E
Align left Alt + H, A L Cmd + L
Align Middle Alt + H, A M —
Align Right Alt + H, A R Cmd + R
Align Top Alt + H, A T —
Apply Currency Format Ctrl + Shift + $ Ctrl + Shift + $
Apply Date Format Ctrl + Shift + # Ctrl + Shift + #
Apply General Format Ctrl + Shift + ( ~ ) Ctrl + Shift + ( ~ )
Apply Number Format Ctrl + Shift + ! Ctrl + Shift + !
Apply or Remove Bold Ctrl + B Cmd + B
Apply or Remove Italics Ctrl + I Cmd + I
Apply or Remove Strikethrough Ctrl + 5 —
Apply or Remove Underscore Ctrl + U Cmd + U
Apply Percentage Format Ctrl + Shift + % Ctrl + Shift + %
Apply Scientific Format Ctrl + Shift + ( ^ ) Ctrl + Shift + ( ^ )
Apply Time Format Ctrl + Shift + @ Ctrl + Shift + @
Autosum Alt + = Cmd + Shift + T

C

Shortcut Windows Mac
Calculate Active Worksheet Shift + F9 Fn + Shift + F9
Calculate Worksheets F9 Fn + F9
Cancel 'Extend Selection' Mode Esc Esc
Cancel and Close the Dialog box Esc Esc
Cancel Editing Esc —
Check and Uncheck box Space Space
Clear Print Area Alt + P , R C —
Clear Slicer Filter Alt + A + C Alt + C
Close Current Workbook Ctrl + F4 or W Cmd + W
Close Excel Alt + F4 Cmd + Q
Confirm Control Change Enter Return
Copy Formula From Cell Above Ctrl + ( ' ) Cmd + ( ' )
Copy Selection Ctrl + C Ctrl + C
Copy Value From Cell Above Ctrl + Shift + ( " )  Ctrl + Shift +(  " )
Create name from values in row Ctrl + Shift + F3 —
Create Pivot Table Alt + N, V —
Create Table Ctrl + T or Ctrl + L cmd + T
Cut Selection Ctrl + X Ctrl + X

D

Shortcut Windows Mac
Decrease font Size one Step Alt + H, F K —
Delete Character to Left of Cursor Backspace Delete
Delete Character to Right of Cursor Delete Fn + Delete
Delete Comment Shift + F10, M —
Delete Contents of Selected Cells Delete Fn + Delete
Delete Current Worksheet Alt + E, L —
Delete Selected Number of Columns Ctrl + ( - ) Cmd + ( - )
Delete Selected Number of Rows Ctrl + ( - ) Cmd + ( - )
Delete to End of Line Ctrl + Delete Fn + Ctrl + Delete
Display AutoComplete List Alt + ↓ Alt + ↓
Display Control Menu Alt + Space —
Display Delete Dialog box Ctrl + ( - ) Cmd + ( - )
Display Format Clls With Font tab Selected Ctrl + Shift + F Ctrl + Shift + F
Display Function Arguments Dialog box Ctrl + A Ctrl + A
Display go to Dialog box Ctrl + G OR F5 Ctrl + G
Display Insert Dialog box Ctrl + ( + ) Cmd + Shift + ( + )
Drag and Copy Ctrl + Drag Alt + Drag
Drag and cut Drag Drag
Drag and Insert Shift + Drag Shift + Drag
Drag and Insert Copy Ctrl + Shift + Drag Alt + Shift + Drag
Drag to Duplicate Worksheet Ctrl + Drag Alt + Drag
Drag to Worksheet Alt + Drag Cmd + Drag
Duplicate Object Ctrl + D cmd + D

E

Shortcut Windows Mac
Edit the Active Cell F2 Ctrl + U
Enter Array Formula Ctrl + Shift + Enter Ctrl + Shift + Retrun
Enter Data and Move Down Enter Return
Enter Data and Move Left Shift + Tab Shift + Tab
Enter Data and Move Right Tab Tab
Enter Data and Move up Shift + Enter Shift + Return
Enter Data and Stay in Same Cell Ctrl + Enter Ctrl + Return
Enter Same Data in Multiple Cells Ctrl + Enter Ctrl + Return
Evaluate Part of a Formula F9 Fn + F9
Excel Shortcuts: Create new Workbook Ctrl + N Cmd + N
Exit 'Add to Selection' Mode Esc Esc
Expand or Collapse Ribbon Ctrl + F1 Cmd + Alt + R
Expand or Collapse the Formula bar Ctrl + Shift + U Ctrl + Shift + U
Expand Selection Shift + Click Shift + Click
Extend Selection Down Shift + ↓ Shift + ↓
Extend Selection Down one Screen Shift + PgDn Fn + Shift + ↓
Extend Selection Left Shift + ← Shift + ←
Extend Selection Left one Screen Alt + Shift + PgUp Fn + Shift + Alt + ↑
Extend Selection Right Shift + →  Shift + →
Extend Selection Right one Screen Alt + Shift + PgDn Fn + Shift + Alt + ↓
Extend Selection to First Cell in Worksheet Ctrl + Shift + Home Fn + Ctrl + Shift + ←
Extend Selection to Last Cell in Worksheet Ctrl + Shift + End Fn + Ctrl + Shift + →
Extend Selection to Start of row Shift + Home Fn + Shift + ←
Extend Selection up Shift + ↑ Shift + ↑
Extend Selection up one Screen Shift + PgUp Fn + Shift + ↑
Extend the Selection to the Last Cell Down Ctrl + Shift + ↓ Cmd + Shift + ↓
Extend the Selection to the Last Cell on the Left Ctrl + Shift + ← Cmd + Shift + ←
Extend the Selection to the Last Cell on the Right Ctrl + Shift + → Cmd + Shift + →
Extend the Selection to the Last Cell up Ctrl + Shift + ↑ Cmd + Shift + ↑

F

Shortcut Windows Mac
Fill Down From Cell Above Ctrl + D Cmd + D
Fill Right From Cell on Left Ctrl + R Cmd + R
Find and Replace Ctrl + F cmd+F
Find and Replace with Replace Selected Ctrl + H Ctrl+H
Find Next Match Shift+F4 cmd+G
Find Previous Match Ctrl+Shift+F4 cmd+Shift+G
Flash Fill Ctrl + E Ctrl + E
Force Calculate all Worksheets Ctrl + Alt + F9 —
Format Cells Ctrl + 1 Cmd + 1

G

Shortcut Windows Mac
Get Help on Selected Control F1 —
Go to Next Workbook Ctrl + Tab Cmd + [ ' ]
Go to Next Worksheet Ctrl + PgDn Fn + ⌃ + ↓
Go to Previous Worksheet Ctrl + PgUp Fn + ⌃ + ↑
Go to the Previous Workbook Ctrl + Shift + Tab Cmd +Shift + [ ' ]
Group Pivot Table Items Alt + Shift + → Cmd + Shift + K
Group Rows or Columns Alt + Shift + → Cmd + Shift + K

H

Shortcut Windows Mac
Hide (Filter Out) Pivot Table Item Ctrl + ( - ) Ctrl + ( - )
Hide Columns Ctrl + ( 0 ) Ctrl + ( 0 )
Hide or Show Objects Ctrl + 6 (^) Ctrl + 6 (^)
Hide or Show Outline Symbols Ctrl + ( 8 ) Ctrl + ( 8)
Hide Rows Ctrl + ( 9 ) Ctrl + ( 9 )

I

Shortcut Windows Mac
Increase Font Size one Step Alt + H, F G —
Indent Alt + H + 6 Ctrl + Alt + Tab
Insert a Chart in a New Sheet F11 Fn + F11
Insert Current Date Ctrl + ; Ctrl + ;
Insert Current Time Ctrl + Shift + : Cmd + ;
Insert Embedded Chart Alt + F1 Fn + Alt + F1
Insert Function Arguments Ctrl + Shift + A Ctrl + Shift + A
Insert Hyperlink Ctrl + K Cmd + K
Insert New Worksheet Shift + F11 —
Insert or Edit Comment Shift + F2 —
Insert Pivot Chart Alt + N, S Z C —
Insert Selected Number of Columns Ctrl + ( + ) Cmd + Shift + ( + )
Insert Selected Number of Rows Ctrl + ( + ) Cmd + Shift + ( + )

M

Shortcut Windows Mac
Maximize Current Workbook Window Ctrl + F10 Fn + Ctrl + F10
Minimize Current Workbook Window Ctrl + F9 Cmd + M
Move Active Cell Clockwise to Corners of Selection Ctrl + . Ctrl + .
Move Active Cell Down in Selection Enter Return
Move Active Cell Left in a Selection Shift + Tab Shift + Tab
Move Active Cell Right in a Selection Tab Tab
Move Active Cell up in Selection Shift + Enter Shift + Return
Move Current Worksheet Alt + E, M —
Move Left Between Non-Adjacent Selections Ctrl + Alt + ← Ctrl + Alt + ←
Move one Cell Down ↓ ↓
Move one Cell Left ← ←
Move one Cell Right → →
Move one Cell up ↑ ↑
Move one Screen Down PgDn Fn + ↓
Move one Screen Left Alt + PgDn Fn + Alt + ↑
Move one Screen Right Alt + PgDn Fn + Alt + ↓
Move one Screen up PgUp Fn + ↑
Move One Word Left Ctrl + ← Ctrl + ←
Move One Word Right Ctrl + → Ctrl + →
Move Right Between Non-Adjacent Selections Ctrl + Alt + → Ctrl + Alt + →
Move to Beginning of row Home Fn + ←
Move to Bottom Edge of Data Region Ctrl + ↓ Cmd + ↓
Move to First Cell in Worksheet Ctrl + Home Fn + Ctrl + ←
Move to Last Cell in Worksheet That Contains Data Ctrl + End Fn + Ctrl + →
Move to Left Edge of Data Region Ctrl + ← Cmd + ←
Move to Next Control Tab Tab
Move to Next Pane F6 OR Shift + F6 —
Move to Next Tab Ctrl + Tab Ctrl + Tab
Move to Previous Control Shift + Tab Shift + Tab
Move to Previous Tab Ctrl + Shift + Tab Ctrl + Shift + Tab
Move to Right Edge of Data Region Ctrl + → Cmd + →
Move to top Edge of Data Region Ctrl + ↑ Cmd + ↑

O

Shortcut Windows Mac
Open Group Dialog Box Alt + Shift + → Cmd + Shift + K
Open help F1 cmd + /
Open List of Border Styles From Ribbon Alt + H, B —
Open Macro Dialogue Box Alt + F8 Fn + Alt + F8
Open Modify Cell Style Dialogue Box Alt + ' cmd + Shift + L
Open Name Manager Ctrl + F3 Fn + Ctrl + F3
Open Print Preview Window Ctrl + F2 —
Open the Insert Function Dialog Box Shift + F3 Fn + Shift + F3
Open Thesaurus Shift + F7 Fn + Shift + F7
Open Ungroup Dialog box Alt + Shift + ← Cmd + Shift + J
Open VBA Editor Alt + F11 Fn + Alt + F11
Open Workbook Ctrl + O Cmd + O

P

Shortcut Windows Mac
Paste Content Ctrl + V Ctrl + V
Paste Name Into Formula F3 F3
Paste Special Ctrl + Alt + V cmd+Ctrl+V
Press Again to Select Entire Worksheet Ctrl + A Cmd + A
Print Ctrl + P Cmd + P
Protect Sheet Alt + R , P S —
Protect workbook Alt + R, P W —

R

Shortcut Windows Mac
Redo Ctrl + Y cmd + Y
Remove Borders Ctrl + Shift + - Cmd + Alt + -
Remove Indent Alt + H, 5 Ctrl + Alt + Shift + Tab
Rename Current Worksheet ALT+O H R —
Repeat Last Action F4 cmd+Y
Run Spellcheck F7 Fn + F7

S

Shortcut Windows Mac
Save as F12 Cmd + Shift + S
Save Workbook Ctrl + S Cmd + S
Select Active Cell Shift + Backspace Shift + Delete
Select Adjacent Worksheets Ctrl + Shift + PgUp/PgDn —
Select all Dependents Ctrl + Shift + } Ctrl + Shift + }
Select all Precedents Ctrl + Shift + { Ctrl + Shift + {
Select Cells With Comments Ctrl + Shift + O Fn + Ctrl + Shift + O
Select Current Region Ctrl + A Cmd + A
Select Current Region Around Active Cell Ctrl + Shift + ( * ) Ctrl + Shift + Space
Select Direct Dependents Ctrl + ] Ctrl + ]
Select Direct Precedents Ctrl + [ Ctrl + [
Select Entire Column Ctrl + Space Ctrl + Space
Select Entire Pivot Table Ctrl + A Cmd + A
Select Entire row Shift + Space Shift + Space
Select Non-adjacent Worksheets Ctrl + Click Cmd + Click
Select One Character Left Shift + ← Shift + ←
Select One Character Right Shift + → Shift + →
Select One Word Left Ctrl + Shift + ← Ctrl + Shift + ←
Select One Word Right Ctrl + Shift + → Ctrl + Shift + →
Select Table Ctrl + A cmd + A
Select Table Column Ctrl + Space Ctrl + Space
Select Table Row Shift + Space Shift + Space
Select to Beginning of Cell Shift + Home Fn + Shift + ←
Select to End of Cell Shift + End Fn + Shift + →
Select Visible Cells Only Alt +( ; ) Cmd + Shift + Z
Set Print Area Alt + P, R S —
Show Right-click Menu Shift + F10 Fn + Shift + F10
Show the Active Cell on Worksheet Ctrl + Backspace Ctrl + Delete
Snap to Grid Alt Alt
Start a New Line in the Same Cell Alt + Enter —

T

Shortcut Windows Mac
Toggle 'Add to Selection' Mode Shift + F8 Fn + Shift + F8
Toggle 'Extend Selection' Mode F8 Fn + F8
Toggle Absolute and Relative References F4 Cmd + T
Toggle Auto filter Ctrl + Shift + L  or Alt + A + T cmd + Alt + F
Toggle Displaying Formulas on and off Ctrl + ( ` ) Ctrl + ( ` )
Toggle Full Screen Ctrl + Shift + F1 Ctrl + Cmd + F
Toggle Scroll Lock ScrLk Fn + Shift + F14
Turn End Mode on End Fn + →

U

Shortcut Windows Mac
Undo Ctrl + Z cmd +  Z
Ungroup Pivot Table Items Alt + Shift + ← Cmd + Shift + J
Ungroup Rows or Columns Alt + Shift + ← Cmd + Shift + J
Unhide (Clear Filter on) Pivot Table Item Alt + H, S C —
Unhide Rows Ctrl + Shift + ( 9 ) Ctrl + Shift + ( 9 )

W

Shortcut Windows Mac
Wrap Text Alt + H, W —

Z

Shortcut Windows Mac
Zoom in Ctrl + Alt + [+] Alt + Cmd + [+]
Zoom Out Ctrl + Alt + - Alt + Cmd + -