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