This section lists applicable keyboard shortcuts that are available while performing various types of tasks in Office Excel 2007.
Press | To |
---|---|
F11 | Create a chart of the data in the current range on a new worksheet. |
Alt+F1 | Create an embedded chart of the data in the current range on the current worksheet. |
Down Arrow | Select the previous group of elements in a chart. |
Up Arrow | Select the next group of elements in a chart. |
Right Arrow | Select the next element within a group. |
Left Arrow | Select the previous element within a group. |
Press | To |
---|---|
Home | Move to the beginning of the entry. |
End | Move to the end of the entry. |
Left Arrow or Right Arrow | Move one character to the left or right. |
Ctrl+Left Arrow | Move one word to the left. |
Ctrl+Right Arrow | Move one word to the right. |
Shift+Left Arrow | Select or deselect one character to the left. |
Shift+Right Arrow | Select or deselect one character to the right. |
Ctrl+Shift+Left Arrow | Select or deselect one word to the left. |
Ctrl+Shift+Right Arrow | Select or deselect one word to the right. |
Shift+Home | Select from the insertion point to the beginning of the entry. |
Shift+End | Select from the insertion point to the end of the entry. |
Press | To |
---|---|
Tab | Move to the next option or option group. |
Shift+Tab | Move to the previous option or option group. |
Ctrl+Tab or Ctrl+Page Down | Switch to the next tab in a dialog box. |
Ctrl+Shift+Tab or Ctrl+Page Up | Switch to the previous tab in a dialog box. |
Arrow keys | Move between options in an open list or between options in a group of options. |
Spacebar | Perform the action for the selected button, or select or clear the selected check box. |
First letter of an option | Open the list if it is closed and in a list, move to that option in the list. |
Alt+the underlined letter in an option | Select an option, or select or clear a check box. |
Alt+Down Arrow | Open the selected drop-down list. |
Enter | Perform the action for the default button in the dialog box (the button with the bold outline, often the OK button). |
Esc | Cancel the command, and close the dialog box. |
Press | To |
---|---|
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 | Start the spelling checker. |
Shift+F2 | Edit a cell comment. |
Enter | Complete a cell entry, and select the next cell below. |
Ctrl+X | Cut the selected cells. |
Ctrl+Z | Undo the last action. |
Esc | Cancel a cell entry. |
Ctrl+Shift+Z | When the AutoCorrect smart tag is displayed, undo or redo the last automatic correction. |
Press | To |
---|---|
= (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. |
Enter | Complete a cell entry from the cell or formula bar. |
Ctrl+Shift+Enter | Enter a formula as an array formula. |
Esc | Cancel an entry in the cell or formula bar. |
Shift+F3 | 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. |
Ctrl+Shift+A | When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. |
F3 | Display the Paste Name dialog box. |
Alt+= (equal sign) | Insert an AutoSum formula. |
Ctrl+Shift+" (quotation mark) | Copy the value from the cell above the active cell into the cell or the formula bar. |
Ctrl+' (apostrophe) | Copy 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, or when a portion of a formula is selected, calculate the selected portion. |
Shift+F9 | Calculate the active worksheet. |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Alt+Shift+F9 | Recheck dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. |
Press | To |
---|---|
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 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+; (semicolon) | Enter the date. |
Ctrl+Shift+: (colon) | Enter the time. |
Alt+Down Arrow | Display a drop-down list of the values in the current column of a list if your insertion point is in the cell containing the column name. |
Ctrl+Z | Undo the last action. |
Press | To |
---|---|
F8 | Turn on or off extend mode. In extend mode, EXT appears on the status bar, 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 nonblank 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+PageUp | Extend the selection up one screen. |
End, Shift+arrow key | Extend the selection to the last nonblank 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). |
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 (Microsoft Office Button, Excel Options, Advanced category, Lotus Compatibility section). |
Scroll Lock+Shift+Home | Extend the selection to the cell in the upper-left corner of the window. |
Scroll Lock+Shift+End | Extend the selection to the cell in the lower-right corner of the window. |
Press | To |
---|---|
Alt+Down Arrow | In the cell that contains the arrow, display the Filter list for the current column. |
Down Arrow | Select the next item in the Filter list. |
Up Arrow | Select the previous item in the Filter list. |
Home | Select the first item (Sort Ascending) in the Filter list. |
End | Select the last item in the Filter list. |
Enter | Filter the list based on the item selected from the Filter list. |
Press | To |
---|---|
Alt+T | Apply or remove the top border. |
Alt+B | Apply or remove the bottom border. |
Alt+L | Apply or remove the left border. |
Alt+R | Apply or remove the right border. |
Alt+H | If cells in multiple rows are selected, apply or remove the horizontal divider. |
Alt+V | If cells in multiple columns are selected, apply or remove the vertical divider. |
Alt+D | Apply or remove the downward diagonal border. |
Alt+U | Apply or remove the upward diagonal border. |
Press | To |
---|---|
Alt+' (apostrophe) | Display the Style dialog box. |
Ctrl+1 | Display the Format Cells dialog box. (Note that you must use the 1 key on the keyboard, not on the keypad. ) |
Ctrl+Shift+~ (tilde) | 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+^ (caret) | Apply the Exponential number format with two decimal places. |
Ctrl+Shift+# (pound) | 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+! (exclamation point) | 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+& (ampersand) | Apply the outline border to the selected cells. |
Ctrl+Shift+_ (underscore) | Remove the outline border from the selected cells. |
Press | To |
---|---|
F1 | Display the Microsoft Excel Help window. |
Press | To |
---|---|
Tab or Shift+Tab | Select the next or previous hidden text or hyperlink. |
Enter | Perform the action for the selected hidden text or hyperlink. |
Alt+F4 | Close the Help window. |
Alt+Left Arrow | Go to the previous Help topic. |
Alt+Right Arrow | Go to the next Help topic. |
Up Arrow or Down Arrow | Scroll toward the beginning or end of a Help topic. |
Page Up or Page Down | Scroll toward the beginning or end of a Help topic in large increments. |
Home or End | Go to the beginning or end of a Help topic. |
Ctrl+P | Print the current Help topic. |
Ctrl+A | Select the entire Help topic. |
Ctrl+C | Copy the selected items to the Clipboard. |
Press | To |
---|---|
Ctrl+C | Copy the selected items to the Clipboard. |
Ctrl+X | Cut the selected cells. |
Ctrl+V | Paste copied cells. |
Delete | Clear the contents of the selected cells. |
Ctrl+- (hyphen) | Delete the selected row. |
Ctrl+Shift++(plus sign) | Insert a new row. |
Press | To |
---|---|
Alt+F8 | Display the Macro dialog box. |
Alt+F11 | Display the Visual Basic Editor. |
Ctrl+F11 | Insert a Microsoft Excel 4 macro worksheet. |
Press | To |
---|---|
F10 or Alt | Display shortcut key pop-ups. |
Alt, Tab or Alt, Shift+Tab | Select the next or previous item on the Ribbon. |
Enter | Open the selected menu or perform the action for the selected button or command. |
Shift+F10 | Display the shortcut menu for the selected item. |
Alt+Spacebar | Display the Control menu for the Excel window. |
Down Arrow or Up Arrow | When a menu or submenu is open, select the next or previous command. |
Left Arrow or Right Arrow | Select the menu to the left or right. When a submenu is open, switch between the main menu and the submenu. When the Ribbon is active, select the next or previous tab. |
Home or End | Select the first or last command on the menu or submenu. |
Esc | Close an open menu. When a submenu is open, close only the submenu. |
Press | To |
---|---|
End key | Turn on or off End mode. (End Mode appears on the status bar.) |
End+arrow key | Move by one block of data within a row or column. |
End+Home | Move to the last cell on the worksheet in the lowest used row of the rightmost used column. |
End+Enter | Move to the rightmost nonblank cell in the current row. |
Press | To |
---|---|
Arrow keys | Move one cell up, down, left, or right. |
Ctrl+arrow key | Move to the edge of the current data region. |
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 lowest used row of the rightmost used column. |
Page Down | Move down one screen. |
Ctrl+Page Down | Select the next worksheet in the workbook. |
Ctrl+Page Up | Select the previous worksheet in the workbook. |
Page Up | Move up one screen. |
Alt+Page Down | Move one screen to the right. |
Alt+Page Up | Move one screen to the left. |
Ctrl+Backspace | Scroll to display the active cell. |
F5 | Display the Go To dialog box. |
Shift+F5 | Display the Find And Replace dialog box. |
Shift+F4 | Repeat the last Find action (same as Find Next). |
Tab | Move between unlocked cells on a protected worksheet. |
Press | To |
---|---|
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. |
Press | To |
---|---|
Ctrl+P or Ctrl+Shift+F12 | Display the Print dialog box. |
Alt+F, then press W, then V | Open Print Preview. |
Press | To |
---|---|
Arrow keys | Move around the page when zoomed in. |
Page Up or Page Down | Move by one page when zoomed out. |
Ctrl+Up Arrow or Ctrl+Left Arrow | Move to the first page when zoomed out. |
Ctrl+Down Arrow or Ctrl+Right Arrow | Move to the last page when zoomed out. |
Press | To |
---|---|
Ctrl+Spacebar | Select the entire column. |
Shift+Spacebar | Select the entire row. |
Ctrl+A | Select the entire worksheet. |
Shift+Backspace | With multiple cells selected, select only the active cell. |
Ctrl+Shift+Spacebar | With an object selected, select all the objects on a worksheet. |
Ctrl+6 | Toggle the display of objects. |
Press | To |
---|---|
Ctrl+Shift+* (asterisk) | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, select the entire PivotTable. |
Ctrl+/ (slash) | Select the array containing the active cell. |
Ctrl+Shift+O (the letter O) | Select all cells that contain comments. |
Ctrl+[ (opening bracket) | Select all cells directly referenced by formulas in the selection. |
Ctrl+Shift+{ (opening brace) | Select all cells directly or indirectly referenced by formulas in the selection. |
Ctrl+] (closing bracket) | Select cells that contain formulas that directly reference the active cell. |
Ctrl+Shift+} (closing brace) | Select cells that contain formulas that directly or indirectly reference the active cell. |
Press | To |
---|---|
Alt+Shift+Right Arrow | Group rows or columns. |
Alt+Shift+Left Arrow | Ungroup rows or columns. |
Ctrl+8 | Display or hide the outline symbols. |
Ctrl+9 | Hide the selected rows. |
Ctrl+Shift+( (opening parenthesis) | Unhide any hidden rows within the selection. |
Ctrl+0 (zero) | Hide the selected columns. |
Press | To |
---|---|
Alt+Shift+F10 | Display the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag, and display its menu or message. |
Down Arrow | Select the next item on a smart tag menu. |
Up Arrow | Select the previous item on a smart tag menu. |
Enter | Perform the action for the selected item on a smart tag menu. |
Esc | Close the smart tag menu or message. |
Press | To |
---|---|
F6 | Move to a task pane from another pane in the program window. (You may need to press F6 more than once.) |
Tab or Shift+Tab | When a task pane is active, select the next or previous item in the task pane. |
Down Arrow or Up Arrow | Move among choices on a selected submenu, or move among certain options in a group of options. |
Spacebar or Enter | Open the selected menu, or perform the action assigned to the selected button. |
Home or End | When a menu or submenu is visible, select the first or last command on the menu or submenu. |
Page Up or Page Down | Scroll up or down in the selected task pane. |
Ctrl+Home or Ctrl+End | Move to the top or bottom of the selected task pane. |
Press | To |
---|---|
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+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+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. |
Press | To |
---|---|
Shift+F11 or Alt+Shift+F1 | Insert a new worksheet. |
Ctrl+Page Down | Move to the next worksheet in the workbook. |
Ctrl+Page Up | Move to the previous worksheet in the workbook. |
Shift+Ctrl+Page Down | Select the current and next worksheet. To cancel selection of multiple worksheets, press Ctrl+Page Down; to select a different worksheet, press Ctrl+Page Up. |
Shift+Ctrl+Page Up | Select the current and previous worksheet. |
Alt+O, H, R | Rename the current worksheet. |
Alt+E, M | Move or copy the current worksheet. |
Alt+E, L | Delete the current worksheet. |