| ENTER |
Complete a cell entry |
| ESC |
Cancel a cell entry |
| F4 or CTRL+Y |
Repeat the last action |
| ALT+ENTER |
Start a new line in the same cell |
| BACKSPACE |
Delete the character to the left of the insertion point, or delete the selection |
| 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 |
| Arrow keys |
Move one character up, down, left, or right |
| HOME |
Move to the beginning of the line |
| Shift+F2 |
Edit a cell comment |
| CTRL+Shift+F3 |
Create names from row and column labels |
| CTRL+D |
Fill down |
| CTRL+R |
Fill to the right |
| CTRL+ENTER |
Fill the selected cell range with the current entry |
| ENTER |
Complete a cell entry and move down in the selection |
| Shift+ENTER |
Complete a cell entry and move up in the selection |
| TAB |
Complete a cell entry and move to the right in the selection |
| Shift+TAB |
Complete a cell entry and move to the left in the selection |
| = (EQUAL SIGN) |
Start a formula |
| ESC |
Cancel an entry in the cell or formula bar |
| F2 |
Edit the active cell |
| BACKSPACE |
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents |
| F3 |
Paste a name into a formula |
| CTRL+F3 |
Define a name |
| F9 |
Calculate all sheets in all open workbooks |
| Shift+F9 |
Calculate the active worksheet |
| ALT+= (EQUAL SIGN) |
Insert the AutoSum formula |
| CTRL+; (SEMICOLON) |
Enter the date |
| CTRL+Shift+: (COLON) |
Enter the time |
| CTRL+K |
Insert a hyperlink |
| ENTER |
Complete a cell entry |
| CTRL+Shift+ (QUOTATION MARK) |
Copy the value 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 cell formulas |
| CTRL+' (APOSTROPHE) |
Copy a formula from the cell above the active cell into the cell or the formula bar |
| CTRL+Shift+ENTER |
Enter a formula as an array formula |
| CTRL+A |
Display the Formula Palette after you type a valid function name in a formula |
| CTRL+Shift+A |
Insert the argument names and parentheses for a function, after you type a valid function name in a formula |
| ALT+DOWN ARROW |
Display the AutoComplete list |
| ALT+' (APOSTROPHE) |
Display the Style command (Format menu) |
| CTRL+1 |
Display the Cells command (Format menu) |
| CTRL+Shift+~ |
Apply the General number format |
| CTRL+Shift+$ |
Apply the Currency format with two decimal places (negative numbers appear 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 indicate A.M. or P.M. |
| CTRL+Shift+! |
Apply the Number format with two decimal places, 1000 separator, and - for negative values |
| CTRL+Shift+& |
Apply the outline border |
| CTRL+Shift+ |
Remove all borders |
| CTRL+B |
Apply or remove bold formatting |
| CTRL+I |
Apply or remove italic formatting |
| CTRL+U |
Apply or remove an underline |
| CTRL+5 |
Apply or remove strikethrough formatting |
| CTRL+9 |
Hide rows |
| CTRL+Shift+( |
Unhide rows |
| CTRL+0 (ZERO) |
Hide columns |
| CTRL+Shift+) |
Unhide columns |
| F2 |
Edit the active cell |
| ESC |
Cancel an entry in the cell or formula bar |
| BACKSPACE |
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents |
| F3 |
Paste a name into a formula |
| ENTER |
Complete a cell entry |
| CTRL+Shift+ENTER |
Enter a formula as an array formula |
| CTRL+A |
Display the Formula Palette after you type a valid function name in a formula |
| CTRL+Shift+A |
Insert the argument names and parentheses for a function, after you type a valid function name in a formula |
| CTRL+C |
Copy the selection |
| CTRL+V |
Paste the selection |
| CTRL+X |
Cut the selection |
| DELETE |
Clear the contents of the selection |
| CTRL+Shift+PLUS SIGN |
Insert blank cells |
| CTRL+ - |
Delete the selection |
| CTRL+Z |
Undo the last action |
| ENTER |
Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command) |
| Shift+ENTER |
Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command) |
| TAB |
Move from left to right within the selection, or move down one cell if only one column is selected |
| Shift+TAB |
Move from right to left within the selection, or move up one cell if only one column is selected |
| CTRL+PERIOD |
Move clockwise to the next corner of the selection |
| CTRL+ALT+RIGHT ARROW |
Move to the right between nonadjacent selections |
| CTRL+ALT+LEFT ARROW |
Move to the left between nonadjacent selections |
| CTRL+Shift+* (ASTERISK) |
Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) |
| 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 cell used on the worksheet (lower-right corner) |
| CTRL+SPACEBAR |
Select the entire column |
| Shift+SPACEBAR |
Select the entire row |
| CTRL+A |
Select the entire worksheet |
| Shift+BACKSPACE |
If multiple cells are selected, select only the active cell |
| Shift+PAGE DOWN |
Extend the selection down one screen |
| Shift+PAGE UP |
Extend the selection up one screen |
| CTRL+Shift+SPACEBAR |
With an object selected, select all objects on a sheet |
| CTRL+6 |
Alternate between hiding objects, displaying objects, and displaying placeholders for objects |
| CTRL+7 |
Show or hide the Standard toolbar |
| END |
Turn End mode on or off |
| 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 cell used on the worksheet (lower-right corner) |
| END, Shift+ENTER |
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) |
| SCROLL LOCK |
Turn SCROLL LOCK on or off |
| UP ARROW or DOWN ARROW |
Scroll the screen up or down one row |
| LEFT ARROW or RIGHT ARROW |
Scroll the screen left or right one column |
| Shift+HOME |
Extend the selection to the cell in the upper-left corner of the window |
| Shift+END |
Extend the selection to the cell in the lower-right corner of the window |
| CTRL+Shift+* (ASTERISK) |
Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) |
| CTRL+/ |
Select the current array, which is the array that the active cell belongs to |
| CTRL+Shift+O (the letter O) |
Select all cells with comments |
| CTRL+\ |
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+Shift+| |
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+[ |
Select only cells that are directly referred to by formulas in the selection |
| CTRL+Shift+{ |
Select all cells that are directly or indirectly referred to by formulas in the selection |
| CTRL+] |
Select only cells with formulas that refer directly to the active cell |
| CTRL+Shift+} |
Select all cells with formulas that refer directly or indirectly to the active cell |
| ALT+SEMICOLON |
Select only visible cells in the current selection |
| DOWN ARROW |
Select the previous group of items |
| UP ARROW |
Select the next group of items |
| RIGHT ARROW |
Select the next item within the group |
| LEFT ARROW |
Select the previous item within the group |
| Arrow key |
Move one cell in a given direction |
| CTRL+ arrow key |
Move to the edge of the current data region |
| TAB |
Move between unlocked cells on a protected worksheet |
| 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, 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 |
| 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 |
| CTRL+PAGE DOWN |
Move to the next sheet in the workbook |
| CTRL+PAGE UP |
Move to the previous sheet in the workbook |
| CTRL+F6 or CTRL+TAB |
Move to the next workbook or window |
| CTRL+Shift+F6 or CTRL+Shift+TAB |
Move to the previous workbook or window |
| F6 |
Move to the next pane |
| Shift+F6 |
Move to the previous pane |
| CTRL+BACKSPACE |
Scroll to display the active cell |
| END |
Turn End mode on or off |
| END, arrow key |
Move by one block of data within a row or column |
| END, HOME |
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 |
| END, ENTER |
Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) |
| SCROLL LOCK |
Turn SCROLL LOCK on or off |
| HOME |
Move to the cell in the upper-left corner of the window |
| END |
Move to the cell in the lower-right corner of the window |
| UP ARROW or DOWN ARROW |
Scroll one row up or down |
| LEFT ARROW or RIGHT ARROW |
Scroll one column left or right |
| 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 |
| ALT+ key, where key is the underlined letter in the field or cmnd name |
Select a field or a command button |
| DOWN ARROW |
Move to the same field in the next record |
| UP ARROW |
Move to the same field in the previous record |
| TAB |
Move to the next field you can edit in the record |
| Shift+TAB |
Move to the previous field you can edit in the record |
| ENTER |
Move to the first field in the next record |
| Shift+ENTER |
Move to the first field in the previous record |
| PAGE DOWN |
Move to the same field 10 records forward |
| PAGE UP |
Move to the same field 10 records back |
| CTRL+PAGE DOWN |
Move to the new record |
| CTRL+PAGE UP |
Move to the first record |
| HOME or END |
Move to the beginning or end of a field |
| LEFT ARROW or RIGHT ARROW |
Move one character left or right within a field |
| Shift+HOME |
Extend a selection to the beginning of a field |
| Shift+END |
Extend a selection to the end of a field |
| Shift+LEFT ARROW |
Select the character to the left |
| Shift+RIGHT ARROW |
Select the character to the right |
| Select the cell that contains the column label, and then press ALT+DOWN ARROW |
Display the AutoFilter list for the current column |
| ALT+UP ARROW |
Close the AutoFilter list for the current column |
| DOWN ARROW |
Select the next item in the AutoFilter list |
| UP ARROW |
Select the previous item in the AutoFilter list |
| HOME |
Select the first item (All) in the AutoFilter list |
| END |
Select the last item in the AutoFilter list |
| ENTER |
Filter the list by using the selected item in the AutoFilter list |
| UP ARROW or DOWN ARROW |
Select the next or previous field button in the list |
| LEFT ARROW or RIGHT ARROW |
Select the field button to the right or left in a multicolumn field button list |
| ALT+P |
Move the selected field into the Page area |
| ALT+R |
Move the selected field into the Row are |
| ALT+C |
Move the selected field into the Column area |
| ALT+D |
Move the selected field into the Data area |
| ALT+L |
Display the PivotTable Field dialog box |
| UP ARROW |
Select the previous item in the list |
| DOWN ARROW |
Select the next item in the list |
| HOME |
Select the first visible item in the list |
| END |
Select the last visible item in the list |
| ENTER |
Display the selected item |
| ALT+Shift+RIGHT ARROW |
Group selected PivotTable items |
| ALT+Shift+LEFT ARROW |
Ungroup selected PivotTable items |
| ALT+Shift+LEFT ARROW |
Ungroup rows or columns |
| ALT+Shift+RIGHT ARROW |
Group rows or columns |
| CTRL+8 |
Display or hide outline symbols |
| CTRL+9 |
Hide selected rows |
| CTRL+Shift+( |
Unhide selected rows |
| CTRL+0 (ZERO) |
Hide selected columns |
| CTRL+Shift+) |
Unhide selected columns |
| Shift+F10 |
Show a shortcut menu |
| F10 or ALT |
Make the menu bar active |
| ALT+SPACEBAR |
Show the program icon menu (on the program title bar) |
| DOWN ARROW or UP ARROW (with the menu or submenu displayed) |
Select the next or previous command on the menu or submenu |
| LEFT ARROW or RIGHT ARROW |
Select the menu to the left or right, or, with a submenu visible, switch between the main menu and the submenu |
| HOME or END |
Select the first or last command on the menu or submenu |
| ALT |
Close the visible menu and submenu at the same time |
| ESC |
Close the visible menu, or, with a submenu visible, close the submenu only |
| F10 or ALT |
Make the menu bar active |
| CTRL+TAB or CTRL+Shift+TAB |
Select the next or previous toolbar |
| TAB or Shift+TAB (when a toolbar is active) |
Select the next or previous button or menu on the toolbar |
| ENTER |
Open the selected menu |
| ENTER |
Perform the action assigned to the selected button |
| ENTER |
Enter text in the selected text box |
| Arrow keys to move through options in the list or menu; ENTER to select the option you want (when a drop-down list box is selected) |
Select an option from a drop-down list box or from a drop-down menu on a button |
| ALT+TAB |
Switch to the next program |
| ALT+Shift+TAB |
Switch to the previous program |
| CTRL+ESC |
Show the Windows Start menu |
| CTRL+W |
Close the active workbook window |
| CTRL+F5 |
Restore the active workbook window |
| CTRL+F6 |
Switch to the next workbook window |
| CTRL+Shift+F6 |
Switch to the previous workbook window |
| CTRL+F7 |
Carry out the Move command (workbook icon menu, menu bar) |
| CTRL+F8 |
Carry out the Size command (workbook icon menu, menu bar) |
| CTRL+F9 |
Minimize the workbook window to an icon |
| CTRL+F10 |
Maximize or restore the workbook window |
| ALT+0 to select the folder list; arrow keys to select a folder |
Select a folder in the Open or Save As dialog box (File menu) |
| ALT+ number (1 is the leftmost button, 2 is the next, and so on) |
Choose a toolbar button in the Open or Save As dialog box (File menu) |
| F5 |
Update the files visible in the Open or Save As dialog box (File menu) |
| 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 |
| TAB |
Move to the next option or option group |
| Shift+TAB |
Move to the previous option or option group |
| Arrow keys |
Move between options in the active drop-down list box or between some options in a group of options |
| SPACEBAR |
Perform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box |
| Letter key for the first letter in the option name you want (when a drop-down list box is selected) |
Move to an option in a drop-down list box |
| ALT+ letter, where letter is the key for the underlined letter in the option name |
Select an option, or select or clear a check box |
| ALT+DOWN ARROW |
Open the selected drop-down list box |
| ESC |
Close the selected drop-down list box |
| ENTER |
Perform the action assigned to the default command button in the dialog box (the button with the bold outline � often the OK button) |
| ESC |
Cancel the command and close the dialog box |
| 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 or CTRL+RIGHT ARROW |
Move one word to the left or 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 |
| Shift+LEFT ARROW |
Select or unselect one character to the left |
| Shift+RIGHT ARROW |
Select or unselect one character to the right |
| CTRL+Shift+LEFT ARROW |
Select or unselect one word to the left |
| CTRL+Shift+RIGHT ARROW |
Select or unselect one word to the right |
| ALT+F6; repeat until the balloon is active |
Make the Office Assistant the active balloon |
| ALT+topic number (where 1 is the first topic, 2 is the second, and so on) |
Select a Help topic from the topics displayed by the Office Assistant |
| ALT+DOWN ARROW |
See more help topics |
| ALT+UP ARROW |
See previous help topics |
| ESC |
Close an Office Assistant message |
| F1 |
Get Help from the Office Assistant |
| ALT+N |
Display the next tip |
| ALT+B |
Display the previous tip |
| ESC |
Close tips |
| TAB to select the Office Assistant button; SPACEBAR to show or hide the Assistant |
Show or hide the Office Assistant in a wizard |