Excel Shortcuts List for Mac and PC (Searchable)
How to Use this Shortcut List:
+ Indicates to hold the previous key, while pressing the next key.
> Indicates to tap the previous key, releasing it before pressing the next key.
Find the shortcuts list below:
# | Description | PC Shortcut | Mac Shortcut | |
---|---|---|---|---|
Basic Shortcuts | ||||
1 | Save Workbook |
Ctrl+S
|
⌘+S
|
|
2 | Save As |
F12
|
⌘+⇧+S
|
|
3 |
Ctrl+P
|
⌘+P
|
||
4 | Create New Workbook |
Ctrl+N
|
⌘+N
|
|
5 | Open Workbook |
Ctrl+O
|
⌘+O
|
|
6 | Open Print Preview |
Ctrl+F2
|
⌘+P
|
|
7 | Close Workbook |
Ctrl+F4
|
⌘+W
|
|
8 | Close Excel |
ALT+F4
|
⌘+Q
|
|
9 | Undo Previous Action |
Ctrl+Z
|
⌘+Z
|
|
10 | Redo Previous Action |
Ctrl+Y
|
⌘+Y
|
|
11 | Open Help |
F1
|
⌘+/
|
|
12 | Clear Cell Contents |
Delete
|
fn+Delete
|
|
13 | Clear Cell Formatting |
ALT>H>E>F
|
||
14 | Clear All |
ALT>H>E>A
|
||
Number Formatting Shortcuts | ||||
15 | Apply General Format |
Ctrl+Shift+
|
^+⇧+
|
|
16 | Apply Number Format |
Ctrl+Shift+!
|
^+⇧+!
|
|
17 | Apply Time Format |
Ctrl+Shift+@
|
^+⇧+@
|
|
18 | Apply Date Format |
Ctrl+Shift+#
|
^+⇧+#
|
|
19 | Apply Currency Format |
Ctrl+Shift+$
|
^+⇧+$
|
|
20 | Apply Percentage Format |
Ctrl+Shift+%
|
^+⇧+%
|
|
21 | Apply Scientific Format |
Ctrl+Shift+^
|
^+⇧+^
|
|
Viewing Shortcuts | ||||
22 | Close Window |
Ctrl+WCtrl+F4
|
⌘+W
|
|
23 | Restore Window Size |
Ctrl+F5
|
||
24 | Next Window |
Ctrl+F6
|
||
25 | Move Window |
Ctrl+F7
|
||
26 | Resize Window |
Ctrl+F8
|
||
27 | Minimize Window |
Ctrl+F9
|
^+F9
|
|
28 | Maximize / Restore Window |
Ctrl+F10
|
⌘+F10
|
|
29 | Next Pane |
F6
|
||
30 | Previous Pane |
Shift+F6
|
||
31 | Full Screen Mode |
ALT>V>U
|
⌘+^+F
|
|
32 | Exit Full Screen |
Esc
|
Esc
|
|
33 | Rotate or Flip Screen |
Ctrl+ALT+↓
|
n/a
|
|
34 | Take Screenshot |
Print
|
⌘+⇧+3
|
|
View Mode Shortcuts | ||||
35 | Toggle Formula View Mode |
Ctrl+`
|
^+`
|
|
36 | Open Print Preview |
Ctrl+F2
|
⌘+P
|
|
37 | Expand Or Collapse Ribbon |
Ctrl+F1
|
⌘+⌥+R
|
|
38 | Expand Or Collapse The Formula Bar |
Ctrl+Shift+U
|
^+⇧+U
|
|
Copy, Cut, and Paste Shortcuts | ||||
39 | Copy |
Ctrl+C
|
⌘+C
|
|
40 | Cut |
Ctrl+X
|
⌘+X
|
|
41 | Paste |
Ctrl+V
|
⌘+V
|
|
42 | Open Paste Special Dialog Box |
Ctrl+ALT+V
|
Ctrl+⌘+V
|
|
43 | Paste Value |
Ctrl+ALT+V>V>Enter
|
Ctrl+⌘+V>⌘+V>Return
|
|
44 | Paste Format |
Ctrl+ALT+V>T>Enter
|
Ctrl+⌘+V>⌘+T>Return
|
|
45 | Paste & Transpose |
Ctrl+ALT+V>E>Enter
|
Ctrl+⌘+V>⌘+E>Return
|
|
46 | Paste & Skip Blanks |
Ctrl+ALT+V>B>Enter
|
Ctrl+⌘+V>⌘+B>Return
|
|
Borders Shortcuts | ||||
47 | Add Outline Border |
Ctrl+Shift+&
|
⌘+⌥+0
|
|
48 | Add Or Remove Top Border |
ALT>H>B>T
|
⌘+⌥+↑
|
|
49 | Add Or Remove Bottom Border |
ALT>H>B>B
|
⌘+⌥+↓
|
|
50 | Add Or Remove Right Border |
ALT>H>B>R
|
⌘+⌥+→
|
|
51 | Add Or Remove Left Border |
ALT>H>B>L
|
⌘+⌥+←
|
|
52 | Remove Borders |
Ctrl+Shift+_
|
⌘+⌥+_
|
|
Formatting Shortcuts | ||||
53 | Open Format Cells Dialog Box |
Ctrl+1
|
⌘+1
|
|
54 | Repeat Previous Format |
F4
|
^+Y
|
|
55 | Toggle Bold Formatting |
Ctrl+B
|
⌘+B
|
|
56 | Toggle Italic Formatting |
Ctrl+I
|
⌘+I
|
|
57 | Toggle Underline |
Ctrl+U
|
⌘+U
|
|
58 | Toggle Strikethrough |
Ctrl+5
|
⌘+⇧+X
|
|
59 | Apply Superscript Formatting |
Ctrl+Shift+F>ALT+E
|
||
60 | Apply Subscript Formatting |
Ctrl+Shift+F>ALT+B
|
||
61 | Wrap Text |
ALT>H>W
|
||
62 | Merge Cells |
ALT>H>M
|
||
63 | Align Center |
ALT>H>A>C
|
⌘+E
|
|
64 | Align Left |
ALT>H>A>L
|
⌘+L
|
|
65 | Align Right |
ALT>H>A>R
|
⌘+R
|
|
66 | Indent |
ALT>H>6
|
^+⌥>Tab
|
|
67 | Remove Indent |
ALT>H>5
|
^+⌥>⇧+Tab
|
|
68 | Increase Font Size |
ALT>H>F>G
|
⌘+⇧+>
|
|
69 | Decrease Font Size |
ALT>H>F>K
|
⌘+⇧+
< | |
70 | Apply Conditional Formatting |
ALT>H>L
|
||
71 | Format Painter |
Ctrl+ALT+V
|
||
72 | Highlight Cell |
ALT>H>H
|
||
73 | Fill Color |
ALT>H>H
|
||
Pivot Table Shortcuts | ||||
74 | Open Pivot Table Wizard |
ALT>N>V
|
⌘+⌥>P
|
|
75 | Create Pivot Chart On Same Worksheet |
ALT+F1
|
||
76 | Create Pivot Chart On New Worksheet |
F11
|
fn+F11
|
|
77 | Select Entire Pivot Table |
Ctrl+A
|
⌘+A
|
|
78 | Group Pivot Table Items |
ALT+Shift+→
|
⌘+⇧+K
|
|
79 | Ungroup Pivot Table Items |
ALT+Shift+←
|
⌘+⇧+J
|
|
80 | Hide Pivot Table Item |
Ctrl+-
|
Ctrl+-
|
|
81 | Toggle Pivot Table Field Checkbox |
Space
|
Space
|
|
Entering Data Shortcuts | ||||
82 | Enter Text And Move Down |
Enter
|
Return
|
|
83 | Enter Text And Move Right |
Tab
|
Tab
|
|
84 | Enter Text And Move Up |
Shift+Enter
|
⇧+Return
|
|
85 | Enter Text And Move Left |
Shift+Tab
|
⇧+Tab
|
|
86 | Complete Entry And Stay In Same Cell |
Ctrl+Enter
|
^+Return
|
|
87 | Enter Same Data In Multiple Cells |
Ctrl+Enter
|
^+Return
|
|
88 | Copy Formula From Cell Above |
Ctrl+'
|
^+'
|
|
89 | Copy Value From Cell Above |
Ctrl+Shift+"
|
^+⇧+"
|
|
90 | Add Hyperlink |
Ctrl+K
|
⌘+K
|
|
91 | Insert Current Date |
Ctrl+;
|
^+;
|
|
92 | Insert Current Time |
Ctrl+Shift+:
|
^+⇧+:
|
|
93 | Display Autocomplete List |
ALT+↓
|
⌥+↓
|
|
94 | Flash Fill |
Ctrl+E
|
||
95 | Fill Down |
Ctrl+D
|
^+D
|
|
96 | Fill Right |
Ctrl+R
|
^+R
|
|
Navigation Shortcuts | ||||
97 | Move One Cell |
→
|
→
|
|
98 | Move to Edge of Data Region |
Ctrl+→
|
⌘+→
|
|
99 | Move One Screen Up |
PgUp
|
fn+↑
|
|
100 | Move One Screen Down |
PgDn
|
fn+↓
|
|
101 | Move One Screen Right |
ALT+PgDn
|
fn+⌥>↑
|
|
102 | Move One Screen Left |
ALT+PgUp
|
fn+⌥>↓
|
|
103 | Move To Beginning Of Row |
Home
|
fn+←
|
|
104 | Move To First Cell In Worksheet |
Ctrl+Home
|
fn+^+←
|
|
105 | Move To Last Used Cell In Worksheet |
Ctrl+End
|
fn+^+→
|
|
106 | Turn End Mode On |
End
|
fn+→
|
|
Creating Formulas Shortcuts | ||||
107 | Open The Insert Function Dialog Box |
Shift+F3
|
fn+⇧+F3
|
|
108 | Cycles Through Absolute And Relative References |
F4
|
⌘+T
|
|
109 | Insert Function Arguments into Cell |
Ctrl+Shift+A
|
^+⇧+A
|
|
110 | Open The Insert Function Dialog Box From Within Cell |
Ctrl+A
|
^+A
|
|
111 | Sum Selected Cells |
ALT+=
|
⌘+⇧+T
|
|
112 | Calculate Part of a Formula |
F9
|
fn+F9
|
|
113 | Create Array Formula |
Ctrl+Shift+Enter
|
^+⇧+Return
|
|
Named Range Shortcuts | ||||
114 | Open Name Manager Dialog Box |
Ctrl+F3
|
^+L
|
|
115 | Insert Named Range Into Formula |
F3
|
n/a
|
|
116 | Create Name Based on Row and Column Headings |
Ctrl+Shift+F3
|
^+⇧+F3
|
|
Calculation Shortcuts | ||||
117 | Calculate Now |
F9
|
fn+F9
|
|
118 | Calculate Active Sheet |
Shift+F9
|
fn+⇧+F9
|
|
119 | Force Calculate |
Ctrl+ALT+F9
|
n/a
|
|
120 | Manual Calculation |
ALT>M>X>M
|
n/a
|
|
121 | Turn on Automatic Calculation |
ALT>M>X>A
|
n/a
|
|
122 | Refresh |
F9
|
fn+F9
|
|
123 | Autosum Selected Cells |
ALT+=
|
⌘+⇧+T
|
|
Dialog Box Navigation Shortcuts | ||||
124 | Toggle Checkbox |
Space
|
Space
|
|
125 | Apply Changes and Close the Dialog Box |
Enter
|
Return
|
|
126 | Cancel Changes and Close the Dialog Box |
Esc
|
Esc
|
|
127 | Next Control |
Tab
|
Tab
|
|
128 | Previous Control |
Shift+Tab
|
⇧+Tab
|
|
129 | Next Tab |
Ctrl+Tab
|
^+Tab
|
|
130 | Previous Tab |
Ctrl+Shift+Tab
|
^+⇧+Tab
|
|
Spreadsheet Review Shortcuts | ||||
131 | Toggle Formula View Mode |
Ctrl+`
|
^+`
|
|
132 | trace precedents |
ALT>M>P
|
n/a
|
|
133 | trace dependents |
ALT>M>D
|
n/a
|
|
Cell Editting Shortcuts | ||||
134 | Edit The Active Cell |
F2
|
^+U
|
|
135 | Toggle Between Cell Edit Mode and Cell Enter Mode |
F2
|
^+U
|
|
136 | Save Changes and Exit Cell Edit Mode |
Enter
|
||
137 | Cancel Entry and Exit Cell Edit Mode |
Esc
|
Esc
|
|
138 | Go to Beginning of Cell |
Home
|
fn+←
|
|
139 | Go to End of Cell |
End
|
fn+→
|
|
140 | Select Character |
Shift+→
|
⇧+→
|
|
141 | Move One Word to Right or Left |
Ctrl+→
|
⌥+→
|
|
142 | Select One Word to Right or Left |
Ctrl+Shift+→
|
⌥+⇧+→
|
|
143 | Delete Character to Right of Cursor |
Delete
|
fn+Delete
|
|
144 | Delete Character to the Left of Cursor |
Backspace
|
Delete
|
|
145 | Insert New Line Break Within Cell |
ALT+Enter
|
^+⌥+Return
|
|
146 | Insert Or Edit Comment |
Shift+F2
|
fn+⇧+F2
|
|
Ribbon Shortcuts | ||||
147 | Expand Or Collapse Ribbon |
Ctrl+F1
|
⌘+⌥+R
|
|
148 | Activate Ribbon Shortcut Keys |
ALT
|
^+F2
|
|
149 | Move To Next Ribbon Control |
Tab
|
Tab
|
|
150 | Activate Selected Control |
Space
|
Space
|
|
151 | Confirm Control Change |
Enter
|
Return
|
|
152 | Cancel Control Change |
Esc
|
Esc
|
|
153 | Get Help On Selected Control |
F1
|
||
Workbook Shortcuts | ||||
154 | Insert New Worksheet |
Shift+F11
|
⇧+F11
|
|
155 | Go To Next Worksheet (Tab) |
Ctrl+PgDn
|
fn+^+↓
|
|
156 | Go To Previous Worksheet (Tab) |
Ctrl+PgUp
|
fn+^+↑
|
|
157 | Move To Next Pane |
F6
|
F6
|
|
158 | Move To Previous Pane |
Shift+F6
|
⇧+F6
|
|
159 | Go To Next Workbook |
Ctrl+Tab
|
^+Tab
|
|
160 | Go To Previous Workbook |
Ctrl+Shift+Tab
|
^+⇧+Tab
|
|
161 | Minimize Current Workbook Window |
Ctrl+F9
|
⌘+M
|
|
162 | Maximize Current Workbook Window |
Ctrl+F10
|
n/a
|
|
163 | Switch Tabs |
Ctrl+PgUpPgDn
|
fn+^+↑or↓
|
|
Selection Shortcuts | ||||
164 | Select Current Region (Possibly Entire Worksheet) |
Ctrl+A
|
⌘+A
|
|
165 | Select Visible Cells Only |
ALT+;
|
⌘+⇧+Z
|
|
166 | Select Cells With Comments |
Ctrl+Shift+O
|
fn+^+⇧+O
|
|
167 | Display 'Go To' Dialog Box |
Ctrl+G
|
^+G
|
|
168 | Select Region Directly Around Active Cell |
Ctrl+Shift+0
|
⇧+^+Space
|
|
169 | Select Current Array |
Ctrl+/
|
^+/
|
|
170 | Select Row Differences |
Ctrl+\
|
^+\
|
|
171 | Select Column Differences |
Ctrl+Shift+|
|
^+⇧+|
|
|
172 | Select All Precedents |
Ctrl+Shift+{
|
^+⇧+{
|
|
173 | Select All Dependents |
Ctrl+Shift+}
|
^+⇧+}
|
|
174 | Select Direct Precedents |
Ctrl+[
|
^+[
|
|
175 | Select Direct Dependents |
Ctrl+]
|
^+]
|
|
Misc. Shortcuts | ||||
176 | Find |
Ctrl+F
|
⌘+F
|
|
177 | Find and Replace |
Ctrl+H
|
^+H
|
|
178 | Find Previous Match |
Ctrl+Shift+F4
|
⌘+fn+F
|
|
179 | Find Next Match |
Shift+F4
|
⌘+F
|
|
180 | Insert Chart |
ALT+F1
|
fn+⌥+F1
|
|
181 | Insert Chart in New Worksheet |
F11
|
F11
|
|
182 | Toggle Autofilter |
Ctrl+Shift+L
|
⌘+⇧+F
|
|
183 | Activate Filter |
ALT+↓
|
⌥+↓
|
|
184 | Create Table |
Ctrl+T
|
^+T
|
|
185 | Open Visual Basic ( VBA ) Editor |
ALT+F11
|
⌥+fn+F11
|
|
186 | Open Macros |
ALT+F8
|
⌥+fn+F8
|
|
187 | Stop Running Macro |
Ctrl+Pause
|
⌘+.
|
|
Worksheet Shortcuts | ||||
188 | Insert Row |
Ctrl+
|
^+I
|
|
189 | Insert Column |
Ctrl+
|
^+I
|
|
190 | Delete Row |
Ctrl+-
|
^+-
|
|
191 | Delete Column |
Ctrl+-
|
^+-
|
|
192 | Delete Cell |
Ctrl+-
|
^+-
|
|
193 | Hide Column |
Ctrl+0
|
^+0
|
|
194 | Hide Row |
Ctrl+9
|
^+9
|
|
195 | Unhide Row |
Ctrl+Shift+9
|
^+⇧+9
|
|
196 | Unhide Column |
Ctrl+Shift+0
|
^+⇧+0
|
|
197 | Display Insert Dialog Box |
Ctrl+
|
^+I
|
|
198 | Display Delete Dialog Box |
Ctrl+-
|
^+-
|
|
199 | Group Rows Or Columns |
ALT+Shift+→
|
⌘+⇧+K
|
|
200 | Ungroup Rows Or Columns |
ALT+Shift+←
|
⌘+⇧+J
|
|
201 | Select Entire Row |
Shift+Space
|
⇧+Space
|
|
202 | Select Entire Column |
Ctrl+Space
|
^+Space
|
|
203 | Select Entire Worksheet |
Ctrl+A
|
⌘+A
|
|
204 | Toggle Add To Selection Mode |
Shift+F8
|
fn+⇧+F8
|
|
Mouse Shortcuts | ||||
205 | Zoom In / Zoom Out |
Ctrl+Mouse
|
^+Mouse
|
|
206 | Drag And Copy |
Ctrl+Drag
|
⌥+Drag
|
|
207 | Drag And Cut |
Drag
|
Drag
|
|
208 | Drag And Insert |
Shift+Drag
|
⇧+Drag
|
|
209 | Drag And Insert Copy |
Ctrl+Shift+Drag
|
⌥+⇧+Drag
|
|
210 | Drag To Worksheet |
ALT+Drag
|
⌘+Drag
|
|
211 | Drag To Duplicate Worksheet |
Ctrl+Drag
|
⌥+Drag
|