Many users find it easier and quicker using keyboard shortcuts in Excel. But you may be wondering, how many functions can you actually perform in Excel using keyboard shortcuts?
Just like how there are numerous Excel functions available, there are also numerous shortcuts you can perform using keyboard shortcuts in Excel.
In this article, I will share with you over 300 useful and effective keyboard shortcuts in Excel available for Windows users. And whether you are a new beginner in Excel or an advanced user, this list will serve as a guide to help you work more efficiently.
File
1
Ctrl + N
To CREATE a NEW WORKBOOK.
2
Ctrl + O
To OPEN an already saved workbook file.
3
Ctrl + S
To SAVE a workbook.
4
Ctrl + W
To CLOSE a workbook
5
Ctrl + P
To PRINT a workbook file
6
Ctrl + F2
To open the PRINT PREVIEW window.
7
Ctrl + F5
To RESTORE the selected workbook window.
8
Alt + F, C
To CLOSE and SAVE your workbook.
9
Alt + F, E
To EXPORT your workbook.
10
Alt + F, Z
To SHARE your workbook
11
F12
To SAVE AS
12
Ctrl + F4 / Alt + F4
To CLOSE selected workbook.
Ribbon
Use these keyboard shortcuts to access keys for the ribbon tabs and work in the ribbon.
13
Ctrl + F1
To EXPAND or COLLAPSE the ribbon.
14
Alt / F10
To DISPLAY the ACCESS KEYS.
15
Alt + Tab / Shift + Tab / Tab
To move to the next RIBBON CONTROL.
16
Arrow Keys
To move UP, DOWN, LEFT or RIGHT among items on the Ribbon
17
Alt + Spacebar / Down Arrow
To open/display the CONTROL MENU.
18
Space bar / Enter
To ACTIVATE the selected control
19
Alt + Down arrow
To OPEN the MENU for selected control or activate FILTERS for cells.
20
Down Arrow
To MOVE to the next command in a MENU or SUBMENU
21
Shift + F10
To open the CONTEXT MENU (i.e the RIGHT-CLICK MENU) for selected cell.
22
Left Arrow
To MOVE to the SUBMENU when main menu is opened.
23
Alt + H
To open the HOME tab
24
Alt + N
To open the INSERT tab.
25
Alt + P
To open the PAGE LAYOUT tab.
26
Alt + M
To open the FORMULAS tab.
27
Alt + A
To open the DATA tab.
28
Alt + R
To open the REVIEW tab.
29
Alt + W
To open the VIEW tab.
30
Alt + F
To open the FILE page and go to INFO.
31
Alt + Q
To go to SEARCH field or TELL ME on the Ribbon and type your search term.
32
Alt + F , T
To go to OPTIONS.
33
Alt + H, H
To choose a FILL COLOUR.
34
Alt + Y
To SHARE workbook with others
35
Ctrl + Z
To UNDO the last action.
36
Ctrl + Y / F4
To REDO or REPEAT the last action or command.
37
Ctrl + F
To go to FIND dialog.
38
Ctrl + H
To display FIND and REPLACE dialog.
39
Ctrl + Alt + V
To display PASTE SPECIAL dialog box.
40
Ctrl + Shift + F4
To FIND the PREVIOUS match.
41
Shift +F4
To FIND the NEXT match.
42
Delete
To REMOVE contents in a cell or selected cells.
Charts
43
Alt + F1
To INSERT CHART or create EMBEDDED CHART in the current range.
44
F11
To CREATE CHART of selected data range in a new worksheet
Tables and Filters
45
Ctrl + L
To OPEN the CREATE TABLE dialog.
46
Ctrl + T
To CREATE a TABLE for a selected cell range.
47
Ctrl + A
To SELECT a TABLE in the worksheet
48
Ctrl + Spacebar
To SELECT an entire COLUMN in a table.
49
Shift + Spacebar
To SELECT an entire ROW in a table.
50
Ctrl + Shift + L
To turn on/off FILTER DROP-DOWN MENU to the columns.
Drag and Drop
51
Drag
To drag and CUT or FILL same contents in a new cell.
52
Shift + Drag
To drag and INSERT same contents in a new cell.
53
Ctrl + Drag
To COPY UPDATED contents in new cell or to DUPLICATE worksheet.
54
Ctrl + Shift + Drag
To DRAG and INSERT COPY of content.
55
Alt + Drag
To MOVE POSITION of a worksheet.
56
Ctrl + Shift + Drag
To drag and INSERT copy.
Navigation
Make use of these keyboard shortcuts when navigating in cells.
57
Shift + Tab
To MOVE to PREVIOUS CELL in a worksheet
58
Tab + Right arrow/Right Arrow (->)
To move ONE CELL RIGHT in a worksheet.
59
Tab + Left Arrow/Left Arrow (<-)
To move ONE CELL LEFT in a worksheet.
60
Tab + Up Arrow/Up Arrow
To move ONE CELL UP in a worksheet
61
Tab + Down Arrow/Down Arrow
To move ONE CELL DOWN in a worksheet.
62
Alt + Pg Dn
To MOVE SCREEN ONCE to the RIGHT in a worksheet
63
Alt + Pg Up
To MOVE SCREEN ONCE to the LEFT in a worksheet.
64
Pg Up
To move ONCE UP the SCREEN in a worksheet.
65
Pg Dn
To move DOWN the screen ONCE.
66
Ctrl + Up arrow
To move to the TOP EDGE of the current data region.
67
Ctrl + Down arrow
To move to the BOTTOM EDGE of the current data region.
68
Ctrl + Right arrow
To move towards RIGHT EDGE of the current data region.
69
Ctrl + Left arrow
To move towards the LEFT EDGE of the current data region.
70
Ctrl + Pg Up
To move LEFT to the PREVIOUS sheet in a workbook.
71
Ctrl + Pg Dn
To move RIGHT to the NEXT SHEET in a workbook.
72
Ctrl + End
To move to the LAST USED cell in a worksheet.
73
Ctrl + Home
To go to the BEGINNING (First Cell – A1) of a worksheet.
74
Ctrl + G + Enter
To go back to selected HYPERLINK.
75
Home
To go to the BEGINNING of a ROW.
76
Home + Scroll Lock
To move to the UPPER-LEFT CORNER cell when Scroll lock is on.
77
Tab
To move RIGHT to the NEXT CELL.
78
Alt + Down Arrow
To OPEN the LIST of DATA VALIDATION OPTIONS on a cell
79
Ctrl + Alt + 5
To cycle through FLOATING SHAPES or IMAGES in a worksheet
80
Esc
To EXIT the FLOATING SHAPE navigation
81
End
To turn on or off END MODE.
Formatting Text Cells
82
Ctrl + 1
To OPEN the FORMAT CELLS dialog box.
83
Shift + F10
To open FORMAT CELLS dialog.
84
Ctrl + C
To COPY selected cells.
85
Ctrl + X
To CUT and move the selected cells.
86
Ctrl + V
To PASTE the copied or cut content.
87
Ctrl + Alt + V / Alt+E+S
To open PASTE SPECIAL dialog
88
Ctrl + B / Ctrl + 2
To apply or remove BOLD formatting to selected cells.
89
Ctrl + I / Ctrl + 3
To apply or remove ITALICS formatting to selected cells
90
Ctrl + U / Ctrl +4
To apply or remove UNDERLINE to selected cells.
91
Ctrl + 5
To apply or remove a STRIKETHROUGH in a cell.
92
Ctrl + 6
To HIDE or SHOW objects
93
Ctrl + K
To INSERT HYPERLINK to content of selected cells.
94
Ctrl + Q
To display QUICK ANALYSIS OPTION for selected cells with data.
95
Alt + H, A, C
To ALIGN cell content to the CENTER.
96
Alt + H + A + L
To ALIGN cell content to the LEFT.
97
Alt + H + A + R
To ALIGN cell content to the RIGHT.
98
Alt + H + 6
To apply THEME COLOUR to the background in a cell.
99
Alt + H + 5
To REMOVE INDENT.
100
Alt + H + FG
To INCREASE FONT SIZE one step.
101
Alt + H + FK
To DECREASE FONT SIZE one step.
102
Ctrl + Shift + F / Ctrl + Shift + P
To open the FONT MENU in the format cells dialog.
103
Ctrl + Shift + G
To OPEN the STATISTICS dialog in a workbook.
Formatting Number Cells
104
Ctrl + Shift + ~
To apply GENERAL FORMAT to selected cells.
105
Ctrl + Shift + @
To apply the TIME format.
106
Ctrl + Shift + !
To apply the NUMBER format
107
Ctrl + Shift + $
To apply the CURRENCY format with 2 decimal places.
108
Ctrl + Shift + # / Ctrl + #
To apply the DATE format.
109
Ctrl + Shift + %
To apply the PERCENTAGE format.
110
Ctrl + Shift + ^
To apply SCIENTIFIC format.
111
Ctrl + Shift + “
To apply CUSTOM format
112
Ctrl + ‘
To display CELL FORMULAS.
113
Ctrl + ~
To SWITCH to DATE format
114
Ctrl + Shift + ~ or Ctrl #
To copy the SAME content of the cell directly ABOVE.
Paste Special
Paste Special is used for pasting specific aspect of the data that has been copied. e.g its formatting or value using the paste special options. After copying the data, open the paste special dialog box with Ctrl + Alt + V or Alt + E + S, to pick an option using the required letter.
115
Ctrl + Alt + V / Alt+E+S
To open PASTE SPECIAL dialog options
116
A
To paste ALL the cell CONTENTS and FORMATTING
117
F
To paste only the FORMULAS of the COPIED cell.
118
V
To paste only the VALUES of copied cell.
119
T
To paste only the FORMATTING of the copied cell.
120
C
To paste only COMMENTS and NOTES attached to the copied cell
121
N
To paste only the DATA VALIDATION SETTINGS from the copied cell.
122
H
To paste ALL the cell CONTENTS and FORMATTING from the copied cells.
123
X
To paste ALL cell contents WITHOUT adding the BORDERS
124
W
To paste only COLUMN WIDTHS from the copied cells.
125
R
To paste only FORMULAS and NUMBER FORMATS from copied cells.
126
U
To paste VALUES and NUMBER FORMATS from copied cells.
Selection
127
Ctrl + A / Ctrl + Shift + Spacebar
To SELECT an entire WORKSHEET or current DATA REGION in a worksheet
128
Ctrl + Shift + Spacebar
To SELECT current DATA REGION or OBJECTS in a WORKSHEET
129
Ctrl + Shift + Pg Dn
To select the CURRENT AND NEXT SHEET in a workbook.
130
Ctrl + Shift + Pg Up
To select the CURRENT AND PREVIOUS SHEET in a workbook.
131
Shift + Spacebar
To SELECT an entire ROW.
132
Ctrl + Spacebar
To SELECT an entire COLUMN
133
Ctrl + Shift + *
To select CURRENT REGION around active cell.
134
Shift + Click
To ADD ADJACENT cells to a selection.
135
Ctrl + Click
To ADD NON-ADJACENT cells to a selection.
136
Ctrl + Alt + Right Arrow(->)
To MOVE RIGHT between NON-ADJACENT selections
137
Ctrl + Alt + Left Arrow(->)
To MOVE LEFT between NON-ADJACENT selections.
138
Shift + F8
To ADD a NON-ADJACENT cell or range to a SELECTION using arrow keys.
139
Home
To select FIRST COMMAND on a MENU or SUB-MENU
140
Esc
To CANCEL a SELECTION.
Extended Selection
141
Shift + Right Arrow
To extend selection by ONE cell to the RIGHT.
142
Shift + Left Arrow
To extend selection by ONE cell to the LEFT.
143
Shift + Up Arrow
To extend selection by ONE cell UP.
144
Shift + Down Arrow
To extend selection by ONE cell DOWN.
145
Ctrl + Shift + Right Arrow
To extend selection to the LAST NON-BLANK cell on the RIGHT.
146
Ctrl + Shift + Left Arrow
To extend selection to the LAST NON-BLANK cell on the LEFT.
147
Ctrl + Shift + Up Arrow
To extend selection to the LAST NON-BLANK cell at the TOP.
148
Ctrl + Shift + Down Arrow
To extend selection to the LAST NON-BLANK cell at the BELOW.
149
Shift + PgUp
To extend selection UP one screen.
150
Shift + PgDn
To extend selection DOWN one screen.
151
Alt + Shift + PgDn
To extend selection RIGHT one screen.
152
Alt + Shift + PgUp
To extend selection LEFT one screen.
153
Shift + Home
To extend selection to the START of a ROW.
154
Ctrl + Shift + Home
To extend selection to the BEGINNING first cell in worksheet.
155
Ctrl + Shift + End
To extend selection to the LAST USED CELL in a worksheet.
156
F8
To turn ON and OFF the EXTEND SELECTION MODE and extend selection with arrow keys.
Active Cell
157
Shift + Backspace
To SELECT ACTIVE cell only.
158
Ctrl + Backspace
To SHOW the ACTIVE cell on a worksheet.
159
Ctrl + .
To MOVE ACTIVE cell CLOCKWISE in selection.
160
Enter
To COMPLETE cell entry and move ACTIVE cell DOWN in selection.
161
Shift + Enter
To COMPLETE cell entry and move ACTIVE cell UP in selection.
162
Shift + Tab
To MOVE ACTIVE cell LEFT in a selection.
163
Tab
To MOVE ACTIVE cell RIGHT in a selection.
Making Special Selection
164
Ctrl + G
To display the GO TO dialog box.
165
Ctrl + Shift + O
To SELECT cells with COMMENTS.
166
Ctrl + /
To select CURRENT ARRAY.
167
Ctrl + \
To select ROW DIFFERENCES.
168
Ctrl + [
To select DIRECT PRECEDENTS.
169
Ctrl + ]
To select DIRECT DEPENDENTS.
170
Ctrl + Shift + |
To select COLUMN DIFFERENCES.
171
Ctrl + Shift + {
To select ALL PRECEDENTS.
172
Ctrl + Shift + }
To select ALL DEPENDENTS.
173
Alt + ;
To select VISIBLE CELLS only.
Editing Cells
174
F2
To EDIT an active cell.
175
F7
To CHECK the SPELLING of selected cell content in a worksheet
176
Esc
To CANCEL an entry.
177
Backspace
To DELETE characters to the LEFT.
178
Delete
To DELETE characters to the RIGHT.
179
Shift + F10 + D
To DELETE COMMENT in a cell
180
Ctrl + Shift + F2
To INSERT or OPEN and REPLY a THREADED COMMENT
181
Shift + F2
To INSERT or OPEN and EDIT a COMMENT.
182
Shift + ->
To SELECT characters to the RIGHT.
183
Shift + <-
To SELECT characters to the LEFT.
184
Shift + Home
To select to the BEGINNING of the cell in a ROW.
185
Shift + End
To select to the END of the cell / Switch to END MODE.
186
Ctrl + ->
To MOVE one word towards the RIGHT.
187
Ctrl + <-
To MOVE one word towards the LEFT.
188
Ctrl + Shift + <-
To SELECT one word towards the LEFT.
189
Ctrl + Shift + ->
To SELECT one word towards the RIGHT.
190
Ctrl + Delete
To DELETE to the END of the line.
191
Alt + Enter
To START a NEW LINE in the SAME cell
Entering Data
192
Enter
To ENTER the content and move down.
193
Tab
To ENTER the content and move RIGHT.
194
Shift + Tab
To ENTER content and move LEFT.
195
Shift + Enter
To COMPLETE ENTRY in a cell and move to the cell ABOVE.
196
Ctrl + Enter
To enter SAME DATA in SELECTED MULTIPLE cells.
197
Ctrl + Enter
To COMPLETE ENTRY and stay in the SAME cell.
198
Ctrl + ;
To ENTER the CURRENT DATE in a cell.
199
Ctrl + D
To use FILL DOWN to copy the same content and format of the cell ABOVE.
200
Ctrl + R
To FILL to the RIGHT the same content of the cell on the LEFT.
201
Ctrl + ‘
To COPY the FORMULA from the cell ABOVE the active cell.
202
Ctrl + Shift + 9
To REMOVE all HYPERLINKS.
203
Ctrl + Shift + :
To ENTER the CURRENT TIME in a cell.
204
Ctrl + Shift + “
To COPY the VALUE from cell above into a cell or formula bar.
205
Ctrl + ` (Grave accent)
To SWITCH between viewing displayed cell VALUES or FORMULAS in the worksheet.
206
Alt + Down Arrow
To display AUTO COMPLETE LIST.
207
Alt + Enter
To START a NEW LINE in the SAME cell.
208
Enter
To COMPLETE the entry in a cell and move to the NEXT one.
Borders
209
Ctrl + Shift + &
To ADD border OUTLINE around selected cells.
210
Ctrl + Shift + _
To REMOVE a border OUTLINE from selected cells.
211
Alt + H, B
To ADD BORDERS.
212
Alt + R
To add or remove borders to the RIGHT.
213
Alt + L
To add or remove border to the LEFT.
214
Alt + T
To add or remove border at the TOP.
215
Alt + B
To add or remove border at the BOTTOM.
216
Alt + D
To add or remove border UPWARD DIAGONAL.
217
Alt + H
To add or remove border HORIZONTAL INTERIOR.
218
Alt + V
To add or remove border VERTICAL INTERIOR
To Hide/Unhide
219
Ctrl + 9
To HIDE the selected ROWS
220
Ctrl + 0
To HIDE the selected COLUMNS
Data, Functions and Formulas
221
F3
To PASTE an already DEFINED NAME into a FORMULA
222
F4
To CYCLE THROUGH all ABSOLUTE and RELATIVE references in a formula
223
F9
To CALCULATE all worksheets in all OPEN wokbooks
224
Alt + =
To AUTO SUM selected cells
225
Shift + F3
To open INSERT FUNCTION dialog
226
Shift + F9
To CALCULATE only the ACTIVE worksheets
227
Ctrl + ‘
To TOGGLE FORMULAS on and off.
228
Ctrl + A
To display FUNCTION ARGUMENT dialog
229
Ctrl + E
To invoke FLASH FILL to FILL current COLUMN with PATTERNS in ADJACENT COLUMNS.
230
Ctrl + F3
To OPEN the NAME MANAGER dialog.
231
Alt + M, M, D
To DEFINE a selected cell range NAME to use in REFERENCES.
232
Ctrl + Shift + A
To INSERT FUNCTION ARGUMENT
233
Ctrl + Shift + Enter
To enter ARRAY FORMULAR
234
Ctrl + Alt + F9
To FORCE CALCULATE all worksheets in all OPEN workboks (i.e Calculate worksheets regarless of any changes since its last calculation)
235
Ctrl + Shift + U
To EXPAND or COLLAPSE the FORMULA BAR
236
Ctrl + Shift + F3
To CREATE NAMES from VALUES in rows and columns or To DEFINE NAME using row and column labels.
237
Ctrl + Shift + End
To SELECT all TEXT in the formula bar
238
Alt + Shift + F10
To display the MENU or MESSAGE for ERROR CHECKING
239
Ctrl + End
To MOVE cursor to the END of the TEXT in the formula bar.
240
Tab
To ACCEPT FUNCTION with AUTOCOMPLETE
241
Esc
To CANCEL any ENTRY in the FORMULAR BAR
Refresh
Use these keys to refresh data from external data sources.
242
Esc
To STOP a REFRESH operation.
243
Ctrl + F5
To REFRESH the data in CURRENT WORKSHEET.
244
Ctrl + Alt + F5
To refresh ALL DATA in a WORKBOOK.
Grid Operations
245
Ctrl + –
To OPEN DELETE dialog
246
Ctrl + –
To DELETE CELLS, ROWS or COLUMNS
247
Delete
To REMOVE contents of selected cells
248
Ctrl + 8
To hide or show OUTLINE SYMBOLS
249
Ctrl + Shift + (+)
To open INSERT DIALOG
250
Ctrl + Shift + (+)
To INSERT new ROWS or COLUMNS
251
Ctrl + Alt + (+)
To ZOOM IN
252
Ctrl + Alt + (-)
To ZOOM OUT
253
Alt + H, D, C
To DELETE COLUMN
254
Alt + Shift + ->
To GROUP rows and columns or To OPEN the GROUP DIALOG
255
Alt + Shift + <-
To UNGROUP rows and columns or To OPEN the UNGROUP DIALOG.
Power Pivot Tables
Use these keyboard shortcuts when working with Power Pivot in Excel 2013, 2016, 2019 and Office 365.
256
Ctrl + A
To SELECT the entire PIVOT TABLE
257
Right-click
To OPEN the CONTEXT MENU for selected cell or cell range.
258
Ctrl + D
To DELETE the pivot table.
259
Ctrl + M
To MOVE the pivot table
260
Ctrl + R
To RENAME the pivot table
261
Ctrl + –
To HIDE pivot table item
262
Alt + F1
To CREATE EMBEDDED CHART in the SAME RANGE in the worksheet.
263
Alt + D + P
To OPEN PIVOT TABLE wizard
264
Alt + Shift + ->
To GROUP pivot table items
265
Alt + Shift + <-
To UNGROUP pivot table items
266
F5
To open the GO TO dialog
267
F9
To RECALCULATE ALL FORMULAS in the Power Pivot Table.
268
F11
To CREATE PIVOT CHART in the same worksheet
269
Spacebar
To toggle PIVOT TABLE FIELD checkbox.
Workbook
270
Shift + F11
To INSERT NEW a worksheet
271
Ctrl + PgUp
To go to the NEXT worksheet
272
Ctrl + PgDn
To go to the PREVIOUS worksheet
273
Ctrl + Tab
To go to the NEXT workbook
274
Ctrl + Shift + Tab
To SWITCH to the PREVIOUS workbook
275
F6
To move to NEXT PANE
276
Shift + F6
To move to PREVIOUS PANE
277
Ctrl + F8
To ADJUST the SIZE of workbook when it is not Maximized
278
Ctrl + F9
To MINIMIZE current workbook window
279
Ctrl + F10
To MAXIMIZE current workbook window
280
Shift + Click
To SELECT ADJACENT worksheets
281
Ctrl + Click
To select NON-ADJACENT worksheets
282
ScrLk
To toggle SCROLL LOCK
283
Ctrl + Shift + F1
To TOGGLE FULL SCREEN
Dialog Box
284
Tab
To move to NEXT CONTROL
285
Shift + Tab
To move to PREVIOUS OPTION in a dialog
286
Ctrl + Tab
To move to the NEXT TAB
287
Ctrl + Shift + Tab
To move to the PREVIOUS TAB
288
Enter
To ACCEPT and APPLY
289
Spacebar
To CHECK and UNCHECK box
290
Esc
To CANCEL and CLOSE the DIALOG box
Add-ins
291
Ctrl + Shift + F10
To OPEN the CONTEXT MENU.
292
Ctrl + Spacebar
To open the TASK PANE OPTIONS MENU.
293
Ctrl + Spacebar
To SELECT and CLOSE the TASK PANE.
Others
294
Alt + W, L
To go to NORMAL VIEW of the worksheet.
295
Alt + W, P
To go to PAGE LAYOUT VIEW of the worksheet.
296
Alt + W, I
To go to PAGE BREAK PREVIEW of the worksheet
297
F1
To DISPLAY the HELP task pane Microsoft
298
Shift + F7
To open THESAURUS dialog box
299
Ctrl + F6
To MOVE between TWO EXCEL windows.
300
Ctrl + Shift + F6
To MOVE between ALL EXCEL windows.
301
Prt sc
To CAPTURE IMAGE of your screen
302
Alt + F8
To open MACRO dialog
303
Alt + F11
To open Microsoft VISUAL BASIC FOR APPLICATIONS (VBA) editor.
