Function Shortcut Keys
|
Key
|
Description
|
F1
|
Displays the Help task pane.
|
CTRL+F1
|
Closes and reopens the current task pane.
|
ALT+F1
|
Creates a chart of the data in the current range.
|
ALT+SHIFT+F1
|
Inserts a new worksheet.
|
F2
|
Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
|
SHIFT+F2
|
Edits a cell comment.
|
F3
|
Pastes a defined name into a formula.
|
SHIFT+F3
|
Displays the Insert Function dialog box.
|
F4
|
Repeats the last command or action, if possible.
|
CTRL+F4
|
Closes the selected workbook window.
|
CTRL+F5
|
Restores the window size of the selected workbook window.
|
F6
|
Switches to the next pane in a worksheet that has been split (Window menu, Split command).
|
SHIFT+F6
|
Switches to the previous pane in a worksheet that has been split.
|
CTRL+F6
|
Switches to the next workbook window when more than one workbook window is open.
|
SHIFT+F6
|
Note When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes.
|
F7
|
Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
|
CTRL+F7
|
Performs the Move command on the workbook window when it is not maximized. Use the arrow Keys to move the window, and when finished press ESC.
|
F8
|
Turns extend mode on or off. In extend mode; EXT appears in the status line, and the arrow Keys extend the selection.
|
SHIFT+F8
|
Enables you to add a non-adjacent cell or range to a selection of cells by using the arrow Keys.
|
CTRL+F8
|
Performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
|
ALT+F8
|
Displays the Macro dialog box to run, edit, or delete a macro.
|
F9
|
Calculates all worksheets in all open workbooks.
|
F9
|
F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value.
|
SHIFT+F9
|
Calculates the active worksheet.
|
CTRL+ALT+F9
|
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
|
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.
|
CTRL+F9
|
Minimizes a workbook window to an icon.
|
F10
|
Selects the menu bar or closes an open menu and submenu at the same time.
|
SHIFT+F10
|
Displays the shortcut menu for a selected item.
|
ALT+SHIFT+F10
|
Displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message.
|
CTRL+F10
|
Maximizes or restores the selected workbook window.
|
F11
|
Creates a chart of the data in the current range.
|
SHIFT+F11
|
Inserts a new worksheet.
|
ALT+F11
|
Opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
|
ALT+SHIFT+F11
|
Opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code.
|
F12
|
Displays the Save As dialog box.
|
CTRL + Key Shortcut Description
|
Key
|
Description
|
CTRL+(
|
Unhide any hidden rows within the selection.
|
CTRL+)
|
Unhide any hidden columns within the selection.
|
CTRL+&
|
Applies the outline border to the selected cells.
|
CTRL+_
|
Removes the outline border from the selected cells.
|
CTRL+~
|
Applies the General number format.
|
CTRL+$
|
Applies the Currency format with two decimal places (negative numbers in parentheses).
|
CTRL+%
|
Applies the Percentage format with no decimal places.
|
CTRL+^
|
Applies the Exponential number format with two decimal places.
|
CTRL+#
|
Applies the Date format with the day, month, and year.
|
CTRL+@
|
Applies the Time format with the hour and minute, and AM or PM.
|
CTRL+!
|
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
|
CTRL+-
|
Displays the Delete dialog box to delete the selected cells.
|
CTRL+*
|
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
|
CTRL+:
|
Enters the current time.
|
CTRL+;
|
Enters the current date.
|
CTRL+`
|
Alternates between displaying cell values and displaying formulas in the worksheet.
|
CTRL+’
|
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
|
CTRL+”
|
Copies the value from the cell above the active cell into the cell or the Formula Bar.
|
CTRL++
|
Displays the Insert dialog box to insert blank cells.
|
CTRL+1
|
Displays the Format Cells dialog box.
|
CTRL+2
|
Applies or removes bold formatting.
|
CTRL+3
|
Applies or removes italic formatting.
|
CTRL+4
|
Applies or removes underlining.
|
CTRL+5
|
Applies or removes strikethrough.
|
CTRL+6
|
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
|
CTRL+7
|
Displays or hides the Standard toolbar.
|
CTRL+8
|
Displays or hides the outline symbols.
|
CTRL+9
|
Hides the selected rows.
|
CTRL+0
|
Hides the selected columns.
|
CTRL+A
|
Selects the entire worksheet.
|
CTRL+A
|
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
|
CTRL+B
|
Applies or removes bold formatting.
|
CTRL+C
|
Copies the selected cells.
|
CTRL+C
|
CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.
|
CTRL+D
|
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
|
CTRL+F
|
Displays the Find dialog box.
|
CTRL+G
|
Displays the Go To dialog box.
|
F5
|
F5 also displays this dialog box.
|
CTRL+H
|
Displays the Find and Replace dialog box.
|
CTRL+I
|
Applies or removes italic formatting.
|
CTRL+K
|
Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
|
CTRL+L
|
Displays the Create List dialog box.
|
CTRL+N
|
Creates a new, blank file.
|
CTRL+O
|
Displays the Open dialog box to open or find a file.
|
CTRL+SHIFT+O
|
Selects all cells that contain comments.
|
CTRL+P
|
Displays the Print dialog box.
|
CTRL+R
|
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
|
CTRL+S
|
Saves the active file with its current file name, location, and file format.
|
CTRL+U
|
Applies or removes underlining.
|
CTRL+V
|
Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
|
CTRL+W
|
Closes the selected workbook window.
|
CTRL+X
|
Cuts the selected cells.
|
CTRL+Y
|
Repeats the last command or action, if possible.
|
CTRL+Z
|
Uses the Undo command to reverse the last command or to delete the last entry you typed.
|
CTRL+SHIFT+Z
|
Uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
|
|
|
Other useful shortcut Keys
|
Key
|
Description
|
ARROW KEYS
|
Move one cell up, down, left, or right in a worksheet.
|
CTRL+ARROW KEY
|
Moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
|
SHIFT+ARROW KEY
|
Extends the selection of cells by one cell.
|
CTRL+SHIFT+ARROW KEY
|
Extends the selection of cells to the last nonblank cell in the same column or row as the active cell.
|
CTRL+SHIFT+ARROW KEY
|
LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow Keys switch between the main menu and the submenu.
|
CTRL+SHIFT+ARROW KEY
|
DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open.
|
CTRL+SHIFT+ARROW KEY
|
In a dialog box, arrow Keys move between options in an open drop-down list, or between options in a group of options.
|
ALT+DOWN ARROW
|
Opens a selected drop-down list.
|
BACKSPACE
|
Deletes one character to the left in the Formula Bar.
|
BACKSPACE
|
Also clears the content of the active cell.
|
DELETE
|
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
|
DELETE
|
In cell editing mode, it deletes the character to the right of the insertion point.
|
END
|
Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on.
|
END
|
Also selects the last command on the menu when a menu or submenu is visible.
|
CTRL+END
|
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.
|
CTRL+SHIFT+END
|
Extends the selection of cells to the last used cell on the worksheet (lower-right corner).
|
ENTER
|
Completes a cell entry from the cell or the Formula Bar,
and selects the cell below (by default).
|
ENTER
|
In a data form, it moves to the first field in the next
record.
|
ENTER
|
Opens a selected menu (press F10 to activate the menu
bar) or performs the action for a selected command.
|
ENTER
|
In a dialog box, it performs the action
for the default command button in the
dialog box (the button with the bold
outline, often the OK button).
|
ALT+ENTER
|
Starts a new line in the same cell.
|
CTRL+ENTER
|
Fills the selected cell range with the current entry.
|
SHIFT+ENTER
|
Completes a cell entry and selects the cell above.
|
ESC
|
Cancels an entry in the cell or Formula Bar.
|
ESC
|
It also closes an open menu or submenu, dialog box, or message window.
|
HOME
|
Moves to the beginning of a row in a worksheet.
|
HOME
|
Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on.
|
HOME
|
Selects the first command on the menu when a menu or submenu is visible.
|
CTRL+HOME
|
Moves to the beginning of a worksheet.
|
CTRL+SHIFT+HOME
|
Extends the selection of cells to the beginning of the worksheet.
|
PAGE DOWN
|
Moves one screen down in a worksheet.
|
ALT+PAGE DOWN
|
Moves one screen to the right in a worksheet.
|
CTRL+PAGE DOWN
|
Moves to the next sheet in a workbook.
|
CTRL+SHIFT+PAGE DOWN
|
Selects the current and next sheet in a workbook.
|
PAGE UP
|
Moves one screen up in a worksheet.
|
ALT+PAGE UP
|
Moves one screen to the left in a worksheet.
|
CTRL+PAGE UP
|
Moves to the previous sheet in a workbook.
|
CTRL+SHIFT+PAGE UP
|
Selects the current and previous sheet in a workbook.
|
SPACEBAR
|
In a dialog box, performs the action for the selected button, or selects or clears a check box.
|
CTRL+SPACEBAR
|
Selects an entire column in a worksheet.
|
SHIFT+SPACEBAR
|
Selects an entire row in a worksheet.
|
CTRL+SHIFT+SPACEBAR
|
Selects the entire worksheet.
|
ALT+SPACEBAR
|
Displays the Control menu for the Excel window.
|
TAB
|
Moves one cell to the right in a worksheet.
|
TAB
|
Moves between unlocked cells in a protected worksheet.
|
TAB
|
Moves to the next option or option group in a dialog box.
|
SHIFT+TAB
|
Moves to the previous cell in a worksheet or the previous option in a dialog box.
|
CTRL+TAB
|
Switches to the next tab in dialog box.
|
CTRL+SHIFT+TAB
|
Switches to the previous tab in a dialog box.
|