| Enter data | |
| 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 |
| SHFT+F2 | Edit a cell comment |
| CTRL+SHFT+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 |
| SHFT+ENTER | Complete a cell entry and move up in the selection |
| TAB | Complete a cell entry and move to the right in the selection |
| SHFT+TAB | Complete a cell entry and move to the left in the selection |
| Work in cells or the formula bar | |
| = (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 |
| SHFT+F9 | Calculate the active worksheet |
| ALT+= (EQUAL SIGN) | Insert the AutoSum formula |
| CTRL+; (SEMICOLON) | Enter the date |
| CTRL+SHFT+: (COLON) | Enter the time |
| CTRL+K | Insert a hyperlink |
| ENTER | Complete a cell entry |
| CTRL+SHFT+ (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+SHFT+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+SHFT+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 |
| Format data | |
| ALT+' (APOSTROPHE) | Display the Style command (Format menu) |
| CTRL+1 | Display the Cells command (Format menu) |
| CTRL+SHFT+~ | Apply the General number format |
| CTRL+SHFT+$ | Apply the Currency format with two decimal places (negative numbers appear in parentheses) |
| CTRL+SHFT+% | Apply the Percentage format with no decimal places |
| CTRL+SHFT+^ | Apply the Exponential number format with two decimal places |
| CTRL+SHFT+# | Apply the Date format with the day, month, and year |
| CTRL+SHFT+@ | Apply the Time format with the hour and minute, and indicate A.M. or P.M. |
| CTRL+SHFT+! | Apply the Number format with two decimal places, 1000 separator, and - for negative values |
| CTRL+SHFT+& | Apply the outline border |
| CTRL+SHFT+ | 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+SHFT+( | Unhide rows |
| CTRL+0 (ZERO) | Hide columns |
| CTRL+SHFT+) | Unhide columns |
| Edit data | |
| 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+SHFT+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+SHFT+A | Insert the argument names and parentheses for a function, after you type a valid function name in a formula |
| Insert, delete, and copy a selection | |
| CTRL+C | Copy the selection |
| CTRL+V | Paste the selection |
| CTRL+X | Cut the selection |
| DELETE | Clear the contents of the selection |
| CTRL+SHFT+PLUS SIGN | Insert blank cells |
| CTRL+ - | Delete the selection |
| CTRL+Z | Undo the last action |
| Move within a selection | |
| 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) |
| SHFT+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 |
| SHFT+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 |
| Select cells, columns, rows, or objects in worksheets and workbooks | |
| CTRL+SHFT+* (ASTERISK) | Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) |
| SHFT+ arrow key | Extend the selection by one cell |
| CTRL+SHFT+ arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell |
| SHFT+HOME | Extend the selection to the beginning of the row |
| CTRL+SHFT+HOME | Extend the selection to the beginning of the worksheet |
| CTRL+SHFT+END | Extend the selection to the last cell used on the worksheet (lower-right corner) |
| CTRL+SPACEBAR | Select the entire column |
| SHFT+SPACEBAR | Select the entire row |
| CTRL+A | Select the entire worksheet |
| SHFT+BACKSPACE | If multiple cells are selected, select only the active cell |
| SHFT+PAGE DOWN | Extend the selection down one screen |
| SHFT+PAGE UP | Extend the selection up one screen |
| CTRL+SHFT+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 |
| In End mode | |
| END | Turn End mode on or off |
| END, SHFT+ arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell |
| END, SHFT+HOME | Extend the selection to the last cell used on the worksheet (lower-right corner) |
| END, SHFT+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) |
| With SCROLL LOCK on | |
| 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 |
| SHFT+HOME | Extend the selection to the cell in the upper-left corner of the window |
| SHFT+END | Extend the selection to the cell in the lower-right corner of the window |
| Select cells with special characteristics | |
| CTRL+SHFT+* (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+SHFT+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+SHFT+| | 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+SHFT+{ | 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+SHFT+} | Select all cells with formulas that refer directly or indirectly to the active cell |
| ALT+SEMICOLON | Select only visible cells in the current selection |
| Select chart items | |
| 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 |
| Move and scroll on a worksheet or workbook | |
| 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+SHFT+F6 or CTRL+SHFT+TAB | Move to the previous workbook or window |
| F6 | Move to the next pane |
| SHFT+F6 | Move to the previous pane |
| CTRL+BACKSPACE | Scroll to display the active cell |
| In End mode | |
| 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) |
| With SCROLL LOCK turned on | |
| 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 |
| Work in print preview | |
| 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 |
| Work in a data form | |
| 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 |
| SHFT+TAB | Move to the previous field you can edit in the record |
| ENTER | Move to the first field in the next record |
| SHFT+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 |
| SHFT+HOME | Extend a selection to the beginning of a field |
| SHFT+END | Extend a selection to the end of a field |
| SHFT+LEFT ARROW | Select the character to the left |
| SHFT+RIGHT ARROW | Select the character to the right |
| Work with the AutoFilter feature | |
| 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 |
| Work with the PivotTable Wizard (In Step 3 of the PivotTable Wizard) | |
| 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 |
| Work with page fields in a PivotTable | |
| 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 |
| Group and ungroup PivotTable items | |
| ALT+SHFT+RIGHT ARROW | Group selected PivotTable items |
| ALT+SHFT+LEFT ARROW | Ungroup selected PivotTable items |
| Outline data | |
| ALT+SHFT+LEFT ARROW | Ungroup rows or columns |
| ALT+SHFT+RIGHT ARROW | Group rows or columns |
| CTRL+8 | Display or hide outline symbols |
| CTRL+9 | Hide selected rows |
| CTRL+SHFT+( | Unhide selected rows |
| CTRL+0 (ZERO) | Hide selected columns |
| CTRL+SHFT+) | Unhide selected columns |
| Keys for menus | |
| SHFT+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 |
| On a toolbar | |
| F10 or ALT | Make the menu bar active |
| CTRL+TAB or CTRL+SHFT+TAB | Select the next or previous toolbar |
| TAB or SHFT+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 optns in the list or menu; ENTER to select the optn 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 |
| In a window | |
| ALT+TAB | Switch to the next program |
| ALT+SHFT+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+SHFT+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) |
| In a dialog box | |
| CTRL+TAB or CTRL+PAGE DOWN | Switch to the next tab in a dialog box |
| CTRL+SHFT+TAB or CTRL+PAGE UP | Switch to the previous tab in a dialog box |
| TAB | Move to the next option or option group |
| SHFT+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 optn 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 optn 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 |
| In a text 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 |
| SHFT+HOME | Select from the insertion point to the beginning of the entry |
| SHFT+END | Select from the insertion point to the end of the entry |
| SHFT+LEFT ARROW | Select or unselect one character to the left |
| SHFT+RIGHT ARROW | Select or unselect one character to the right |
| CTRL+SHFT+LEFT ARROW | Select or unselect one word to the left |
| CTRL+SHFT+RIGHT ARROW | Select or unselect one word to the right |
| Keys for using the Office Assistant | |
| 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 |
comments powered by Disqus
Keyboard Shortcut Database
