Excel Keyboard Shortcuts

# Description Windows Mac Web

01. Cells & Ranges: Navigation
Select the first visible cell in the sheet (or
1 Ctrl+Home Fn+Ctrl+← Ctrl+Home
bottom-right of freeze panes)
2 Select the last used cell in the sheet Ctrl+End Fn+Ctrl+→ Ctrl+End
3 Select first cell in the row of the active cell Home Fn+← Home

4 Turn on End Mode (similar to Ctrl+Arrow Keys) End Fn+→ End

Select the first/last cell of a region (non-blank
5 Ctrl+↑ Ctrl+↑ Ctrl+↑
cells) moving up
Select the first/last cell of a region (non-blank
6 Ctrl+→ Ctrl+→ Ctrl+→
cells) moving right
Select the first/last cell of a region (non-blank
7 Ctrl+↓ Ctrl+↓ Ctrl+↓
cells) moving down
Select the first/last cell of a region (non-blank
8 Ctrl+← Ctrl+← Ctrl+←
cells) moving left
Select cell one screen down from the active
9 PgDn Fn+↓ PgDn
cell
10 Select cell one screen up from the active cell PgUp Fn+↑ PgUp
Select cell one screen to the right of the active
11 Alt+PgDn Fn+Alt+↓
cell
Select cell one screen to the left of the active
12 Alt+PgUp Fn+Alt+↑
cell
13 Move one cell up ↑ ↑ ↑
14 Move one cell right → → →
15 Move one cell down ↓ ↓ ↓
16 Move one cell left ← ← ←
17 Go back to hyperlink Ctrl+G,Enter Ctrl+G,Return
18 Open the Find window Ctrl+F Cmd+F Ctrl+F
19 Open the Find & Replace window Ctrl+H Ctrl+H Ctrl+H
20 Find next match Shift+F4 Cmd+G Shift+F4
21 Find previous match Ctrl+Shift+F4 Cmd+Shift+G Ctrl+Shift+F4
02. Cells & Ranges: Formulas
22 Begin entering a formula = OR + = OR + = OR +
Insert function into formula with
23 Tab ↓Tab Tab
autocomplete
24 Edit the active cell F2 Ctrl+U F2
Toggle Enter and Edit modes while editing
25 F2 Ctrl+U F2
formula
26 Exit cell edit mode Esc Esc Esc
27 Toggle absolute and relative references F4 Cmd+T F4
28 AutoSum Alt+= Cmd+Shift+T Alt+=
Open Function Arguments window (when text
29 Ctrl+A Ctrl+A
cursor is inside function)
30 Open the Insert Function window Shift+F3 Fn+Shift+F3 Shift+F3

excelcampus.com/shortcuts 1 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web
Show Formulas instead of Values in cells
31 Ctrl+` Ctrl+`
(toggle)
32 Expand or collapse the formula bar Ctrl+Shift+U Ctrl+Shift+U
33 Calculate worksheets F9 Fn+F9 F9
34 Calculate active worksheet Shift+F9 Fn+Shift+F9
35 Calculate entire workbook Ctrl+Alt+F9 Ctrl+Shift+Alt+F9
36 Insert name into formula F3
37 Open Name Manager window Ctrl+F3 Fn+Ctrl+F3
38 Open Create Names From Selection window Ctrl+Shift+F3 Fn+Ctrl+Shift+F3

39 Enter array formula Ctrl+Shift+Enter Ctrl+Shift+Return

