Excel Keyboard Shortcuts

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 pressCTRL+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 orCTRL+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 orCTRL+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 orCTRL+PAGE DOWN	Switch to the next tab in a dialog box
156	CTRL+SHIFT+TAB orCTRL+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 orCTRL+SHIFT+F12	Display the Print dialog box
186	SHIFT+F11 orALT+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

Source: