Keyboard Shortcuts by Task

This section lists applicable keyboard shortcuts that are available while performing various types of tasks in Office Excel 2007.

Charts and Select Chart Elements

Open table as spreadsheet

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.

Dialog Box Text Boxes

Open table as spreadsheet

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.

Dialog Boxes

Open table as spreadsheet

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.

Edit Data

Open table as spreadsheet

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.

Enter and Calculate Formulas

Open table as spreadsheet

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.

Enter Data

Open table as spreadsheet

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.

Extend a Selection

Open table as spreadsheet

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.

Filter Lists

Open table as spreadsheet

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.

Format Cells Dialog Box-Border Tab

Open table as spreadsheet

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.

Format Data

Open table as spreadsheet

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.

Help

Open table as spreadsheet

Press	To
F1	Display the Microsoft Excel Help window.

Help Window

Open table as spreadsheet

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.

Insert, Delete, and Copy Cells

Open table as spreadsheet

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.

Macros

Open table as spreadsheet

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.

Ribbon and Buttons

Open table as spreadsheet

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.

Move and Scroll-In End Mode

Open table as spreadsheet

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.

Move and Scroll-Worksheets

Open table as spreadsheet

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.

Move Within a Selected Range

Open table as spreadsheet

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.

Print

Open table as spreadsheet

Press	To
Ctrl+P or Ctrl+Shift+F12	Display the Print dialog box.
Alt+F, then press W, then V	Open Print Preview.

Print Preview

Open table as spreadsheet

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.

Select Cells, Rows, Columns, and Objects

Open table as spreadsheet

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.

Select Cells with Special Characteristics

Open table as spreadsheet

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.

Show, Hide, and Outline Data

Open table as spreadsheet

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.

Smart Tags

Open table as spreadsheet

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.

Task Panes

Open table as spreadsheet

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.

Windows and Office Interface

Open table as spreadsheet

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.

Worksheets

Open table as spreadsheet

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.