Alternates between displaying cell values and displaying formulas in the worksheet. | CTRL+` |
Alternates between hiding objects, displaying objects, and displaying placeholders for objects. | CTRL+6 |
Applies or removes bold formatting | CTRL+2 |
Applies or removes bold formatting | CTRL+B |
Applies or removes italic formatting | CTRL+3 |
Applies or removes italic formatting | CTRL+I |
Applies or removes underlining | CTRL+4 |
Applies or removes underlining | CTRL+V |
Applies the Currency format with two decimal places | CTRL+$ |
Applies the Date format with the day, month, and year | CTRL+# |
Applies the Exponential number format with two decimal places | CTRL+^ |
Applies the General number format | CTRL+~ |
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values | CTRL+! |
Applies the outline border to the selected cells | CTRL+& |
Applies the Percentage format with no decimal places | CTRL+% |
Applies the Time format with the hour and minute, and AM or PM | CTRL+@ |
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation | CTRL+ALT+F9 |
Calculates all worksheets in all open workbooks | F9 |
Calculates the active worksheet | SHIFT+F9 |
Closes and reopens the current task pane | CTRL+F1 |
Closes the selected workbook window | CTRL+F4 |
Closes the selected workbook window | CTRL+X |
Copies the selected cells | CTRL+C |
Copies the value from the cell above the active cell into the cell or the Formula Bar" | CTRL+" |
Creates a chart of the data in the current range | ALT+F1 |
Creates a chart of the data in the current range | F11 |
Cuts the selected cells | CTRL+Y |
Displays or hides the outline symbols | CTRL+8 |
Displays or hides the Standard toolbar | CTRL+7 |
Displays the Create List dialog box. CTRL+N Creates a new, blank file | CTRL+L |
Displays the Delete dialog box to delete the selected cells | CTRL+- |
Displays the Find and Replace dialog box | CTRL+H |
Displays the Format Cells dialog box | CTRL+1 |
Displays the Go To dialog box | CTRL+G |
Displays the Go To dialog box | F5 |
Displays the Help task pane | F1 |
Displays the Insert dialog box to insert blank cells | CTRL++ |
Displays the Insert Function dialog box | SHIFT+F3 |
Displays the Macro dialog box to run, edit, or delete a macro | ALT+F8 |
Displays the Microsoft Office Clipboard | CTRL+C |
Displays the Open dialog box to open or find a file | CTRL+O |
Displays the Print dialog box | CTRL+R |
Displays the Save As dialog box | F12 |
Displays the shortcut menu for a selected item | SHIFT+F10 |
Displays the Spelling dialog box to check spelling in the active worksheet or selected range | F7 |
Edits a cell comment | SHIFT+F2 |
Enters the current date | CTRL+; |
Enters the current time | CTRL+: |
Hides the selected columns | CTRL+0 |
Hides the selected rows | CTRL+9 |
Including cells not marked as needing to be calculated | CTRL+F9 |
Inserts a new worksheet | ALT+SHIFT+F1 |
Inserts a new worksheet | SHIFT+F11 |
Maximizes or restores the selected workbook window | CTRL+F10 |
Minimizes a workbook window to an icon | F10 |
Pastes a defined name into a formula | F3 |
Removes the outline border from the selected cells | CTRL+_ |
Repeats the last command or action, if possible | CTRL+Z |
Repeats the last command or action, if possible | F4 |
Restores the window size of the selected workbook window | CTRL+F5 |
Saves the active file with its current file name and location | CTRL+S |
Selects all cells that contain comments | CTRL+SHIFT+O |
Selects the current region | CTRL+A |
Selects the entire worksheet | CTRL+A CTRL+A (two times) |
Undo command | CTRL+U |
Unhides any hidden columns within the selection | CTRL+ |
Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys | |
To | Press |
Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) | CTRL+SHIFT+* (ASTERISK) |
Extend the selection by one cell | SHIFT+ arrow key |
Extend the selection to the last nonblank cell in the same column or row as the active cell | CTRL+SHIFT+ arrow key |
Extend the selection to the beginning of the row | SHIFT+HOME |
Extend the selection to the beginning of the worksheet | CTRL+SHIFT+HOME |
Extend the selection to the last cell used on the worksheet (lower-right corner) | CTRL+SHIFT+END |
Select the entire column | CTRL+SPACEBAR |
Select the entire row | SHIFT+SPACEBAR |
Select the entire worksheet | CTRL+A |
If multiple cells are selected, select only the active cell | SHIFT+BACKSPACE |
Extend the selection down one screen | SHIFT+PAGE DOWN |
Extend the selection up one screen | SHIFT+PAGE UP |
With an object selected, select all objects on a sheet | CTRL+SHIFT+SPACEBAR |
Alternate between hiding objects, displaying objects, and displaying placeholders for objects | CTRL+6 |
Show or hide the Standard toolbar | CTRL+7 |
In End mode, to | Press |
Turn End mode on or off | END |
Extend the selection to the last nonblank cell in the same column or row as the active cell | END, SHIFT+ arrow key |
Extend the selection to the last cell used on the worksheet (lower-right corner) | END, SHIFT+HOME |
Extend the selection to the last cell in the current row; this keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) | END, SHIFT+ENTER |
With SCROLL LOCK on, to | Press |
Turn SCROLL LOCK on or off | SCROLL LOCK |
Scroll the screen up or down one row | UP ARROW or DOWN ARROW |
Scroll the screen left or right one column | LEFT ARROW or RIGHT ARROW |
Extend the selection to the cell in the upper-left corner of the window | SHIFT+HOME |
Extend the selection to the cell in the lower-right corner of the window | SHIFT+END |
Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first. | |
Select cells with special characteristics by using shortcut keys | |
To | Press |
Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) | CTRL+SHIFT+* (ASTERISK) |
Select the current array, which is the array that the active cell belongs to | CTRL+/ |
Select all cells with comments | CTRL+SHIFT+O (the letter O) |
Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell) | CTRL+\ |
Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell) | CTRL+SHIFT+| |
Select only cells that are directly referred to by formulas in the selection | CTRL+[ |
Select all cells that are directly or indirectly referred to by formulas in the selection | CTRL+SHIFT+{ |
Select only cells with formulas that refer directly to the active cell | CTRL+] |
Select all cells with formulas that refer directly or indirectly to the active cell | CTRL+SHIFT+} |
Select only visible cells in the current selection | ALT+SEMICOLON |
Select chart items by using shortcut keys | |
To | Press |
Select the previous group of items | DOWN ARROW |
Select the next group of items | UP ARROW |
Select the next item within the group | RIGHT ARROW |
Select the previous item within the group | LEFT ARROW |