40 Evaluate selected text in a formula F9 Fn+F9 F9
41 Insert function arguments Ctrl+Shift+A Ctrl+Shift+A Ctrl+Shift+A
03. Cells & Ranges: Entering data
42 Open AutoComplete dropdown list Alt+↓ Alt+↓ Alt+↓
Enter and move to next cell (based on
43 Enter Return Enter
direction set in Excel Options)
Enter and move to previous cell (based on
44 Shift+Enter Shift+Return Shift+Enter
direction set in Excel Options)
45 Enter and move right Tab Tab Tab
46 Enter and move left Shift+Tab Shift+Tab Shift+Tab
47 Insert current date Ctrl+; Ctrl+; Ctrl+;
48 Insert current time Ctrl+Shift+: Cmd+;
49 Copy formula from cell above Ctrl+' Ctrl+' Ctrl+'
50 Fill down from cell above Ctrl+D Ctrl+D
51 Fill right Ctrl+R Ctrl+R
52 Flash fill Ctrl+E Ctrl+E
Stay in same cell when editing cell when single
53 Ctrl+Enter Ctrl+Return Ctrl+Enter
cell is selected
Copy data or formula to all selected cells when
54 Ctrl+Enter Ctrl+Return Ctrl+Enter
editing cell
55 Copy value (result of formula) from cell above Ctrl+Shift+" Ctrl+Shift+"
04. Cells & Ranges: Editing Text
56 Enter a line break (new line) in a cell Alt+Enter Ctrl+Alt+Return Alt+Enter
57 Delete character to the left of cursor Backspace Delete Backspace
58 Delete character to the right of cursor Delete Fn+Delete Delete
59 Delete to end of line Ctrl+Delete Ctrl+Delete Ctrl+Delete
60 Move text cursor one word to the right Ctrl+→ Ctrl+→ Ctrl+→
61 Move text cursor one word to the left Ctrl+← Ctrl+← Ctrl+←
62 Select one word right Ctrl+Shift+→ Ctrl+Shift+→ Ctrl+Shift+→
63 Select one word left Ctrl+Shift+← Ctrl+Shift+← Ctrl+Shift+←
64 Select one character right Shift+→ Shift+→ Shift+→
65 Select one character left Shift+← Shift+← Shift+←
66 Select to beginning of cell Shift+Home Fn+Shift+← Shift+Home

excelcampus.com/shortcuts 2 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web
67 Select to end of the text/formula Shift+End Fn+Shift+→ Shift+End
05. Cells & Ranges: Number Formatting
68 Apply General format to selected cells Ctrl+Shift+~ Ctrl+Shift+~
69 Apply Number format to selected cells Ctrl+Shift+! Ctrl+Shift+!
70 Apply Date format to selected cells Ctrl+Shift+# Ctrl+Shift+#
71 Apply Currency format to selected cells Ctrl+Shift+$ Ctrl+Shift+$
72 Apply Percent format/style to selected cells Ctrl+Shift+% Ctrl+Shift+%
73 Apply Time format to selected cells Ctrl+Shift+@ Ctrl+Shift+@
74 Apply Scientific format to selected cells Ctrl+Shift+^ Ctrl+Shift+^
75 Modify Cell Style of the active cell Alt+' Cmd+Shift+L
06. Cells & Ranges: Formatting
76 Remove indent Alt,H,5 Ctrl+Alt+Shift+Tab
77 Indent Alt,H,6 Ctrl+Alt+Tab
78 Left Align Alt,H,A,L Cmd+L
79 Center Align Alt,H,A,C Cmd+E
80 Right Align Alt,H,A,R Cmd+R
81 Top Align Alt,H,A,T
82 Middle Align Alt,H,A,M
83 Bottom Align Alt,H,A,B
84 Increase Font Size Alt,H,F,G Cmd+Shift+> Ctrl+Shift+>
85 Decrease Font Size Alt,H,F,K Cmd+Shift+< Ctrl+Shift+<
86 Wrap Text Alt,H,W
87 Format Window for cells and objects Ctrl+1 Cmd+1 Ctrl+1
88 Apply or remove bold formatting Ctrl+B Cmd+B Ctrl+B
89 Apply or remove italic formatting Ctrl+I Cmd+I Ctrl+I
90 Apply or remove underscoring Ctrl+U Cmd+U Ctrl+U
91 Apply or remove strikethrough formatting Ctrl+5 Cmd+Shift+X

92 Display Format Cells with Font tab selected Ctrl+Shift+F Ctrl+Shift+F

