The following table lists each command, what it applies to, and the keystroke for the command.
| Command |
Applies to |
US |
| Select the previous group of items (on a chart) |
Chart |
DOWN ARROW |
| Move to the same field in the next record |
Data form |
DOWN ARROW |
| Select the next item in the AutoFilter list |
AutoFilter list |
DOWN ARROW |
| Select the previous field button in the list (in the PivotTable Wizard - Layout dialog box) |
PivotTable Wizard - Layout dialog box |
DOWN ARROW |
| Scroll the screen down one row |
Worksheet |
DOWN ARROW (with SCROLL LOCK on) |
| Turn end mode on or off |
Excel |
END |
| Move to the end of a field |
Data form |
END |
| Select the last item in the AutoFilter list |
AutoFilter list |
END |
| Move to the cell in the lower-right corner of the window |
Worksheet |
END (with SCROLL LOCK on) |
| Move by one block of data within a row or column |
Cell, Range |
END, ARROW KEY |
| Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 |
Cell, Range |
END, HOME |
| Move to the last cell to the right that is not blank in the current row |
Cell, Range |
END, RETURN |
| Extend the selection to the last nonblank cell in the same column or row as the active cell |
Cell |
END, SHIFT+ARROW KEY |
| Extend the selection to the last cell used on the worksheet (lower-right corner) |
Cell, Range |
END, SHIFT+HOME |
| Extend the selection to the last cell in the current row |
Cell, Range |
END, SHIFT+RETURN |
| Move to the end of the entry |
Text box |
END, SHIFT+RETURN |
| Cancel a cell entry |
Cell, Formula bar |
ESC |
| Cancel the command and close the dialog box |
Dialog boxes |
ESC |
| Close Office Assistant message |
Assistant balloon |
ESC |
| Close Assistant tips |
Tip balloons |
ESC |
| Undo |
Last action(s) |
F1 |
| Create a chart |
Worksheet |
F11 |
| Save As command |
Excel |
F12 |
| Turn SCROLL LOCK on or off |
Excel |
F14 |
| Cut text from the active cell |
Cell |
F2 |
| Copy text from the active cell |
Cell |
F3 |
| Paste a name into a formula |
Formula |
F4 |
| Paste text into the active cell |
Cell |
F4 |
| Go To |
Worksheet |
F5 |
| Move to the next pane |
Worksheet |
F6 |
| Spelling command |
Worksheet |
F7 |
| Extend a selection |
Cell, Range |
F8 |
| Get Help from the Office Assistant |
Excel |
HELP |
| Move to the beginning of the line |
Cells, Text boxes |
HOME |
| Move to the beginning of the row |
Rows |
HOME |
| Move to the beginning of the entry |
Text box |
HOME |
| Move to the beginning of a field |
Data form |
HOME |
| Select the first item (Sort Ascending) in the AutoFilter list |
AutoFilter list |
HOME |
| Move to the cell in the upper-left corner of the window |
Worksheet |
Home (with SCROLL LOCK on) |
| Select the previous item within the group (on a chart) |
Chart |
LEFT ARROW |
| Move one character to the left |
Text box |
LEFT ARROW |
| Move one character left within a field |
Data form |
LEFT ARROW |
| Select the field button to the left in a multicolumn field button list |
PivotTable Wizard - Layout dialog box |
LEFT ARROW |
| Scroll the screen left one column |
Worksheet |
LEFT ARROW (with SCROLL LOCK on) |
| Move to an option in a pop-up menu |
Dialog boxes |
Letter key for the first letter in the option name that you want (when a pop-up menu is selected) |
| Display the AutoComplete list |
Cell |
OPTION+DOWN ARROW |
| Display the AutoFilter list for the current column |
Cell |
OPTION+DOWN ARROW |
| Display Visual Basic Editor |
Excel |
OPTION+F11 |
| Display the Macro dialog box |
Excel |
OPTION+F8 |
| Move one screen to the right |
Worksheet |
OPTION+PAGE DOWN |
| Move one screen to the left |
Worksheet |
OPTION+PAGE UP |
| Move down one screen |
Worksheet |
PAGE DOWN |
| Move down by one page when zoomed out (in Print Preview) |
Print Preview |
PAGE DOWN |
| Move to the same field 10 records forward |
Data form |
PAGE DOWN |
| Move up one screen |
Worksheet |
PAGE UP |
| Move up by one page when zoomed out (in Print Preview) |
Print Preview |
PAGE UP |
| Move to the same field 10 records back |
Data form |
PAGE UP |
| Complete a cell entry |
Cell |
RETURN |
| Complete a cell entry and move down in the selection |
Cell |
RETURN |
| Perform the action assigned to the default command button in the dialog box (the button with the bold outline -- often the OK button) |
Dialog boxes |
RETURN |
| Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Preferences command on the Edit menu) |
Range |
RETURN |
| Move to the first field in the next record |
Data form |
RETURN |
| Filter the list by using the selected item in the AutoFilter list |
AutoFilter list |
RETURN |
| Select the next item within the group (on a chart) |
Chart |
RIGHT ARROW |
| Move one character to the right |
Text box |
RIGHT ARROW |
| Move one character right within a field |
Data form |
RIGHT ARROW |
| Select the field button to the right in a multicolumn field button list |
PivotTable Wizard - Layout dialog box |
RIGHT ARROW |
| Scroll the screen right one column |
Worksheet |
RIGHT ARROW (with SCROLL LOCK on) |
| Extend the selection by one cell |
Cell, Range |
SHIFT+ARROW KEY |
| If multiple cells are selected, select only the active cell |
Cells, Range |
SHIFT+DELETE |
| Extend the selection down by one cell |
Cell, Range |
SHIFT+DOWN ARROW |
| Select from the insertion point to the end of the entry |
Cells, Text boxes |
SHIFT+END |
| Extend a selection to the end of a field |
Data form |
SHIFT+END |
| Extend the selection to the cell in the lower-right corner of the window |
Cell, Range |
SHIFT+END (with SCROLL LOCK on) |
| What's This? |
Excel |
SHIFT+F1 |
| Show a shortcut menu |
All |
SHIFT+F10 |
| Insert a new worksheet |
Workbook |
SHIFT+F11 |
| Save command |
Excel |
SHIFT+F12 |
| Edit a cell comment |
Commented cells |
SHIFT+F2 |
| Paste a function into a formula |
Formula |
SHIFT+F3 |
| Repeat the last Find command (Find Next) |
Excel |
SHIFT+F4 |
| Display the Find dialog box |
Excel |
SHIFT+F5 |
| Move to the previous pane |
Worksheet |
SHIFT+F6 |
| Add to the selection |
Worksheet |
SHIFT+F8 |
| Calculate the active worksheet |
Worksheet |
SHIFT+F9 |
| Select from the insertion point to the beginning of the entry |
Cells, Text boxes |
SHIFT+HOME |
| Extend the selection to the beginning of the row |
Cell |
SHIFT+HOME |
| Select from the insertion |
Text box |
SHIFT+HOME |
| Extend a selection to the beginning of a field |
Data form |
SHIFT+HOME |
| Extend the selection to the cell in the upper-left corner of the window |
Cell, Range |
SHIFT+HOME (with SCROLL LOCK on) |
| Extend the selection to the left by one cell |
Cell, Range |
SHIFT+LEFT ARROW |
| Select or unselect one character to the left |
Cells, Text boxes |
SHIFT+LEFT ARROW |
| Select the character to the left |
Data form |
SHIFT+LEFT ARROW |
| Leave edit mode of the selected cell's phonetic guide window |
Cell |
SHIFT+OPTION+DOWN ARROW |
| Go into edit mode in the selected cell's phonetic guide window |
Cell |
SHIFT+OPTION+UP ARROW |
| Extend the selection down one screen |
Worksheet |
SHIFT+PAGE DOWN |
| Extend the selection up one screen |
Worksheet |
SHIFT+PAGE UP |
| Complete a cell entry and move up in the selection |
Cell |
SHIFT+RETURN |
| Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Preferences command on the Edit menu) |
Range |
SHIFT+RETURN |
| Move to the first field in the previous record |
Data form |
SHIFT+RETURN |
| Extend the selection to the right by one cell |
Cell, Range |
SHIFT+RIGHT ARROW |
| Select or unselect one character to the right |
Cells, Text boxes |
SHIFT+RIGHT ARROW |
| Select the character to the right |
Data form |
SHIFT+RIGHT ARROW |
| Select the entire row |
Cell, Cells |
SHIFT+SPACEBAR |
| Complete a cell entry and move to the left in the selection |
Cells |
SHIFT+TAB |
| Move to the previous text box in a dialog box |
Dialog boxes |
SHIFT+TAB |
| Move from right to left within the selection, or move up one cell if only one column is selected |
Range |
SHIFT+TAB |
| Move to the previous field that you can edit in the record |
Data form |
SHIFT+TAB |
| Extend the selection up by one cell |
Cell, Range |
SHIFT+UP ARROW |
| Complete a cell entry and move to the right in the selection |
Cells |
TAB |
| Move to the next text box |
Dialog boxes |
TAB |
| Move between unlocked cells on a protected worksheet |
Protected worksheet |
TAB |
| Move from left to right within the selection, or move down one cell if only one column is selected |
Range |
TAB |
| Move to the next field that you can edit in the record |
Data form |
TAB |
| Select the next group of items (on a chart) |
Chart |
UP ARROW |
| Move to the same field in the previous record |
Data form |
UP ARROW |
| Select the previous item in the AutoFilter list |
AutoFilter list |
UP ARROW |
| Select the next field button in the list (in the PivotTable Wizard - Layout dialog box) |
PivotTable Wizard - Layout dialog box |
UP ARROW |
| Scroll the screen up one row |
Worksheet |
UP ARROW (with SCROLL LOCK on) |