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 Print
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