| Shortcut Keys to Display and Use Windows
|
|---|
| Press Keys | To Do
|
|---|
| Alt+Tab | Switch to the next program.
|
| Alt+Shift+Tab | Switch to the previous program.
|
| Ctrl+ESC | Display the Windows Start menu.
|
| Ctrl+W or Ctrl+F4 | Close the selected workbook window.
|
| Ctrl+F5 | Restore the window size of the selected workbook window.
|
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command).
|
| Shift+F6 | Switch to the previous pane in a worksheet that has been split.
|
| Ctrl+F6 | When more than one workbook window is open, switch to the next workbook window.
|
| Ctrl+Shift+F6 | Switch to the previous workbook window.
|
| Ctrl+F7 | When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
|
| Ctrl+F8 | When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press Enter.
|
| Ctrl+F9 | Minimize a workbook window to an icon.
|
| Ctrl+F10 | Maximize or restore the selected workbook window.
|
| Print Screen | Copy a picture of the screen to the Clipboard.
|
| Alt+Print Screen | Copy a picture of the selected window to the Clipboard. |
| Shortcut Keys for Print and Print Preview
|
|---|
| Press Keys | To Do
|
|---|
| Ctrl+P or Ctrl+Shift+F12 | Display the Print dialog box
|
| Work with Worksheets
|
| Shift+F11 or Alt+Shift+F1 | Insert a new worksheet.
|
| Ctrl+Page Down | Move to the next sheet in the workbook.
|
| Ctrl+Page Up | Move to the previous sheet in the workbook.
|
| 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.
|
| Shift+Ctrl+Page Up | Select the current and previous sheet.
|
| Alt+O, H, R | Rename the current sheet (Format menu, Sheet submenu, Rename command).
|
| Alt+E, M | Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
|
| Alt+E, L | Delete the current sheet (Edit menu, Delete Sheet command). |
| Shortcut Keys to Move and Scroll within a Worksheet
|
|---|
| Press Keys | To Do
|
|---|
| Arrow keys | Move one cell up, down, left, or right.
|
| Tab | Move one cell to the right.
|
| Shift+Tab | Move one cell to the left.
|
| Ctrl+Arrow key | Move to the edge of the current data region (A range of cells that contains data and that is bounded by empty cells or worksheet borders).
|
| Home | Move to the beginning of the row.
|
| Ctrl+Home | Move to the beginning of the worksheet
|
| Ctrl+End | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
|
| Page Down | Move down one screen.
|
| Page Up | Move up one screen.
|
| Alt+Page Down | Move one screen to the right.
|
| Alt+Page Up | Move one screen to the left.
|
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command).
|
| Ctrl+Backspace | Scroll to display the active cell.
|
| F5 | Display the Go To dialog box.
|
| Shift+F5 | Display the Find dialog box.
|
| Shift+F4 | Repeat the last Find action (same as Find Next).
|
| Tab | Move between unlocked cells on a protected worksheet. |
| Shortcut Keys to Move within a Selected Range
|
|---|
| Press Keys | To Do
|
|---|
| Enter | Move from top to bottom within the selected range
|
| Shift+Enter | Move from bottom to top within the selected range
|
| Tab | Move from left to right within the selected range. If cells in a single column are selected, move down.
|
| Shift+Tab | Move from right to left within the selected range. If cells in a single column are selected, move up.
|
| Ctrl+PERIOD | Move clockwise to the next corner of the selected range.
|
| Ctrl+Alt+Right Arrow | In nonadjacent selections, switch to the next selection to the right.
|
| Ctrl+Alt+Left Arrow | Switch to the next nonadjacent selection to the left. |
| Shortcut Keys to Extend Selection
|
|---|
| Press Keys | To Do
|
|---|
| F8 | Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.
|
| 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.
|
| Shift+Arrow Key | Extend the selection by one cell
|
| Ctrl+Shift+Arrow key | Extend the selection to the last non-blank cell in the same column or row as the active cell
|
| Shift+Home | Extend the selection to the beginning of the row.
|
| Ctrl+Shift+Home | Extend the selection to the beginning of the worksheet.
|
| Ctrl+Shift+End | Extend the selection to the last used cell on the worksheet (lower-right corner).
|
| Shift+Page Down | Extend the selection down one screen.
|
| Shift+Page Up | Extend the selection up one screen.
|
| End+Shift+Arrow key | Extend the selection to the last non-blank cell in the same column or row as the active cell.
|
| End+Shift+Home | Extend the selection to the last used cell on the worksheet (lower-right corner). |
| Shortcut Keys to Entering Data in Cells
|
|---|
| Press Keys | To Do
|
|---|
| Enter | Complete a cell entry and select the cell below.
|
| Alt+Enter | Start a new line in the same cell.
|
| Ctrl+Enter | Fill the selected cell range with the current entry.
|
| Shift+Enter | Complete a cell entry and select the previous cell above.
|
| Tab | Complete a cell entry and select the next cell to the right.
|
| Shift+Tab | Complete a cell entry and select the previous cell to the left.
|
| ESC | Cancel a cell entry.
|
| Arrow keys | Move one character up, down, left, or right.
|
| Home | Move to the beginning of the line.
|
| F4 or Ctrl+Y | Repeat the last action.
|
| Ctrl+Shift+F3 | Create names (A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) from row and column labels.
|
| Ctrl+D | Fill down.
|
| Ctrl+R | Fill to the right.
|
| Ctrl+F3 | Define a name.
|
| Ctrl+K | Insert a hyperlink.
|
| Ctrl+Shift+: (colon) | Enter the time.
|
| Alt+Down Arrow | Display a drop-down list of the values in the current column of a range.
|
| Ctrl+Z | Undo the last action. |
| Shortcut Keys to Enter and Calculate Formulas
|
|---|
| Press Keys | To Do
|
|---|
| = (equal sign) | Start a formula.
|
| F2 | Move the insertion point into the Formula Bar when editing in a cell is turned off.
|
| Backspace | In the Formula Bar, Delete one character to the left.
|
| ESC | Cancel an entry in the cell or Formula Bar.
|
| Shift+F3 | In a formula, display the Insert Function dialog box.
|
| Ctrl+A | When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
|
| Alt+= (equal sign) | Insert an AutoSum formula with the SUM function.
|
| Ctrl+Shift+" (quotation mark) | Copy the value from the cell above the active cell into the cell or the Formula Bar.
|
| Ctrl+' (apostrophe) | Copies a formula from the cell above the active cell into the cell or the Formula Bar.
|
| Ctrl+` (single left quotation mark) | Alternate between displaying cell values and displaying formulas.
|
| F9 | Calculate all worksheets in all open workbooks. |
| Shortcut Keys to Edit Data
|
|---|
| Press Keys | To Do
|
|---|
| F2 | Edit the active cell and position the insertion point at the end of the cell contents.
|
| Alt+Enter | Start a new line in the same cell.
|
| Backspace | Edit the active cell and then clear it, or Delete the preceding character in the active cell as you edit cell contents.
|
| Delete | Delete the character to the right of the insertion point, or Delete the selection.
|
| Ctrl+Delete | Delete text to the end of the line.
|
| F7 | Display the Spelling dialog box.
|
| Shift+F2 | Edit a cell comment
|
| Enter | Complete a cell entry and select the next cell below.
|
| Ctrl+Z | Undo the last action.
|
| ESC | Cancel a cell entry.
|
| Ctrl+Shift+Z | When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction. |
| Shortcut Keys to Format Data
|
|---|
| Press Keys | To Do
|
|---|
| Alt+' (apostrophe) | Display the Style dialog box.
|
| Ctrl+1 | Display the Format Cells dialog box.
|
| Ctrl+Shift+~ | Apply the General number format.
|
| Ctrl+Shift+$ | Apply the Currency format with two decimal places (negative numbers in parentheses).
|
| Ctrl+Shift+% | Apply the Percentage format with no decimal places.
|
| Ctrl+Shift+^ | Apply the Exponential number format with two decimal places.
|
| Ctrl+Shift+# | Apply the Date format with the day, month, and year.
|
| Ctrl+Shift+@ | Apply the Time format with the hour and minute, and AM or PM.
|
| Ctrl+Shift+! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
|
| Ctrl+B | Apply or remove bold formatting.
|
| Ctrl+I | Apply or remove italic formatting.
|
| Ctrl+U | Apply or remove underlining.
|
| Ctrl+5 | Apply or remove strikethrough.
|
| Ctrl+9 | Hide the selected rows.
|
| Ctrl+Shift+( (opening parenthesis) | Unhide any hidden rows within the selection.
|
| Ctrl+0 (zero) | Hide the selected columns.
|
| Ctrl+Shift+) (closing parenthesis) | Unhide any hidden columns within the selection.
|
| Ctrl+Shift+& | Apply the outline border to the selected cells.
|
| Ctrl+Shift+_ | Remove the outline border from the selected cells. |
