Excel Shortcuts List for Mac and PC (Searchable)

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