93 Insert or edit Cell Note Shift+F2 Fn+Shift+F2
94 Insert or reply to Cell Comment Ctrl+Shift+F2 Fn+Ctrl+Shift+F2 Shift+F2
95 Delete comment Shift+F10,M
96 Add hyperlink Ctrl+K Cmd+K Ctrl+K
07. Cells & Ranges: Rows & Columns
Select all cells in worksheet (unless active cell
97 Ctrl+A Cmd+A
is in a Table)
98 Select entire row Shift+Space Shift+Space Shift+Space
99 Select entire column Ctrl+Space Ctrl+Space Ctrl+Space
100 Add non-adjacent cells to selection Ctrl+Click Cmd+Click
101 Add adjacent cells to selection Shift+Click Shift+Click
102 Toggle Add or Remove Selection Mode Shift+F8 Fn+Shift+F8 Shift+F8
103 Same selection in next column Opt+Tab
104 Same selection in previous column Opt+Shift+Tab

excelcampus.com/shortcuts 3 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web

105 Move right between non-adjacent selections Ctrl+Alt+→

106 Move left between non-adjacent selections Ctrl+Alt+←

107 Open Insert window Ctrl++ Ctrl++
108 Insert rows (with rows selected) Ctrl++ Ctrl++
109 Insert columns (with columns selected) Ctrl++ Ctrl++
110 AutoFit Column Width Alt,H,O,I Alt,H,O,I
111 AutoFit Row Height Alt,H,O,A Alt,H,O,A
08. Cells & Ranges: Group & Hide
Group rows or columns (with rows/columns
112 Shift+Alt+→ Cmd+Shift+K
selected)
Ungroup rows or columns (with rows/columns
113 Shift+Alt+← Cmd+Shift+J
selected)
Open Group window (with cell or range
114 Shift+Alt+→ Cmd+Shift+K
selected)
Open Ungroup window (with cell or range
115 Shift+Alt+← Cmd+Shift+J
selected)
116 Open Delete window Ctrl+- Cmd+- Ctrl+-
117 Delete rows (with rows selected) Ctrl+- Cmd+- Ctrl+-
118 Delete columns (with columns selected) Ctrl+- Cmd+- Ctrl+-
119 Delete cells (with cells selected) Ctrl+- Cmd+- Ctrl+-
120 Hide columns Ctrl+0 Ctrl+0 Ctrl+0
121 Hide or show outline symbols Ctrl+8 Ctrl+8
122 Hide rows Ctrl+9 Ctrl+9 Ctrl+9
123 Unhide columns Ctrl+Shift+0 Ctrl+Shift+0 Ctrl+Shift+0
124 Unhide rows Ctrl+Shift+9 Ctrl+Shift+9 Ctrl+Shift+9
09. Cells & Ranges: Active Cell
Activate next cell in selected range (based on
125 Enter Return Enter
direction set in Excel Options)
Activate next cell to right/below in selected
126 Tab Tab Tab
range
Activate each corner cell in selected range in
127 Ctrl+. Ctrl+. Ctrl+.
clockwise direction
Activate previous cell in selection (based on
128 Shift+Enter Shift+Return Shift+Enter
direction set in Excel Options)
Activate previous cell to left/above in selected
129 Shift+Tab Shift+Tab Shift+Tab
range
130 Scroll active cell into view Ctrl+Backspace Cmd+Delete Ctrl+Backspace
Select single (active) cell when range is
131 Shift+Backspace Shift+Delete Shift+Backspace
selected
10. Cells & Ranges: Extend Selection
132 Extend selection by one cell up Shift+↑ Shift+↑
133 Extend selection by one cell right Shift+→ Shift+→ Shift+→
134 Extend selection by one cell down Shift+↓ Shift+↓
135 Extend selection by one cell left Shift+← Shift+← Shift+←

