Download - 239 Excel Shortcut
-
7/30/2019 239 Excel Shortcut
1/17
1 CTRL+SPACEBAR
2 SHIFT+SPACEBAR
3 CTRL+A
4 SHIFT+BACKSPACE
5 CTRL+SHIFT+SPACEBAR
6 CTRL+6
7 CTRL+SHIFT+*
8 CTRL+/
9 CTRL+SHIFT+O
10 CTRL+\
11 CTRL+SHIFT+|
12 CTRL+[
13 CTRL+SHIFT+{
14 CTRL+]15 CTRL+SHIFT+}
16 ALT+;
17 F8
18 SHIFT+F8
19 SHIFT+ARROW KEYS
20 CTRL+SHIFT+ARROW KEYS
21 SHIFT+HOME
22 CTRL+SHIFT+HOME
23 CTRL+SHIFT+END
24 SHIFT+PAGE DOWN
25 SHIFT+PAGE UP
26 END+SHIFT+ARROW KEYS27 END+SHIFT+HOME
28 END+SHIFT+ENTER
29 SCROLL LOCK+ SHIFT+HOME
30 SCROLL LOCK+ SHIFT+END
31 ENTER
32 ALT+ENTER
33 CTRL+ENTER
34 SHIFT+ENTER
35 TAB
36 SHIFT+TAB
37 ESC
38 ARROW KEYS
39 HOME
40 F4 or CTRL+Y
41 CTRL+SHIFT+F3
42 CTRL+D
43 CTRL+R
44 CTRL+F3
Excel Keyb
Shortcuts for selecting cells, rows and
Excel Shortcuts for entering, editing, f
-
7/30/2019 239 Excel Shortcut
2/17
45 CTRL+K
46 CTRL+;
47 CTRL+SHIFT+:
48 ALT+ARROW DOWN
49 CTRL+Z
50 ALT+0162
51 ALT+016352 ALT+0165
53 ALT+0128
54 =
55 F2
56 BACKSPACE
57 ENTER
58 CTRL+SHIFT+ENTER
59 ESC
60 SHIFT+F3
61 CTRL+A62 CTRL+SHIFT+A
63 F3
64 ALT+=
65 CTRL+SHIFT+"
66 CTRL+'
67 CTRL+`
68 F9
69 SHIFT+F9
70 CTRL+ALT+F9
71 CTRL+ALT+SHIFT+F9
Keys for editing data and working with
72 F2
73 ALT+ENTER
74 BACKSPACE
75 DELETE
76 CTRL+DELETE
77 F7
78 SHIFT+F2
79 ENTER
80 CTRL+Z
81 ESC
82 CTRL+SHIFT+Z
83 CTRL+C
84 CTRL+X85 CTRL+V
86 DELETE
87 CTRL+-
88 CTRL+SHIFT++
89 ALT+'
90 CTRL+1
Shortcuts to format Excel data
Shortcuts to enter and calculate formu
-
7/30/2019 239 Excel Shortcut
3/17
91 CTRL+SHIFT+~
92 CTRL+SHIFT+$
93 CTRL+SHIFT+%
94 CTRL+SHIFT+^
95 CTRL+SHIFT+#
96 CTRL+SHIFT+@
97 CTRL+SHIFT+!98 CTRL+B
99 CTRL+I
100 CTRL+U
101 CTRL+5
102 CTRL+9
103 CTRL+SHIFT+(
104 CTRL+0
105 CTRL+SHIFT+)
106 CTRL+SHIFT+&
107 CTRL+SHIFT+_
Excel Help Task Pane Shortcuts108 F1
109 F6
110 TAB
111 SHIFT+TAB
112 ENTER
113 ARROW DOWN, ARROW UP
114 ARROW RIGHT, ARROW LEFT
115 ALT+ARROW LEFT
116 ALT+ARROW RIGHT
117 CTRL+SPACEBAR
118 CTRL+F1
119 ARROW RIGHT
120 ARROW LEFT
Excel Shortcuts for the Help window
121 TAB
122 SHIFT+TAB
123 ENTER
124 ALT+ARROW LEFT
125 ALT+ARROW RIGHT
126 CTRL+P
127 ARROW UP, ARROW DOWN
128 PAGE UP and PAGE DOWN
129 ALT+U
130 SHIFT+F10
Shortcuts to access and use task pane
131 F6
132 CTRL+TAB
133 TAB or SHIFT+TAB
134 CTRL+SPACEBAR
135 ARROW DOWN or ARROW UP
136 SPACEBAR or ENTER
-
7/30/2019 239 Excel Shortcut
4/17
137 SHIFT+F10
138 HOME or END
139 PAGE UP or PAGE DOWN
140 CTRL+HOME or CTRL+END
Access and use menus and toolbars wi
141 F10 or ALT142 TAB or SHIFT+TAB
143 CTRL+TAB or CTRL+SHIFT+TAB
144 ENTER
145 SHIFT+F10
146 ALT+SPACEBAR
147 ARROW DOWN or ARROW UP
148 ARROW LEFT or ARROW RIGHT
149 HOME or END
150 ESC
151 CTRL+ARROW DOWN
152 CTRL+7
Use Excel dialog boxes with Shortcuts
153 TAB
154 SHIFT+TAB
155 CTRL+TAB or CTRL+PAGE DOWN
156 CTRL+SHIFT+TAB or CTRL+PAGE UP
157 ARROW KEYS
158 SPACEBAR
159 ALT+LETTER
160 ALT+ARROW DOWN
161 ENTER
162 ESC
Working with Excel edit boxes within d
163 HOME
164 END
165 ARROW LEFT or ARROW RIGHT
166 CTRL+ARROW LEFT
167 CTRL+ARROW RIGHT
168 SHIFT+ARROW LEFT
169 SHIFT+ARROW RIGHT
170 CTRL+SHIFT+ARROW LEFT
171 CTRL+SHIFT+ARROW RIGHT
172 SHIFT+HOME
173 SHIFT+END
Use the Open, Save As, and Insert Pict
174 ALT+1
175 ALT+2
176 ALT+3
177 ALT+4
178 ALT+5
179 ALT+6
-
7/30/2019 239 Excel Shortcut
5/17
180 ALT+7 or ALT+L
181 SHIFT+F10
182 TAB
183 F4 or ALT+I
184 F5
Keys for workbooks and worksheets185 CTRL+P or CTRL+SHIFT+F12
186 SHIFT+F11 or ALT+SHIFT+F1
187 CTRL+PAGE DOWN
188 CTRL+PAGE UP
189 SHIFT+CTRL+PAGE DOWN
190 SHIFT+CTRL+PAGE UP
191 ALT+O H R
192 ALT+E M
193 ALT+E L
194 ARROW KEYS
195 CTRL+ARROW KEYS
196 HOME197 CTRL+HOME
198 CTRL+END
199 PAGE DOWN
200 PAGE UP
201 ALT+PAGE DOWN
202 ALT+PAGE UP
203 F6
204 SHIFT+F6
205 CTRL+BACKSPACE
206 F5
207 SHIFT+F5
208 SHIFT+F4
209 TAB
Excel Shortkeys to move within a selec
210 ENTER
211 SHIFT+ENTER
212 TAB
213 SHIFT+TAB
214 CTRL+PERIOD
215 CTRL+ALT+ARROW RIGHT
216 CTRL+ALT+ARROW LEFT
217 CTRL+1218 ALT+T
219 ALT+B
220 ALT+L
221 ALT+R
222 ALT+H
223 ALT+V
224 ALT+D
225 ALT+U
Use the Border tab in the Format Cells
-
7/30/2019 239 Excel Shortcut
6/17
Working with the AutoFilter
226 ALT+ARROW DOWN
227 ALT+ARROW UP
228 ARROW DOWN
229 ARROW UP
230 HOME231 END
232 ENTER
233 ALT+SHIFT+ARROW RIGHT
234 ALT+SHIFT+ARROW LEFT
235 CTRL+8
236 CTRL+9
237 CTRL+SHIFT+(
238 CTRL+0
239 CTRL+SHIFT+)
Show, hide, and outline data
-
7/30/2019 239 Excel Shortcut
7/17
Select the entire column
Select the entire row
Select the entire worksheet
With multiple cells selected, select only the active cell
With an object selected, select all objects on a sheet
Alternate between hiding objects, displaying objects, and displaying placeholders for objects
Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a
Select the array containing the active cell
Select all cells that contain comments
In a selected row, select the cells that do not match the value in the active cell
In a selected column, select the cells that do not match the value in the active cell
Select all cells directly referenced by formulas in the selection
Select all cells directly or indirectly referenced by formulas in the selection
Select cells that contain formulas that directly reference the active cellSelect cells that contain formulas that directly or indirectly reference the active cell
Select the visible cells in the current selection
Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the sel
Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to a
Extend the selection by one cell
Extend the selection to the last nonblank cell in the same column or row as the active cell
Extend the selection to the beginning of the row
Extend the selection to the beginning of the worksheet
Extend the selection to the last used cell on the worksheet (lower-right corner)
Extend the selection down one screen
Extend the selection up one screen
Extend the selection to the last nonblank cell in the same column or row as the active cellExtend the selection to the last used cell on the worksheet (lower-right corner)
Extend the selection to the last cell in the current row. This key sequence does not work if you have turned on tr
Extend the selection to the cell in the upper-left corner of the window
Extend the selection to the cell in the lower-right corner of the window
Complete a cell entry and select the cell below
Start a new line in the same cell
Fill the selected cell range with the current entry
Complete a cell entry and select the previous cell above
Complete a cell entry and select the next cell to the right
Complete a cell entry and select the previous cell to the left
Cancel a cell entry
Move one character up, down, left, or right
Move to the beginning of the line
Repeat the last action
Create names from row and column labels
Fill down
Fill to the right
Define a name
ard Shortctus (239 Shortcuts)
olumns and objects
rmatting and calculating data
-
7/30/2019 239 Excel Shortcut
8/17
Insert a hyperlink
Enter the date
Enter the time
Display a drop-down list of the values in the current column of a range
Undo the last action
Enters the cent character
Enters the pound sterling characterEnters the yen symbol
Enters the euro symbol
Start a formula
Move the insertion point into the Formula Bar when editing in a cell is turned off
In the Formula Bar, delete one character to the left
Complete a cell entry from the cell or Formula Bar
Enter a formula as an array formula. Array formulas are enclosed between braces { } and are entered by pressi
Cancel an entry in the cell or Formula Bar
In a formula, display the Insert Function dialog box
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog bWhen the insertion point is to the right of a function name in a formula, insert the argument names and parenth
Paste a defined name into a formula
Insert an AutoSum formula with the SUM function
Copy the value from the cell above the active cell into the cell or the Formula Bar
Copies a formula from the cell above the active cell into the cell or the Formula Bar
Alternate between displaying cell values and displaying formulas
Calculate all worksheets in all open workbooks
Calculate the active worksheet
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculat
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as
Excel cells
Edit the active cell and position the insertion point at the end of the cell contents
Start a new line in the same cell
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
Delete the character to the right of the insertion point, or delete the selection
Delete text to the end of the line
Display the Spelling dialog box
Edit a cell comment
Complete a cell entry and select the next cell below
Undo the last action
Cancel a cell entry
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction
Copy the selected cells
Cut the selected cellsPaste copied cells
Clear the contents of the selected cells
Delete the selected cells
Insert blank cells
Display the Style dialog box
Display the Format Cells dialog box
as in Excel
-
7/30/2019 239 Excel Shortcut
9/17
Apply the General number format
Apply the Currency format with two decimal places (negative numbers in parentheses)
Apply the Percentage format with no decimal places
Apply the Exponential number format with two decimal places
Apply the Date format with the day, month, and year
Apply the Time format with the hour and minute, and AM or PM
Apply the Number format with two decimal places, thousands separator, and minus sign () for negative valuesApply or remove bold formatting
Apply or remove italic formatting
Apply or remove underlining
Apply or remove strikethrough
Hide the selected rows
Unhide any hidden rows within the selection
Hide the selected columns
Unhide any hidden columns within the selection
Apply the outline border to the selected cells
Remove the outline border from the selected cells
Display the Help task pane
Switch between the Help task pane and the active application
Select the next item in the Help task pane
Select the previous item in the Help task pane
Perform the action for the selected item
In a Table of Contents, select the next and previous item, respectively
In a Table of Contents, expand and collapse the selected item, respectively
Move back to the previous task Pane
Move forward to the next task Pane
Open the menu of Pane options
Close and reopen the current task pane
Expand a +/- list
Collapse a +/- list
Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic
Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web sit
Perform the action for the selected Show All, Hide All, hidden text, or hyperlink
Move back to the previous Help topic.
Move forward to the next Help topic
Print the current Help topic
Scroll small amounts up and down, respectively, within the currently-displayed Help topic
Scroll larger amounts up and down, respectively, within the currently-displayed Help topic
Change whether the Help window appears connected to (tiled) or separate from (untiled) the active application
Display a menu of commands for the Help window; requires that the Help window have active focus (click an ite
Move to a task pane
When a menu or toolbar is active, move to a task pane. (You may need to press CTRL+TAB more than once.)
When a task pane is active, select the next or previous option in the task pane
Display the full set of commands on the task pane menu
Move among choices in a selected submenu; move among certain options in a group of options
Open the selected menu, or perform the action assigned to the selected button
-
7/30/2019 239 Excel Shortcut
10/17
Open a shortcut menu open a drop-down menu for the selected gallery item
When a menu or submenu is visible, select the first or last command on the menu or submenu
Scroll up or down in the selected gallery list
Move to the top or bottom of the selected gallery list
h Shortcuts in Excel
Select the menu bar or close an open menu and submenu at the same timeWhen a toolbar is selected, select the next or previous button or menu on the toolbar
When a toolbar is selected, select the next or previous toolbar
Open the selected menu, or perform the action for the selected button or command
Display the shortcut menu for the selected item
Display the Control menu for the Excel window
When a menu or submenu is open, select the next or previous command
Select the menu to the left or right. When a submenu is open, switch between the main menu and the submenu
Select the first or last command on the menu or submenu
Close an open menu. When a submenu is open, close only the submenu
Display the full set of commands on a menu
Show or hide the Standard toolbar
Move to the next option or option group
Move to the previous option or option group
Switch to the next tab in a dialog box
Switch to the previous tab in a dialog box
Move between options in an open drop-down list, or between options in a group of options
Perform the action for the selected button, or select or clear the selected check box
Select an option, or select or clear a check box of underlined LETTER option
Open the selected drop-down list
Perform the action for the default command button in the dialog box (the button with the bold outline, often the
Cancel the command and close the dialog box
ialog boxes
Move to the beginning of the entry
Move to the end of the entry
Move one character to the left or right
Move one word to the left
Move one word to the right
Select or unselect one character to the left
Select or unselect one character to the right
Select or unselect one word to the left
Select or unselect one word to the right
Select from the insertion point to the beginning of the entry
Select from the insertion point to the end of the entry
re dialog boxes
Go to the previous folder
Up One Level button: open the folder up one level above the open folder
Search the Web button: close the dialog box and open your Web search page
Delete button: delete the selected folder or file
Create New Folder button: create a new folder
Views button: switch among available folder views
-
7/30/2019 239 Excel Shortcut
11/17
Tools button: show the Tools menu
Display a shortcut menu for a selected item such as a folder or file
Move between options or areas in the dialog box
Open the Look in list
Refresh the file list
Display the Print dialog box
Insert a new worksheet
Move to the next sheet in the workbook
Move to the previous sheet in the workbook
Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to sele
Select the current and previous sheet
Rename the current sheet (Format menu, Sheet submenu, rename)
Move or copy the current sheet (Edit menu, Move or Copy Sheet command)
Delete the current sheet (Edit menu, Delete Sheet command)
Move one cell up, down, left, or right
Move to the edge of the current data region
Move to the beginning of the rowMove to the beginning of the worksheet
Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column
Move down one screen
Move up one screen
Move one screen to the right
Move one screen to the left
Switch to the next pane in a worksheet that has been split (Window menu, Split command)
Switch to the previous pane in a worksheet that has been split
Scroll to display the active cell
Display the Go To dialog box
Display the Find dialog box
Repeat the last Find action (same as Find Next)
Move between unlocked cells on a protected worksheet
ted range
Move from top to bottom within the selected range
Move from bottom to top within the selected range
Move from left to right within the selected range. If cells in a single column are selected, move down
Move from right to left within the selected range. If cells in a single column are selected, move up
Move clockwise to the next corner of the selected range
In nonadjacent selections, switch to the next selection to the right
Switch to the next nonadjacent selection to the left
display this dialog boxApply or remove the top border
Apply or remove the bottom border
Apply or remove the left border
Apply or remove the right border
If cells in multiple rows are selected, apply or remove the horizontal divider
If cells in multiple columns are selected, apply or remove the vertical divider
Apply or remove the downward diagonal border
Apply or remove the upward diagonal border
ialog box
-
7/30/2019 239 Excel Shortcut
12/17
In the cell that contains the drop-ARROW DOWN, displays the AutoFilter list for the current column
Closes the AutoFilter list for the current column
Selects the next item in the AutoFilter list
Selects the previous item in the AutoFilter list
Selects the first item (All) in the AutoFilter listSelects the last item in the AutoFilter list
Filters the range based on the item selected from the AutoFilter list
Groups rows or columns
Ungroups rows or columns
Displays or hides the outline symbols
Hides the selected rows
Unhides any hidden rows within the selection
Hides the selected columns
Unhides any hidden columns within the selection
-
7/30/2019 239 Excel Shortcut
13/17
PivotTable report, select the entire PivotTable report
ction
dd, and then press F8 and the arrow keys to select the next range
ansition navigation keys (Tools menu, Options command, Transition tab)
-
7/30/2019 239 Excel Shortcut
14/17
g CTRL+SHIFT+ENTER
xses
ion
needing to be calculated
-
7/30/2019 239 Excel Shortcut
15/17
article
m in the Help window)
-
7/30/2019 239 Excel Shortcut
16/17
K button)
-
7/30/2019 239 Excel Shortcut
17/17
ct a different sheet, press CTRL+PAGE UP