Keyboard Shortcuts by Key

This section lists the available keyboard shortcuts according to their position on the keyboard.

Function Keys

Open table as spreadsheet

Press	To
F1	Display the Help window.
Ctrl+F1	Show/hide the Ribbon.
Alt+F1	Insert a chart as an object.
Shift+Alt+F1	Insert a new worksheet.
Ctrl+Alt+F1	Insert a Microsoft Office Excel 4 macro worksheet.
F2	Toggle Edit and Enter modes.
Shift+F2	Insert/edit a comment.
Alt+F2	Display the Save As dialog box.
Shift+Alt+F2	Save.
Ctrl+Alt+F2	Display the Open dialog box.
Shift+Ctrl+Alt+F2	Display the Print dialog box.
F3	Display the Paste Name dialog box.
Shift+F3	Display the Insert Function dialog box.
Ctrl+F3	Display the Name Manager dialog box.
Shift+Ctrl+F3	Display the Create Names From Selection dialog box.
F4	Activate cell A1.
Shift+F4	Find the next (from the most recent search).
Ctrl+F4	Close the workbook.
Alt+F4	Close the application.
Shift+Ctrl+F4	Find the previous (from the most recent search).
Shift+Alt+F4	Close the application.
Ctrl+Alt+F4	Close the application.
Shift+Ctrl+Alt+F4	Close the application.
F5	Display the Go To dialog box.
Shift+F5	Display the Find And Replace dialog box.
Ctrl+F5	Restore the window.
Shift+F6	Display shortcut key pop-ups.
Ctrl+F6	Next window.
Shift+Ctrl+F6	Previous window.
F7	Check spelling.
Ctrl+F7	Move the window.
F8	Extend the selection mode.
Alt+F8	Display the Macro dialog box.
F9	Calculate all, or when a portion of a formula is selected, calculate the selected portion.
Shift+F9	Calculate the active worksheet.
Ctrl+F9	Minimize the active window.
Ctrl+Alt+F9	Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl+Shift+Alt+F9	Recheck dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.
F10	Display shortcut key pop-ups.
Shift+F10	Activate shortcut (context) menus.
Ctrl+F10	Toggle the maximized/restored window.
F11	Insert a chart on a new worksheet.
Shift+F11	Create a new worksheet.
Ctrl+F11	Create a new macro worksheet.
Alt+F11	Show the Visual Basic Editor.
F12	Display the Save As dialog box.
Shift+F12	Save.
Ctrl+F12	Display the Open dialog box.
Shift+Ctrl+F12	Display the Print dialog box.

Control and Navigation Keys

Open table as spreadsheet

Press	To
Backspace	Edit and clear.
Shift+Backspace	Collapse the selection to the active cell.
Ctrl+Backspace	Show the active cell.
Alt+Backspace	Undo.
Delete	Clear.
Shift+Delete	Cut.
Ctrl+Delete	Clear.
End	Toggle End mode.
Shift+End	Toggle End mode (and extend when you press Shift+arrow key).
Ctrl+End	Select the last cell in the worksheet.
Shift+Ctrl+End	Extend the selection to the last cell in the worksheet.
Escape	Cancel (edit, copy, cut, dialog, and so on).
Shift+Escape	Cancel (edit, copy, cut, dialog, and so on).
Ctrl+Escape	Display the Windows Start menu.
Shift+Ctrl+Escape	Display the Windows Task Manager.
Enter	Enter the value, and move down.
Shift+Enter	Enter the value, and move up.
Ctrl+Enter	Fill the value in edited cell into all cells, and do not move.
Alt+Enter	Redo.
Shift+Ctrl+Enter	Fill the value in edited cell into all cells, and do not move.
Home	Select the first cell in the row.
Shift+Home	Extend the selection to the first cell in the row.
Ctrl+Home	Select the first cell in window (or pane).
Shift+Ctrl+Home	Extend the selection to the first cell in the window or pane.
Insert	Toggle Overwrite mode in Edit mode.
Shift+Insert	Paste.
Ctrl+Insert	Copy.
Left Arrow	Move left one cell.
Down Arrow	Move down one cell.
Shift+Down Arrow	Extend the selection down one cell.
Ctrl+Down Arrow	Select the last cell in the area down.
Alt+Down Arrow	Open the list (AutoComplete, Filter, Pick From List, or Validation).
Shift+Ctrl+Down Arrow	Extend the selection down to the last cell in the area down.
Shift+Left Arrow	Extend the selection left one cell.
Ctrl+Left Arrow	Select the last cell in the area left.
Shift+Ctrl+Left Arrow	Extend the selection down to the last cell in the area left.
Shift+Alt+Left Arrow	Ungroup.
Ctrl+Alt+Left Arrow	Move the active cell to the previous nonadjacent area within the selection.
Right Arrow	Move right one cell.
Shift+Right Arrow	Extend the selection right one cell.
Ctrl+Right Arrow	Select the last cell in the area right.
Shift+Ctrl+Right Arrow	Extend the selection down to the last cell in the area right.
Shift+Alt+Right Arrow	Group.
Ctrl+Alt+Right Arrow	Move the active cell to the next nonadjacent area within the selection.
Up Arrow	Move up one cell.
Shift+Up Arrow	Extend the selection up one cell.
Ctrl+Up Arrow	Select the cell at the top of the region.
Shift+Ctrl+Up Arrow	Extend the selection up to the end of the region.
Page Down	Scroll down one page.
Shift+Page Down	Extend the selection down one page.
Ctrl+Page Down	Move to the next worksheet.
Alt+Page Down	Scroll one page right.
Shift+Ctrl+Page Down	Extend the selection one worksheet down.
Shift+Alt+Page Down	Extend the selection one page right.
Page Up	Scroll up one page.
Shift+PageUp	Extend the selection one page up.
Ctrl+Page Up	Move to the previous worksheet.
Alt+Page Up	Scroll one page left.
Shift+Ctrl+PageUp	Extend the selection one worksheet up.
Shift+Alt+PageUp	Extend the selection one page left.
Return	Enter the value, and move down.
Shift+Return	Enter the value, and move up.
Ctrl+Return	Fill the value in the edited cell into all cells, and do not move.
Alt+Return	Redo.
Shift+Ctrl+Return	Fill the value in the edited cell into all cells, and do not move.
Shift+Space	Select row.
Ctrl+Space	Select column.
Shift+Ctrl+Space	Select all.
Tab	Move to the next cell to the right.
Shift+Tab	Move to the next cell to the left.
Ctrl+Tab	Move to the next window.
Alt+Tab	Move to the next application.
Shift+Ctrl+Tab	Move to the previous window.
Shift+Alt+Tab	Indent.
Ctrl+Alt+Tab	Outdent.