excelcampus.com/shortcuts 4 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web
136 Extend the selection to the last cell up Ctrl+Shift+↑ Ctrl+Shift+↑
137 Extend the selection to the last cell right Ctrl+Shift+→ Ctrl+Shift+→
138 Extend the selection to the last cell down Ctrl+Shift+↓ Ctrl+Shift+↓
139 Extend the selection to the last cell left Ctrl+Shift+← Ctrl+Shift+←
140 Extend selection to first cell in worksheet Ctrl+Shift+Home Fn+Ctrl+Shift+← Ctrl+Shift+Home
141 Extend selection to last cell in worksheet Ctrl+Shift+End Fn+Ctrl+Shift+→ Ctrl+Shift+End
142 Extend selection right one screen Shift+Alt+PgDn Fn+Shift+Alt+↓
143 Extend selection left one screen Shift+Alt+PgUp Fn+Shift+Alt+↑
144 Extend selection to start of row Shift+Home Fn+Shift+← Shift+Home
145 Extend selection down one screen Shift+PgDn Fn+Shift+↓
146 Extend selection up one screen Shift+PgUp Fn+Shift+↑
147 Toggle extend selection mode F8 Fn+F8
148 Select Spill Range Ctrl+A
11. Cells & Ranges: Select Special
149 Open the Go To window F5 OR Ctrl+G Ctrl+G Ctrl+G
150 Open the Go To Special window Alt,H,F,D,S OR F5,Alt,S
Select visible cells only (when range is
151 Alt+; Cmd+Shift+Z
selected)
152 Select current region Ctrl+A Cmd+A
153 Select current region around active cell Ctrl+Shift+* Shift+Ctrl+Space
154 Select current array Ctrl+/ Ctrl+/
155 Select row differences Ctrl+\ Ctrl+\
156 Select direct dependents Ctrl+] Ctrl+]
157 Select direct precedents Ctrl+[ Ctrl+[
158 Select all precedents Ctrl+Shift+{ Ctrl+Shift+{
159 Select all dependents Ctrl+Shift+} Ctrl+Shift+}
160 Select cells with comments Ctrl+Shift+O Fn+Ctrl+Shift+O
12. Cells & Ranges: Mouse Shortcuts for Copying & Moving Cells
161 Copy selected range or shape Ctrl+drag Alt+drag
Insert copy of selected range (moves existing
162 Ctrl+Shift+drag Alt+Shift+drag
cells)
163 Drag and cut drag drag
Cut and paste selected range (moves existing
164 Shift+drag Shift+drag
cells)
165 Move selected range to another worksheet Alt+drag Cmd+drag
13. Cells & Ranges: View
166 Zoom in Ctrl+Alt++ Alt+Cmd++ Ctrl+Alt++
167 Zoom out Ctrl+Alt+- Alt+Cmd+- Ctrl+Alt+-
168 Zoom in (with mouse) Ctrl+Scroll Up Ctrl+Scroll Up Ctrl+Scroll Up
169 Zoom out (with mouse) Ctrl+Scroll Down Ctrl+Scroll Down Ctrl+Scroll Down
170 Zoom to Selection Alt,W,G
171 Zoom to Selection Alt,W,J

excelcampus.com/shortcuts 5 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web
172 Toggle Scroll Lock on/off ScrLk Fn+Shift+F14
173 Toggle Gridlines on/off Alt,W,V,G
174 Toggle Freeze Panes on/off Alt,W,F,F
14. Cells & Ranges: Borders
175 Add Outside Borders to selected cell/range Ctrl+Shift+& Cmd+Alt+0 Ctrl+Shift+&
Remove all borders (apply No Borders) to
176 Ctrl+Shift+_ Cmd+Alt+_
selection
177 Open Border dropdown menu on Home Tab Alt,H,B Alt,H,B
178 Add all borders to cells in selected range Alt,H,B,A
179 Add or remove Bottom Border Alt,H,B,O Cmd+Alt+↓
180 Add or remove Top Border Alt,H,B,P Cmd+Alt+↑
181 Add or remove Left Border Alt,H,B,L Cmd+Alt+←
182 Add or remove Right Border Alt,H,B,R Cmd+Alt+→
Open Borders tab in Format Cells window
183 Alt,H,B,M
(More Borders)
15. Worksheet Tabs
184 Insert new worksheet Shift+F11 Fn+Shift+F11 Shift+F11
185 Delete selected worksheets Alt,E,L Alt,H,D,S
186 Rename current worksheet Alt,O,H,R
187 Go to next worksheet Ctrl+PgDn Fn+Ctrl+↓ Ctrl+Alt+PgDn
188 Go to previous worksheet Ctrl+PgUp Fn+Ctrl+↑ Ctrl+Alt+PgUp
189 Select adjacent worksheets Ctrl+Shift+PgUp/PgDn
190 Select adjacent worksheets (mouse) Shift+Click Shift+Click
191 Select non-adjacent worksheets (mouse) Ctrl+Click Cmd+Click
Open Move or Copy window for selected
192 Alt,E,M
sheets
193 Duplicate worksheet (mouse) Ctrl+drag Alt+drag
194 Protect or Unprotect Sheet Alt,R,P,S
195 Clear print area Alt,P,R,C
196 Set print area Alt,P,R,S
16. Workbook: File
197 Create new workbook Ctrl+N Cmd+N
198 Open workbook Ctrl+O Cmd+O Ctrl+O
199 Save workbook Ctrl+S Cmd+S
200 Save as F12 Cmd+Shift+S Alt+F2
201 Close current workbook Ctrl+F4 OR Ctrl+W Cmd+W Ctrl+W
202 Close Excel Alt+F4 Cmd+Q
17. Workbook: Print
203 Open print preview window Ctrl+F2
204 Print File Ctrl+P Cmd+P Ctrl+P
18. Workbook: General
205 Undo last action Ctrl+Z Cmd+Z Ctrl+Z
206 Redo last action Ctrl+Y Cmd+Y Ctrl+Y
207 Repeat last action F4 Cmd+Y F4

excelcampus.com/shortcuts 6 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web
208 Open Excel Options window Alt,F,T Cmd+,
209 Open help F1 Cmd+/
210 Tell Me Alt+Q
Open the Control Menu (minimize, maximize,
211 Alt+Space
close window)
212 Open Spelling window (Spell Check) F7 Fn+F7
213 Open Thesaurus dialog box Shift+F7 Fn+Shift+F7
214 Open Right-click menu Shift+F10 OR Menu Key Fn+Shift+F10

215 Move to next pane in application window F6 Fn+F6

216 Move to previous pane Shift+F6 Fn+Shift+F6
217 Protect and Unprotect Workbook Alt,R,P,W
19. Workbook: View
218 Minimize current workbook window Ctrl+F9 Cmd+M
Maximize or Restore current workbook
219 Ctrl+F10 Fn+Ctrl+F10
window (toggle)
220 Toggle full screen Ctrl+Shift+F1 Ctrl+Cmd+F
221 Go to previous workbook Ctrl+Shift+Tab Ctrl+Shift+Tab
222 Go to next workbook Ctrl+Tab Ctrl+Tab
Open current workbook in Desktop Excel
223 Alt+O
Application
20. Tables & Filters
Ctrl+L OR
224 Insert Table Ctrl+T Ctrl+T
Ctrl+Alt+T
225 Insert Table (select style first) Alt,H,T
226 Insert a row above the current row Alt,H, I, R Alt,H, I, R
Insert a column to the left of the current
227 Alt,H, I, C Alt,H, I, C
column
Select Table Body (Press again to include
228 Ctrl+A Cmd+A
Headers)
229 Select Table row Shift+Space Shift+Space Shift+Space
230 Select Table column Ctrl+Space Ctrl+Space Ctrl+Space
231 Toggle Autofilter on/off Ctrl+Shift+L Cmd+Shift+F Ctrl+Shift+L
Open Filter Dropdown Menu (with header cell
232 Alt+↓ Alt+↓ Alt+↓
selected)
Open Filter Dropdown Menu (from any cell in
233 Shift+Alt+↓ Shift+Alt+↓ Shift+Alt+↓
a Table)
234 Toggle Total Row on/off Ctrl+Shift+T Cmd+Shift+T
235 Clear slicer filter (with slicer selected) Alt+C Alt+C
21. Charts & Shapes
236 Create chart or PivotChart on same worksheet Alt+F1 Fn+Alt+F1 Alt+F1
237 Create chart in new ChartSheet F11 Fn+F11
238 Open Format Chart Area Task Pane Ctrl+1 Cmd+1

excelcampus.com/shortcuts 7 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web

239 Show or Hide All Field Buttons on PivotChart Alt,J,T,D,A

240 Snap to grid Alt Cmd+
241 Hide or show objects (shapes, charts, slicers) Ctrl+6 Ctrl+6
22. Copy & Paste
242 Copy selected object (cells, range, shape) Ctrl+C Cmd+C Ctrl+C
243 Cut selected object Ctrl+X Cmd+X Ctrl+X
244 Paste content from clipboard Ctrl+V Cmd+V Ctrl+V
245 Open the Paste Special window Ctrl+Alt+V Cmd+Ctrl+V
Duplicate selected object (shapes, charts,
246 Ctrl+D Cmd+D
slicers)
247 Copy selected objects (mouse) Ctrl+drag Cmd+drag
Copy selected ojbects and retain vertical or
248 Ctrl+Shift+drag Cmd+Shift+Drag
horizontal alignment (mouse)
249 Copy selected objects (mouse right-click) Right-click+Drag Right-click+Drag

Copy selected ojbects and retain vertical or Right-

250 Right-click+Shift+Drag
horizontal alignment (right-click mouse) click+Shift+Drag
23. Pivot Tables
251 Insert Pivot Table Alt,N,V
252 Refresh Pivot Table or Query Alt+F5 Alt+F5
253 Refresh All Ctrl+Alt+F5 Ctrl+Alt+F5
254 Open pivot table wizard Alt,D,P Cmd+Alt+P
255 Select entire pivot table Ctrl+A Cmd+A
256 Group pivot table items Shift+Alt+→ Cmd+Shift+K
257 Ungroup pivot table items Shift+Alt+← Cmd+Shift+J
258 Unhide (clear filter on) pivot table item Alt,H,S,C
259 Filter out (exclude/hide) pivot item Ctrl+- Ctrl- Ctrl+-
Open Filter Dropdown Menu in Pivot Table
260 Alt+↓ Alt+↓ Alt+↓
cells
261 Toggle pivot table field checkbox Space Space
262 Insert pivot chart Alt+F1 Fn+Alt+F1 Alt+F1
263 Create pivot chart on new Chart Sheet F11 Fn+F11
24. Ribbon
264 Activate Ribbon shortcut keys Alt OR Shift+F6 Alt OR Win+Alt
265 Move to next ribbon control Tab Tab Tab
266 Move through Ribbon tabs and groups → ← ↑ ↓ → ← ↑ ↓
267 Open dropdown menu of selected button Alt+↓ Alt+↓
268 Open help window for selected control F1
269 Expand or collapse ribbon Ctrl+F1 Cmd+Alt+R
25. Macros & VBA
270 Open the VB Editor window (VBA) Alt+F11 Fn+Alt+F11

excelcampus.com/shortcuts 8 of 9
Excel Keyboard Shortcuts
# Description Windows Mac Web

271 Open the Macro window (run or edit macro) Alt+F8 Fn+Alt+F8
272 Record Macro Alt,L,R
273 Open Excel Add-ins Window Alt,L,R
274 Open COM Add-ins Window Alt,L,J
26. Application: Dialog boxes
275 Move to next tab Ctrl+Tab Ctrl+Tab
276 Move to previous tab Ctrl+Shift+Tab Ctrl+Shift+Tab
277 Move to next control or button Tab Tab Tab
278 Move to previous control or button Shift+Tab Shift+Tab Shift+Tab
279 Press selected control or button Enter Return Enter
280 Check and uncheck checkboxes Space Space
281 Close the window or dialog box Esc Esc Esc

excelcampus.com/shortcuts 9 of 9