Numeric Keys

Open table as spreadsheet

Press	To
Ctrl+0	Hide the column.
Ctrl+1	Display the Format Cells dialog box.
Shift+Ctrl+1	Apply the two-decimal-place comma Number format.
Ctrl+2	Toggle the Bold format.
Shift+Ctrl+2	Apply the Time (AM/PM) format.
Ctrl+3	Toggle the Italic format.
Shift+Ctrl+3	Apply the Date format.
Ctrl+4	Toggle the Underline format.
Shift+Ctrl+4	Apply the Currency format.
Ctrl+5	Toggle the Strikethrough format.
Shift+Ctrl+5	Apply the Percentage format.
Ctrl+6	Toggle the display of objects.
Shift+Ctrl+6	Apply the two-place Scientific format.
Shift+Ctrl+7	Apply the Outline border format.
Ctrl+8	Toggle the outline symbol display.
Shift+Ctrl+8	Select the current region.
Ctrl+9	Hide the row.
Shift+Ctrl+9	Show the row.

Symbols and Keypad

Open table as spreadsheet

Press	To
Ctrl+' (apostrophe)	Copy the above cell, and edit.
Alt+' (apostrophe)	Activates the cell style list or dialog box.
Shift+Ctrl+' (apostrophe)	Copy the above cell, and edit.
Ctrl+- (hyphen)	Display the Delete dialog box.
Shift+Ctrl+- (hyphen)	Remove all the borders.
Shift+Ctrl+, (comma)	Fill down.
Ctrl+. (period)	Rotates the active cell through the corners of the selection.
Shift+Ctrl+. (period)	Fill right.
Ctrl+/ (slash)	Select array.
Ctrl+; (semicolon)	Insert the current date.
Shift+Ctrl+; (semicolon)	Insert the current time.
Ctrl+[(open bracket)	Select the direct precedent cells.
Shift+Ctrl+[(open bracket)	Select all the precedent cells.
Ctrl+] (close bracket)	Select the directly dependent cells.
Shift+Ctrl+] (close bracket)	Select all the dependent cells.
Ctrl+Shift+{ (open brace)	Select all the cells directly or indirectly referenced by formulas in the selection.
Ctrl+Shift+} (close brace)	Select cells that contain formulas that directly or indirectly reference the active cell.
Ctrl+' (single left quotation mark)	Display formulas.
Shift+Ctrl+' (single left quotation mark)	Apply the General format.
Ctrl+= (equal sign)	Calculate now.
Alt+= (equal sign)	AutoSum.
Shift+Ctrl+= (equal sign)	Display the Insert dialog box.
Ctrl+Add (keypad)	Display the Insert dialog box.
Ctrl+Decimal (keypad)	Rotates the active cell through the corners of the selection.
Ctrl+Divide (keypad)	Select the array.
Ctrl+Multiply (keypad)	Select the current region.
Ctrl+Subtract (keypad)	Display the Delete dialog box.

Alphabet Keys

Open table as spreadsheet

Press	To
Ctrl+A	Select the current region, or select all.
Shift+Ctrl+A	Insert arguments in the formula.
Ctrl+B	Apply the Bold format.
Ctrl+C	Copy.
Ctrl+D	Fill down.
Ctrl+F	Display the Find And Replace dialog box, Find tab.
Shift+Ctrl+F	Display the Format Cells dialog box, Font tab.
Ctrl+G	Display the Go To dialog box.
Ctrl+H	Display the Find And Replace dialog box, Replace tab.
Ctrl+I	Apply the Italic format.
Ctrl+K	Display the Insert Hyperlink dialog box.
Ctrl+L	Display the Create Table dialog box.
Shift+Ctrl+L	Toggle Filter.
Ctrl+N	Create a new workbook.
Ctrl+O	Display the Open dialog box.
Shift+Ctrl+O	Select the first cell containing a comment.
Ctrl+P	Display the Print dialog box.
Shift+Ctrl+P	Display the Format Cells dialog box, Font tab.
Ctrl+R	Fill right.
Ctrl+S	Save the workbook.
Ctrl+T	Display the Create Table dialog box.
Shift+Ctrl+T	Toggle the total row (when the table is selected).
Ctrl+U	Toggle the Underline format.
Ctrl+V	Paste.
Ctrl+W	Close the window.
Ctrl+X	Cut.
Ctrl+Y	Redo.
Ctrl+Z	Undo.