| SHORTCUT | ACTION |
| 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 |
Showing posts with label MS Excel. Show all posts
Showing posts with label MS Excel. Show all posts
Thursday, 16 January 2014
Microsoft Excel 97 Keyboard Shortcuts
Microsoft Excel 2007 Keyboard Shortcuts
| SHORTCUT | ACTION |
| CTRL combination shortcut keys | |
| CTRL+SHFT+( | Unhides any hidden rows within the selection. |
| CTRL+SHFT+) | Unhides any hidden columns within the selection. |
| CTRL+SHFT+& | Applies the outline border to the selected cells. |
| CTRL+SHFT_ | Removes the outline border from the selected cells. |
| CTRL SHFT ~ | Applies the General number format in Microsoft Excel. |
| CTRL+SHFT+$ | Applies the Currency format with two decimal places (negative numbers in parentheses). |
| CTRL+SHFT+% | Applies the Percentage format with no decimal places. |
| CTRL+SHFT+^ | Applies the Exponential number format with two decimal places. |
| CTRL+SHFT+# | Applies the Date format with the day, month, and year. |
| CTRL+SHFT+@ | Applies the Time format with the hour and minute, and AM or PM. |
| CTRL+SHFT+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| CTRL+SHFT+* | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. |
| CTRL+SHFT+: | Enters the current time. |
| CTRL+SHFT+ | Copies the value from the cell above the active cell into the cell or the Formula Bar. |
| CTRL SHFT Plus ( ) | Displays the Insert dialog box to insert blank cells in Microsoft Excel. |
| CTRL+Minus (-) | Displays the Delete dialog box to delete the selected cells. |
| CTRL+; | Enters the current date. |
| CTRL+` | Alternates between displaying cell values and displaying formulas in the worksheet. |
| CTRL+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
| CTRL+1 | Displays the Format Cells dialog box. |
| CTRL+2 | Applies or removes bold formatting. |
| CTRL+3 | Applies or removes italic formatting. |
| CTRL 4 | Applies or removes underlining in Microsoft Excel. |
| CTRL+5 | Applies or removes strikethrough. |
| CTRL+6 | Alternates between hiding objects, displaying objects, and displaying placeholders for objects. |
| CTRL+8 | Displays or hides the outline symbols. |
| CTRL+9 | Hides the selected rows. |
| CTRL 0 | Hides the selected columns in Microsoft Excel. |
| CTRL+A | Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. |
| CTRL+B | Applies or removes bold formatting. |
| CTRL+C | Copies the selected cells. CTRL+C followed by another CTRL+C displays the Clipboard. |
| CTRL+D | Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. |
| CTRL+F | Displays the Find and Replace dialog box, with the Find tab selected. SHFT+F5 also displays this tab, while SHFT+F4 repeats the last Find action. CTRL+SHFT+F opens the Format Cells dialog box with the Font tab selected. |
| CTRL+G | Displays the Go To dialog box. F5 also displays this dialog box. |
| CTRL+H | Displays the Find and Replace dialog box, with the Replace tab selected. |
| CTRL I | Applies or removes italic formatting in Microsoft Excel. |
| CTRL+K | Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. |
| CTRL+N | Creates a new, blank workbook. |
| CTRL O | Displays the Open dialog box to open or find a file. CTRL SHFT O selects all cells that contain comments in Microsoft Excel. |
| CTRL+P | Displays the Print dialog box. CTRL+SHFT+P opens the Format Cells dialog box with the Font tab selected. |
| CTRL+R | Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. |
| CTRL+S | Saves the active file with its current file name, location, and file format. |
| CTRL T | Displays the Create Table dialog box in Microsoft Excel. |
| CTRL+U | Applies or removes underlining. CTRL+SHFT+U switches between expanding and collapsing of the formula bar. |
| CTRL+V | Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. |
| CTRL+W | Closes the selected workbook window. |
| CTRL+X | Cuts the selected cells. |
| CTRL Y | Repeats the last command or action, if possible in Microsoft Excel. |
| CTRL+Z | Uses the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed. |
| Function keys | |
| F1 | Displays the Microsoft Office Excel Help task pane. CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface. ALT+F1 creates a chart of the data in the current range. ALT+SHFT+F1 inserts a new worksheet. |
| F2 | Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. SHFT+F2 adds or edits a cell comment. CTRL+F2 displays the Print Preview window. |
| F3 | Displays the Paste Name dialog box. SHFT+F3 displays the Insert Function dialog box. |
| F4 | Repeats the last command or action, if possible. CTRL+F4 closes the selected workbook window. |
| F5 | Displays the Go To dialog box. CTRL F5 restores the window size of the selected workbook window in Microsoft Excel. |
| F6 | Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. SHFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. CTRL+F6 switches to the next workbook window when more than one workbook window is open. |
| F7 | Displays the Spelling dialog box to check spelling in the active worksheet or selected range. CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel. |
| F8 | Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. SHFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys. CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro. |
| F9 | Calculates all worksheets in all open workbooks. SHFT F9 calculates the active worksheet in Microsoft Excel. CTRL ALT F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL ALT SHFT F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL F9 minimizes a workbook window to an icon. |
| F10 | Turns key tips on or off. SHFT F10 displays the shortcut menu for a selected item in Microsoft Excel. ALT SHFT F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. CTRL F10 maximizes or restores the selected workbook window. |
| F11 | Creates a chart of the data in the current range. SHFT+F11 inserts a new worksheet. ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA). |
| F12 | Displays the Save As dialog box. |
| Other useful shortcut keys | |
| ARROW KEYS | Move one cell up, down, left, or right in a worksheet. CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet. SHFT+ARROW KEY extends the selection of cells by one cell. CTRL+SHFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell |
| BACKSPACE | Deletes one character to the left in the Formula Bar in Microsoft Excel. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point. |
| DELETE | Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point. |
| END | Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible. CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text. CTRL+SHFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CT |
| ENTER | Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button). ALT+ENTER starts a new line in the same cell. CTRL+ENTER fills the selected cell range |
| ESC | Cancels an entry in the cell or Formula Bar in Microsoft Excel. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. |
| HOME | Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible. CTRL+HOME moves to the beginning of a worksheet. CTRL+SHFT+HOME extends the selection of cells to the beginning of the worksheet. |
| PAGE DOWN | Moves one screen down in a worksheet. ALT+PAGE DOWN moves one screen to the right in a worksheet. CTRL+PAGE DOWN moves to the next sheet in a workbook. CTRL+SHFT+PAGE DOWN selects the current and next sheet in a workbook. |
| PAGE UP | Moves one screen up in a worksheet. ALT+PAGE UP moves one screen to the left in a worksheet. CTRL+PAGE UP moves to the previous sheet in a workbook. CTRL+SHFT+PAGE UP selects the current and previous sheet in a workbook. |
| SPACEBAR | In a dialog box, performs the action for the selected button, or selects or clears a check box. CTRL+SPACEBAR selects an entire column in a worksheet. SHFT+SPACEBAR selects an entire row in a worksheet. CTRL+SHFT+SPACEBAR selects the entire worksheet. If the worksheet contains data, CTRL+SHFT+SPACEBAR selects the current region. Pressing CTRL+SHFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHFT+SPACEBAR a third time selects the entire worksheet. Wh |
| TAB | Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box. SHFT TAB moves to the previous cell in a worksheet or the previous option in a dialog box in Microsoft Excel. CTRL TAB switches to the next tab in dialog box. CTRL SHFT TAB switches to the previous tab in a dialog box. |
Microsoft Excel 2003 Keyboard Shortcuts
| SHORTCUT | ACTION |
| Display and use windows | |
| ALT+TAB | Switch to the next program. |
| ALT+SHFT+TAB | Switch to the previous program. |
| CTRL+ESC | Display the Windows Start menu. |
| CTRL+W or CTRL+F4 | Close the selected workbook window. |
| CTRL+F5 | Restore the window size of the selected workbook window. |
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command). |
| Note When the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) is visible, F6 includes that pane when switching between panes. | |
| SHFT+F6 | Switch to the previous pane in a worksheet that has been split. |
| Note When the task pane is visible, SHIFT+F6 includes that pane when switching between panes. | |
| CTRL+F6 | When more than one workbook window is open, switch to the next workbook window. |
| CTRL+SHFT+F6 | Switch to the previous workbook window. |
| CTRL+F7 | When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. |
| CTRL+F8 | When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ENTER. |
| CTRL+F9 | Minimize a workbook window to an icon. |
| CTRL+F10 | Maximize or restore the selected workbook window. |
| PRTSCR | Copy a picture of the screen to the Clipboard. |
| ALT+PRINT SCREEN | Copy a picture of the selected window to the Clipboard. |
| Access and use smart tags | |
| ALT+SHFT+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 in a smart tag menu. |
| UP ARROW | Select the previous item in a smart tag menu. |
| ENTER | Perform the action for the selected item in a smart tag menu. |
| ESC | Close the smart tag menu or message. |
| Access and use task panes | |
| F6 | Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) from another pane in the program window. (You may need to press F6 more than once.) |
| Notes If pressing F6 doesn't display the task pane you want, try pressing ALT to place focus on the menu bar, and then pressing CTRL+TAB to move to the task pane. In a worksheet that has been split (Window menu, Split command), F6 includes the split panes when switching between panes. | |
| CTRL+TAB | When a menu or toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) is active, move to a task pane. (You may need to press CTRL+TAB more than once.) |
| TAB or SHFT+TAB | When a task pane is active, select the next or previous option in the task pane |
| CTRL+SPACEBAR | Display the full set of commands on the task pane menu |
| DOWN ARROW or UP ARROW | Move among choices in a selected submenu; 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 |
| SHFT+F10 | Open a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.); open a drop-down menu for the selected gallery item |
| 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 gallery list |
| CTRL+HOME or CTRL+END | Move to the top or bottom of the selected gallery list |
| Access and use menus and toolbars | |
| F10 or ALT | Select the menu bar (menu bar: The horizontal bar below the title bar that contains the names of menus. A menu bar can be the built-in menu bar or a custom menu bar.), or close an open menu and submenu at the same time. |
| TAB or SHFT+TAB | When a toolbar is selected, select the next or previous button or menu on the toolbar. |
| CTRL+TAB or CTRL+SHFT+TAB | When a toolbar is selected, select the next or previous toolbar. |
| ENTER | Open the selected menu, or perform the action for the selected button or command. |
| SHFT+F10 | Display the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) 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. |
| 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. |
| CTRL+DOWN ARROW | Display the full set of commands on a menu. |
| CTRL+7 | Show or hide the Standard toolbar. |
| Use dialog boxes | |
| TAB | Move to the next option or option group. |
| SHFT+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+SHFT+TAB or CTRL+PAGE UP | Switch to the previous tab in a dialog box. |
| Arrow keys | Move between options in an open drop-down 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 optn in a drop-down list | Open the list if it is closed and move to that option in the list. |
| ALT+ the underlined letter in an optn | 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 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. |
| Use edit boxes within dialog boxes | |
| 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. |
| 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. |
| 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. |
| Use the Open, Save As, and Insert Picture dialog boxes | |
| ALT+1 | Go to the previous folder |
| ALT+2 | Up One Level button: open the folder up one level above the open folder |
| ALT+3 | Search the Web button: close the dialog box and open your Web search page (search page: A page from which you can find and go to other Internet sites or to documents on an intranet. Many search pages provide various ways to search, such as by topic, by keyword, or by matches to user queries.) |
| ALT+4 | Delete button: delete the selected folder or file |
| ALT+5 | Create New Folder button: create a new folder |
| ALT+6 | Views button: switch among available folder views |
| ALT+7 or ALT+L | Tools button: show the Tools menu |
| SHFT+F10 | Display a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) for a selected item such as a folder or file |
| TAB | Move between options or areas in the dialog box |
| F4 or ALT+I | Open the Look in list |
| F5 | Refresh the file list |
| Use the Help task pane and Help window | |
| F1 | Display the Help task pane. |
| F6 | Switch between the Help task pane and the active application. |
| Note In a worksheet that has been split (Window menu, Split command), F6 includes the split panes when switching between panes. | |
| TAB | Select the next item in the Help task pane. |
| SHFT+TAB | Select the previous item in the Help task pane. |
| ENTER | Perform the action for the selected item. |
| DOWN ARROW and UP ARROW | In a Table of Contents, select the next and previous item, respectively. |
| RIGHT ARROW and LEFT ARROW | In a Table of Contents, expand and collapse the selected item, respectively. |
| ALT+LEFT ARROW | Move back to the previous task Pane. |
| ALT+RIGHT ARROW | Move forward to the next task Pane. |
| CTRL+SPACEBAR | Open the menu of Pane options. |
| CTRL+F1 | Close and reopen the current task pane. |
| RIGHT ARROW | Expand a +/- list. |
| LEFT ARROW | Collapse a +/- list. |
| In the Help window | |
| TAB | Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic |
| SHFT+TAB | Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article |
| ENTER | Perform the action for the selected Show All, Hide All, hidden text, or hyperlink |
| ALT+LEFT ARROW | Move back to the previous Help topic. |
| ALT+RIGHT ARROW | Move forward to the next Help topic. |
| CTRL+P | Print the current Help topic. |
| UP ARROW AND DOWN ARROW | Scroll small amounts up and down, respectively, within the currently-displayed Help topic. |
| PAGE UP AND PAGE DOWN | Scroll larger amounts up and down, respectively, within the currently-displayed Help topic. |
| ALT+U | Change whether the Help window appears connected to (tiled) or separate from (untiled) the active application. |
| SHFT+F10 | Display a menu of commands for the Help window; requires that the Help window have active focus (click an item in the Help window). |
| Preview and print | |
| 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 with worksheets | |
| SHFT+F11 or ALT+SHFT+F1 | Insert a new worksheet. |
| CTRL+PAGE DOWN | Move to the next sheet in the workbook. |
| CTRL+PAGE UP | Move to the previous sheet in the workbook. |
| SHFT+CTRL+PAGE DOWN | Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP. |
| SHFT+CTRL+PAGE UP | Select the current and previous sheet. |
| ALT+O, H, R | Rename the current sheet (Format menu, Sheet submenu, Rename command). |
| ALT+E, M | Move or copy the current sheet (Edit menu, Move or Copy Sheet command). |
| ALT+E, L | Delete the current sheet (Edit menu, Delete Sheet command). |
| Move and scroll within worksheets | |
| Arrow keys | Move one cell up, down, left, or right. |
| TAB | Move one cell to the right. |
| SHFT+TAB | Move one cell to the left. |
| CTRL+arrow key | Move to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or worksheet borders.). |
| 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 bottom-most used row of the rightmost used column. |
| 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. |
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command). |
| Note When the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) is visible, F6 includes that pane when switching between panes. | |
| SHFT+F6 | Switch to the previous pane in a worksheet that has been split. |
| Note When the task pane is visible, SHIFT+F6 includes that pane when switching between panes. | |
| CTRL+BACKSPACE | Scroll to display the active cell. |
| F5 | Display the Go To dialog box. |
| SHFT+F5 | Display the Find dialog box. |
| SHFT+F4 | Repeat the last Find action (same as Find Next). |
| TAB | Move between unlocked cells on a protected worksheet. |
| Move within a selected range | |
| ENTER | Move from top to bottom within the selected range. |
| SHFT+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. |
| SHFT+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. |
| Move and scroll with SCROLL LOCK 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. |
| Select cells, rows and columns, and objects | |
| CTRL+SPACEBAR | Select the entire column. |
| SHFT+SPACEBAR | Select the entire row. |
| CTRL+A | Select the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. |
| SHFT+BACKSPACE | With multiple cells selected, select only the active cell. |
| CTRL+SHFT+SPACEBAR | Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet |
| CTRL+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| Select cells with specific characteristics | |
| CTRL+SHFT+* (asterisk) | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable report, select the entire PivotTable report. |
| CTRL+/ | Select the array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) containing the active cell. |
| CTRL+SHFT+O (the letter O) | Select all cells that contain comments. |
| CTRL+\ | In a selected row, select the cells that don't match the formula or static value in the active cell. |
| CTRL+SHFT+| | In a selected column, select the cells that don't match the formula or static value in the active cell. |
| CTRL+[ (opening bracket) | Select all cells directly referenced by formulas in the selection. |
| CTRL+SHFT+{ (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+SHFT+} (closing brace) | Select cells that contain formulas that directly or indirectly reference the active cell. |
| ALT+; (semicolon) | Select the visible cells in the current selection. |
| Extend a selection | |
| F8 | Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. |
| SHFT+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. |
| 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 used cell on the worksheet (lower-right corner). |
| SHFT+PAGE DOWN | Extend the selection down one screen. |
| SHFT+PAGE UP | Extend the selection up one screen. |
| 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 used cell on the worksheet (lower-right corner). |
| END+SHFT+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 (Tools menu, Options command, Transition tab). |
| SCROLL LOCK+SHFT+HOME | Extend the selection to the cell in the upper-left corner of the window. |
| SCROLL LOCK+SHFT+END | Extend the selection to the cell in the lower-right corner of the window. |
| Enter data | |
| 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. |
| SHFT+ENTER | Complete a cell entry and select the previous cell above. |
| TAB | Complete a cell entry and select the next cell to the right. |
| SHFT+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+SHFT+F3 | Create names (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) 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 (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.). |
| CTRL+; (semicolon) | Enter the date. |
| CTRL+SHFT+: (colon) | Enter the time. |
| ALT+DOWN ARROW | Display a drop-down list of the values in the current column of a range. |
| CTRL+Z | Undo the last action. |
| Enter special characters | |
| ALT+0162 | Enters the cent character ¢. |
| ALT+0163 | Enters the pound sterling character £. |
| ALT+0165 | Enters the yen symbol ¥. |
| ALT+0128 | Enters the euro symbol €. |
| Enter and calculate formulas | |
| = (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+SHFT+ENTER | Enter a formula as an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.). |
| ESC | Cancel an entry in the cell or Formula Bar. |
| SHFT+F3 | In a formula, 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+SHFT+A | When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. |
| F3 | Paste a defined name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) into a formula. |
| ALT+= (equal sign) | Insert an AutoSum formula with the SUM function. |
| CTRL+SHFT+ (quotation mark) | Copy the value from the cell above the active cell into the cell or the Formula Bar. |
| CTRL+' (apostrophe) | Copies 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. |
| SHFT+F9 | Calculate the active worksheet. |
| Note When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value. | |
| CTRL+ALT+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| CTRL+ALT+SHFT+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| Edit data | |
| 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 | Display the Spelling dialog box. |
| SHFT+F2 | Edit a cell comment. |
| ENTER | Complete a cell entry and select the next cell below. |
| CTRL+Z | Undo the last action. |
| ESC | Cancel a cell entry. |
| CTRL+SHFT+Z | When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction. |
| Insert, delete, and copy cells | |
| CTRL+C | Copy the selected cells. |
| CTRL+C, immediately followed by another CTRL+C | Display the Microsoft Office Clipboard (multiple copy and paste). |
| CTRL+X | Cut the selected cells. |
| CTRL+V | Paste copied cells. |
| DELETE | Clear the contents of the selected cells. |
| CTRL+HYPHEN | Delete the selected cells. |
| CTRL+SHFT+PLUS SIGN | Insert blank cells. |
| Format data | |
| ALT+' (apostrophe) | Display the Style dialog box. |
| CTRL+1 | Display the Format Cells dialog box. |
| CTRL+SHFT+~ | Apply the General number format. |
| CTRL+SHFT+$ | Apply the Currency format with two decimal places (negative numbers 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 AM or PM. |
| CTRL+SHFT+! | 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+SHFT+( (opening parenthesis) | Unhide any hidden rows within the selection. |
| CTRL+0 (zero) | Hide the selected columns. |
| CTRL+SHFT+) (closing parenthesis) | Unhide any hidden columns within the selection. |
| CTRL+SHFT+& | Apply the outline border to the selected cells. |
| CTRL+SHFT+_ | Remove the outline border from the selected cells. |
| Use the Border tab in the Format Cells dialog box | |
| 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. |
| Use data forms (Data menu, Form command) | |
| DOWN ARROW | Move to the same field in the next record. |
| UP ARROW | Move to the same field in the previous record. |
| TAB and SHFT+TAB | Move to each field in the record, then to each command button. |
| 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. |
| CTRL+PAGE DOWN | Start a new, blank record. |
| PAGE UP | Move to the same field 10 records back. |
| CTRL+PAGE UP | Move to the first record. |
| HOME or END | Move to the beginning or end of a field. |
| SHFT+END | Extend selection to the end of a field. |
| SHFT+HOME | Extend selection to the beginning of a field. |
| LEFT ARROW or RIGHT ARROW | Move one character left or right within a field. |
| SHFT+LEFT ARROW | Select the character to the left within a field. |
| SHFT+RIGHT ARROW | Select the character to the right within a field. |
| Filter ranges (Data menu, AutoFilter command) | |
| ALT+DOWN ARROW | In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column. |
| DOWN ARROW | Selects the next item in the AutoFilter list. |
| UP ARROW | Selects the previous item in the AutoFilter list. |
| ALT+UP ARROW | Closes the AutoFilter list for the current column. |
| HOME | Selects the first item (All) in the AutoFilter list. |
| END | Selects the last item in the AutoFilter list. |
| ENTER | Filters the range based on the item selected from the AutoFilter list. |
| Show, hide, and outline data | |
| ALT+SHFT+RIGHT ARROW | Groups rows or columns. |
| ALT+SHFT+LEFT ARROW | Ungroups rows or columns. |
| CTRL+8 | Displays or hides the outline symbols. |
| CTRL+9 | Hides the selected rows. |
| CTRL+SHFT+( (opening parenthesis) | Unhides any hidden rows within the selection. |
| CTRL+0 (zero) | Hides the selected columns. |
| CTRL+SHFT+) (closing parenthesis) | Unhides any hidden columns within the selection. |
| Use the PivotTable and PivotChart Wizard - Layout dialog box | |
| UP ARROW or DOWN ARROW | Selects the previous or next field button in the list on the right. |
| LEFT ARROW or RIGHT ARROW | With two or more columns of field buttons, selects the button to the left or right. |
| ALT+R | Moves the selected field into the Row area. |
| ALT+C | Moves the selected field into the Column area. |
| ALT+D | Moves the selected field into the Data area. |
| ALT+P | Moves the selected field into the Page area. |
| ALT+L | Displays the PivotTable Field dialog box for the selected field. |
| Display and hide items in a field | |
| ALT+DOWN ARROW | Displays the drop-down list for a field in a PivotTable or PivotChart report. Use the arrow keys to select the field. |
| UP ARROW | Selects the previous item in the range. |
| DOWN ARROW | Selects the next item in the range. |
| RIGHT ARROW | For an item that has lower-level items available, displays the lower-level items. |
| LEFT ARROW | For an item that has lower-level items displayed, hides the lower-level items. |
| HOME | Selects the first visible item in the list. |
| END | Selects the last visible item in the list. |
| ENTER | Closes the list and displays the selected items. |
| SPACEBAR | Checks, double-checks, or clears a check box in the list. Double-check selects both an item and all of its llower-level items. |
| TAB | Switches between the list, the OK button, and the Cancel button. |
| Change the layout of a report | |
| CTRL+SHFT+* (asterisk) | Selects an entire PivotTable report. |
| ALT+SHFT+RIGHT ARROW | Groups the selected items in a PivotTable field. |
| ALT+SHFT+LEFT ARROW | Ungroups grouped items in a PivotTable field. |
| Create charts and select chart elements | |
| F11 or ALT+F1 | Creates a chart of the data in the current range. |
| CTRL+PAGE DOWN | Selects a chart sheet: selects the next sheet in the workbook, until the chart sheet you want is selected. |
| CTRL+PAGE UP | Selects a chart sheet: selects the previous sheet in the workbook, until the chart sheet you want is selected. |
| DOWN ARROW | Select the previous group of elements in a chart. |
| UP ARROW | Selects the next group of elements in a chart. |
| RIGHT ARROW | Selects the next element within a group. |
| LEFT ARROW | Selects the previous element within a group. |
| Use speech recognition and text-to-speech | |
| CTRL | Switches between command mode and dictation mode. |
| ESC | Stops reading when text is being read aloud. |
| Send e-mail messages | |
| SHFT+TAB | When cell A1 is selected, moves to the Introduction box in the e-mail message header. In the message header, moves to the Subject, Bcc (if displayed), Cc, To, and From (if displayed) boxes, then to the address book for the Bcc, Cc, To, and From boxes, and then to cell A1. |
| ALT+S | Sends the e-mail message. |
| CTRL+SHFT+B | Opens the Address Book. |
| ALT+O | Opens the Options menu for access to the Options, Bcc Field, and From Field commands. |
| ALT+P | Opens the Outlook Message Options dialog box (Options menu, Options command). |
| ALT+K | Checks the names in the To, Cc, and Bcc boxes against the Address Book. |
| ALT+PERIOD | Opens the Address Book for the To box. |
| ALT+C | Opens the Address Book for the Cc box. |
| ALT+B | If the Bcc box is displayed, opens the Address Book for the Bcc box. |
| ALT+J | Goes to the Subject box. |
| CTRL+SHFT+G | Creates a message flag. |
| ALT+A | Adds interactivity to the range or sheet being sent. |
| Work with macros | |
| ALT+F8 | Displays the Macro dialog box. |
| ALT+F11 | Displays the Visual Basic Editor. |
| CTRL+F11 | Inserts a Microsoft Excel 4.0 macro sheet. |
| Work with multiple national languages | |
| CTRL+RIGHT SHFT | Switches to right-to-left paragraph direction (the text must contain only neutral characters (neutral characters: Characters that do not have strong right-to-left or left-to-right language attributes. Numerals are an example of neutral characters.)). |
| CTRL+LEFT SHFT | Switches to left-to-right paragraph direction (the text must contain only neutral characters). |
| ALT+SHFT+UP ARROW | In Japanese text for which you've displayed phonetic guides, moves the pointer into the phonetic guides. |
| ALT+SHFT+DOWN ARROW | Moves the pointer from the phonetic guides back to the parent string of characters. |
| NUM LOCK, ALT+numeric pad numbers | Enter a unicode character. |
| ALT+X | Pressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character. Pressed immediately following a unicode character, converts the character to its hexadecimal code. |
Microsoft Excel 2002 Keyboard Shortcuts
| SHORTCUT | ACTION |
| ALT+' (apostrophe) | Display the Style dialog box. |
| ALT+ the underlined letter in an optn | Select an option, or select or clear a check box. |
| ALT+; (semicolon) | Select the visible cells in the current selection. |
| ALT+= (equal sign) | Insert an AutoSum formula with the SUM function. |
| ALT+0128 | Enters the euro symbol. |
| ALT 0162 | Enters the cent character in Microsoft Excel |
| ALT+0163 | Enters the pound sterling character |
| ALT+0165 | Enters the yen symbol |
| ALT+A | In Help, switch to the Answer Wizard tab. |
| ALT+A | Adds interactivity to the range or sheet being sent. |
| ALT B | Apply or remove the bottom border in Microsoft Excel. |
| ALT+B | If the Bcc box is displayed, opens the Address Book for the Bcc box. |
| ALT+C | In Help, switch to the Contents tab. |
| ALT+C | Moves the selected field into the Column area. |
| ALT+C | Opens the Address Book for the Cc box. |
| ALT+D | Apply or remove the downward diagonal border. |
| ALT+D | Moves the selected field into the Data area. |
| ALT+DOWN ARROW | Display more Help topics in the Assistant list |
| ALT DOWN ARROW | Open the selected drop-down list in Microsoft Excel. |
| ALT+DOWN ARROW | Display a drop-down list of the values in the current column of a list (list: A series of worksheet rows that contain related data, such as an invoice database or a set of client names and phone numbers. The first row of the list has labels for the columns.). |
| ALT+DOWN ARROW | In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column. |
| ALT+DOWN ARROW | Displays the drop-down list for a field in a PivotTable or PivotChart report. Use the arrow keys to select the field. |
| ALT+E L | Delete the current sheet (Edit menu, Delete Sheet command). |
| ALT+E M | Move or copy the current sheet (Edit menu, Move or Copy Sheet command). |
| ALT+ENTER | Start a new line in the same cell. |
| ALT ENTER | Start a new line in the same cell in Microsoft Excel. |
| ALT+F4 | In the Help windows, close the Help window |
| ALT+H | If cells in multiple rows are selected, apply or remove the horizontal divider. |
| ALT+I | In Help, switch to the Index tab |
| ALT+J | Goes to the Subject box. |
| ALT+K | Checks the names in the To, Cc, and Bcc boxes against the Address Book. |
| ALT L | Apply or remove the left border in Microsoft Excel. |
| ALT+L | Displays the PivotTable Field dialog box for the selected field. |
| ALT+LEFT ARROW | Go to the previous Help topic |
| ALT+number | Select a Help topic from the list the Assistant displays. ALT+1 is the first topic, ALT+2 is the second, and so on. |
| ALT+O | In the Help windows, dsplay the Options menu to access any Help toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, use the Customize dialog box (point to Toolbars on the View menu and click Customize). To see more buttons, click Toolbar Options at the end of the toolbar.) command. |
| ALT+O | Opens the Options menu for access to the Options, Bcc Field, and From Field commands. |
| ALT+O H R | Rename the current sheet (Format menu, Sheet submenu, Rename command). |
| ALT+O, and then press B | In the Help windows, display the previously viewed topic |
| ALT+O, and then press F | In the Help windows, display the next topic in a previously displayed sequence of topics |
| ALT O, and then press H | In the Help windows, return to the specified home page in Microsoft Excel |
| ALT+O, and then press I | In the Help windows, open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings |
| ALT+O, and then press P | In the Help windows, print all topics in a book or a selected topic only |
| ALT+O, and then press R | In the Help windows, refresh the topic (useful if you have linked to a Web page) |
| ALT+O, and then press S | In the Help windows, stop the Help window from opening a Help topic (useful if you want to stop a Web page from downloading) |
| ALT+O, and then press T | In the Help windows, hide or show the pane with the Contents, Answer Wizard, and Index tabs |
| ALT P | Moves the selected field into the Page area in Microsoft Excel. |
| ALT+P | Opens the Outlook Message Options dialog box (Options menu, Options command). |
| ALT+PAGE DOWN | Move one screen to the right. |
| ALT+PAGE UP | Move one screen to the left. |
| ALT+PERIOD | Opens the Address Book for the To box. |
| ALT+PRINT SCREEN | Copy a picture of the selected window to the Clipboard. |
| ALT R | Apply or remove the right border in Microsoft Excel. |
| ALT+R | Moves the selected field into the Row area. |
| ALT+RIGHT ARROW | Go to the next Help topic |
| ALT+S | Sends the e-mail message. |
| ALT+SHFT+DOWN ARROW | Moves the pointer from the phonetic guides back to the parent string of characters. |
| ALT+SHFT+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. |
| ALT SHFT LEFT ARROW | Ungroups rows or columns in Microsoft Excel. |
| ALT+SHFT+LEFT ARROW | Ungroups grouped items in a PivotTable field. |
| ALT+SHFT+RIGHT ARROW | Groups rows or columns. |
| ALT+SHFT+RIGHT ARROW | Groups the selected items in a PivotTable field. |
| ALT+SHFT+TAB | Switch to the previous program. |
| ALT+SHFT+UP ARROW | In Japanese text for which you've displayed phonetic guides, moves the pointer into the phonetic guides. |
| ALT+SPACEBAR | Display the Control menu for the Excel window. |
| ALT+T | Apply or remove the top border. |
| ALT+TAB | Switch to the next program. |
| ALT+U | Apply or remove the upward diagonal border. |
| ALT+UP ARROW | Display previous Help topics in the Assistant list |
| ALT UP ARROW | Closes the AutoFilter list for the current column in Microsoft Excel. |
| ALT+V | If cells in multiple columns are selected, apply or remove the vertical divider. |
| ALT+X | Pressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character. |
| Arrow keys | Move between options in an open drop-down list, or between options in a group of options. |
| Arrow keys | Move around the page when zoomed in. |
| Arrow keys | Move one cell up, down, left, or right. |
| Arrow keys | Move one character up, down, left, or right in Microsoft Excel. |
| BACKSPACE | In the Formula Bar, delete one character to the left. |
| BACKSPACE | Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents. |
| CTRL | Switches between command mode and dictation mode. |
| CTRL+' (apostrophe) | Copies a formula from the cell above the active cell into the cell or the Formula Bar. |
| CTRL+/ | Select the array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) containing the active cell. |
| CTRL ; (semicolon) | Enter the date in Microsoft Excel. |
| CTRL+[ (opening bracket) | Select all cells directly referenced by formulas in the selection. |
| CTRL+\ | In a selected row, select the cells that don't match the value in the active cell. |
| CTRL+] (closing bracket) | Select cells that contain formulas that directly reference the active cell. |
| CTRL+` (single left quotation mark) | Alternate between displaying cell values and displaying formulas. |
| CTRL 0 (zero) | Hide the selected columns in Microsoft Excel. |
| CTRL+0 (zero) | Hides the selected columns. |
| CTRL+1 | Display the Format Cells dialog box. |
| CTRL+5 | Apply or remove strikethrough. |
| CTRL+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| CTRL+7 | Show or hide the Standard toolbar. |
| CTRL+8 | Displays or hides the outline symbols. |
| CTRL+9 | Hide the selected rows. |
| CTRL+9 | Hides the selected rows. |
| CTRL+A | Select the entire Help topic |
| CTRL+A | Select the entire worksheet. |
| CTRL+A | When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. |
| CTRL+ALT+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| CTRL ALT LEFT ARROW | Switch to the next nonadjacent selection to the left in Microsoft Excel. |
| CTRL+ALT+RIGHT ARROW | In nonadjacent selections, switch to the next selection to the right. |
| CTRL+ALT+SHFT+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| CTRL+arrow key | Move to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or worksheet borders.). |
| CTRL+B | Apply or remove bold formatting. |
| CTRL+BACKSPACE | Scroll to display the active cell. |
| CTRL+C | Copy the selected items to the Clipboard |
| CTRL+C | Copy the selected cells. |
| CTRL+C, immediately followed by another CTRL+C | Display the Microsoft Office Clipboard (multiple copy and paste). |
| CTRL+D | Fill down. |
| CTRL DELETE | Delete text to the end of the line in Microsoft Excel. |
| CTRL+DOWN ARROW | Display the full set of commands on the task pane menu |
| CTRL+DOWN ARROW | Display the full set of commands on a menu. |
| CTRL+DOWN ARROW or CTRL+RIGHT ARROW | Move to the last page when zoomed out. |
| CTRL+END | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. |
| CTRL+ENTER | Fill the selected cell range with the current entry. |
| CTRL+ESC | Display the Windows Start menu. |
| CTRL F10 | Maximize or restore the selected workbook window in Microsoft Excel. |
| CTRL+F3 | Define a name. |
| CTRL+F5 | Restore the window size of the selected workbook window. |
| CTRL+F6 | When more than one workbook window is open, switch to the next workbook window. |
| CTRL+F7 | When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. |
| CTRL+F8 | When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ESC. |
| CTRL+F9 | Minimize a workbook window to an icon. |
| CTRL HOME | Move to the beginning of the worksheet in Microsoft Excel. |
| CTRL+HOME or CTRL+END | Move to the top or bottom of the selected gallery list |
| CTRL+HYPHEN | Delete the selected cells. |
| CTRL+I | Apply or remove italic formatting. |
| CTRL+K | Insert a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, an HTML page on the World Wide Web, or an HTML page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.). |
| CTRL+LEFT ARROW | Move one word to the left. |
| CTRL+LEFT SHFT | Switches to left-to-right paragraph direction (the text must contain only neutral characters). |
| CTRL P | Print the current Help topic in Microsoft Excel |
| CTRL+P or CTRL+SHFT+F12 | Display the Print dialog box. |
| CTRL+PAGE DOWN | Move to the next sheet in the workbook. |
| CTRL+PAGE DOWN | Start a new, blank record. |
| CTRL+PAGE DOWN | Selects a chart sheet: selects the next sheet in the workbook, until the chart sheet you want is selected. |
| CTRL+PAGE UP | Move to the previous sheet in the workbook. |
| CTRL PAGE UP | Move to the first record in Microsoft Excel. |
| CTRL+PAGE UP | Selects a chart sheet: selects the previous sheet in the workbook, until the chart sheet you want is selected. |
| CTRL+PERIOD | Move clockwise to the next corner of the selected range. |
| CTRL+R | Fill to the right. |
| CTRL+RIGHT ARROW | Move one word to the right. |
| CTRL+RIGHT SHFT | Switches to right-to-left paragraph direction (the text must contain only neutral characters (neutral characters: Characters that do not have strong right-to-left or left-to-right language attributes. Numerals are an example of neutral characters.)). |
| CTRL+SHFT+! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| CTRL+SHFT+ (quotation mark) | Copy the value from the cell above the active cell into the cell or the Formula Bar. |
| CTRL SHFT | #Apply the Date format with the day, month, and year in Microsoft Excel. |
| CTRL+SHFT+$ | Apply the Currency format with two decimal places (negative numbers in parentheses). |
| CTRL+SHFT+% | Apply the Percentage format with no decimal places. |
| CTRL+SHFT+& | Apply the outline border to the selected cells. |
| CTRL+SHFT+( (opening parenthesis) | Unhide any hidden rows within the selection. |
| CTRL+SHFT+( (opening parenthesis) | Unhides any hidden rows within the selection. |
| CTRL+SHFT+) (closing parenthesis) | Unhide any hidden columns within the selection. |
| CTRL+SHFT+) (closing parenthesis) | Unhides any hidden columns within the selection. |
| CTRL+SHFT+* (asterisk) | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable report, select the entire PivotTable report. |
| CTRL+SHFT+* (asterisk) | Selects an entire PivotTable report. |
| CTRL SHFT : (colon) | Enter the time in Microsoft Excel |
| CTRL+SHFT+@ | Apply the Time format with the hour and minute, and AM or PM. |
| CTRL+SHFT+^ | Apply the Exponential number format with two decimal places. |
| CTRL+SHFT+_ | Remove the outline border from the selected cells. |
| CTRL+SHFT+{ (opening brace) | Select all cells directly or indirectly referenced by formulas in the selection. |
| CTRL+SHFT+| | In a selected column, select the cells that don't match the value in the active cell. |
| CTRL+SHFT+} (closing brace) | Select cells that contain formulas that directly or indirectly reference the active cell. |
| CTRL SHFT ~ | Apply the General number format in Microsoft Excel. |
| CTRL+SHFT+A | When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. |
| CTRL+SHFT+arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell. |
| CTRL+SHFT+B | Opens the Address Book. |
| CTRL+SHFT+END | Extend the selection to the last used cell on the worksheet (lower-right corner). |
| CTRL+SHFT+ENTER | Enter a formula as an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { }, and are entered by pressing CTRL+SHFT+ENTER.). |
| CTRL+SHFT+F3 | Create names (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy to understand names, such as Products to refer to hard to understand ranges, such as Sales!C20:C30.) from row and column labels. |
| CTRL+SHFT+F6 | Switch to the previous workbook window. |
| CTRL SHFT G | Creates a message flag in Microsoft Excel. |
| CTRL+SHFT+HOME | Extend the selection to the beginning of the worksheet. |
| CTRL+SHFT+LEFT ARROW | Select or unselect one word to the left. |
| CTRL+SHFT+O (the letter O) | Select all cells that contain comments. |
| CTRL SHFT PLUS SIGN | Insert blank cells in Microsoft Excel. |
| CTRL+SHFT+RIGHT ARROW | Select or unselect one word to the right. |
| CTRL+SHFT+SPACEBAR | With an object selected, select all objects on a sheet. |
| CTRL+SHFT+TAB or CTRL+PAGE UP | Switch to the previous tab in a dialog box. |
| CTRL+SHFT+Z | When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction. |
| CTRL SPACEBAR | Select the entire column in Microsoft Excel. |
| CTRL+TAB | In Help, switch to the next tab |
| CTRL+TAB | When a menu or toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, use the Customize dialog box (point to Toolbars on the View menu and click Customize). To see more buttons, click Toolbar Options at the end of the toolbar.) is active, move to a task pane. (You may need to press CTRL+TAB more than once.) |
| CTRL+TAB or CTRL+PAGE DOWN | Switch to the next tab in a dialog box. |
| CTRL+TAB or CTRL+SHFT+TAB | When a toolbar is selected, select the next or previous toolbar. |
| CTRL+U | Apply or remove underlining. |
| CTRL+UP ARROW or CTRL+LEFT ARROW | Move to the first page when zoomed out. |
| CTRL+V | Paste copied cells. |
| CTRL+W or CTRL+F4 | Close the selected workbook window. |
| CTRL+X | Cut the selected cells. |
| CTRL Z | Undo the last action in Microsoft Excel. |
| CTRL+Z | Undo the last action. |
| DELETE | Delete the character to the right of the insertion point, or delete the selection. |
| DELETE | Clear the contents of the selected cells. |
| DOWN ARROW | In Help, select the next book or Help topic |
| DOWN ARROW | Select the next item in a smart tag menu. |
| DOWN ARROW | Move to the same field in the next record. |
| DOWN ARROW | Selects the next item in the AutoFilter list. |
| DOWN ARROW | Selects the next item in the list in Microsoft Excel. |
| DOWN ARROW | Select the previous group of elements in a chart. |
| DOWN ARROW or UP ARROW | Move among choices in a selected submenu; move among certain options in a group of options |
| DOWN ARROW or UP ARROW | When a menu or submenu is open, select the next or previous command. |
| END | Move to the end of the entry. |
| END | Move to the cell in the lower-right corner of the window. |
| END | Selects the last item in the AutoFilter list. |
| END | Selects the last visible item in the list. |
| END key | Turn End mode on or off in Microsoft Excel. |
| END+arrow key | Move by one block of data within a row or column. |
| END+ENTER | Move to the rightmost nonblank cell in the current row. This key sequence does not work if you have turned on transition navigation keys (Tools menu, Options command, Transition tab). |
| END+HOME | Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. |
| END+SHFT+arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell. |
| END+SHFT+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 (Tools menu, Options command, Transition tab). |
| END+SHFT+HOME | Extend the selection to the last used cell on the worksheet (lower-right corner). |
| ENTER | In the Help windows, perform the action for the selected Show All, Hide All, hidden text, or hyperlink |
| ENTER | In Help, open a selected book or Help topic in Microsoft Excel |
| ENTER | Perform the action for the selected Show All, Hide All, hidden text, or hyperlink |
| ENTER | Perform the action for the selected item in a smart tag menu. |
| ENTER | Open the selected menu, or perform the action for the selected button or command. |
| ENTER | Perform the action for the default command button in the dialog box (the button with the bold outline, often the OK button). |
| ENTER | Move from top to bottom within the selected range in Microsoft Excel. |
| ENTER | Complete a cell entry and select the cell below. |
| ENTER | Complete a cell entry from the cell or Formula Bar. |
| ENTER | Complete a cell entry and select the next cell below. |
| ENTER | Move to the first field in the next record. |
| ENTER | Filters the list based on the item selected from the AutoFilter list. |
| ENTER | Closes the list and displays the selected items. |
| ENTER (in a cell with a hyperlink) | Activate a hyperlink in Microsoft Excel. |
| ESC | Close an Assistant message or a tip |
| ESC | Close the smart tag menu or message. |
| ESC | Close an open menu. When a submenu is open, close only the submenu. |
| ESC | Cancel the command and close the dialog box. |
| ESC | Cancel a cell entry. |
| ESC | Cancel an entry in the cell or Formula Bar. |
| ESC | Cancel a cell entry in Microsoft Excel |
| ESC | Stops reading when text is being read aloud. |
| F1 | Display the Assistant balloon (if the Assistant is turned off, F1 opens the Help window) |
| F1 | Display the Help window if the Assistant is turned off (if the Assistant is turned on, F1 displays the Assistant balloon). |
| F10 or ALT | Select the menu bar (menu bar: The horizontal bar below the title bar that contains the names of menus. A menu bar can be the built-in menu bar or a custom menu bar.), or close an open menu and submenu at the same time. |
| F11 or ALT+F1 | Creates a chart of the data in the current range. |
| F2 | Move the insertion point into the Formula Bar when editing in a cell is turned off. |
| F2 | Edit the active cell and position the insertion point at the end of the cell contents. |
| F3 | Paste a defined name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy to understand names, such as Products to refer to hard to understand ranges, such as Sales!C20:C30.) into a formula. |
| F4 or ALT+I | Open the Look in list |
| F4 or CTRL Y | Repeat the last action in Microsoft Excel. |
| F5 | Refresh the file list |
| F5 | Display the Go To dialog box. |
| F6 | In the Help windows, switch between the Help topic and the Contents, Answer Wizard, Index pane (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars. ) |
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command). |
| F6 | Move to a task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) from another pane in the program window. (You may need to press F6 more than once.) |
| F6 | Switch to the next pane in a worksheet that has been split (Window menu, Split command). |
| F7 | Display the Spelling dialog box in Microsoft Excel. |
| F8 | Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. |
| First letter of an optn in a drop-down list | Open the list if it is closed and move to that option in the list. |
| HOME | Move to the beginning of the entry. |
| HOME | Move to the beginning of the row. |
| HOME | Move to the cell in the upper-left corner of the window. |
| HOME | Move to the beginning of the line. |
| HOME | Selects the first item (All) in the AutoFilter list. |
| HOME | Selects the first visible item in the list. |
| HOME or END | Go to the beginning or end of a Help topic in Microsoft Excel |
| HOME or END | Select the first or last command on the menu or submenu. |
| HOME or END | Move to the beginning or end of a field. |
| HOME or END | When a menu or submenu is visible, select the first or last command on the menu or submenu |
| LEFT ARROW | For an item that has lower-level items displayed, hides the lower-level items. |
| LEFT ARROW | Selects the previous element within a group. |
| 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. |
| LEFT ARROW or RIGHT ARROW | Move one character to the left or right. |
| LEFT ARROW or RIGHT ARROW | Scroll one column left or right in Microsoft Excel. |
| LEFT ARROW or RIGHT ARROW | Move one character left or right within a field. |
| LEFT ARROW or RIGHT ARROW | With two or more columns of field buttons, selects the button to the left or right. |
| NUM LOCK, ALT+numeric pad numbers | Enter a unicode character. |
| PAGE DOWN | Move down one screen. |
| PAGE DOWN | Move to the same field 10 records forward. |
| PAGE UP | Move up one screen. |
| PAGE UP | Move to the same field 10 records back. |
| PAGE UP or PAGE DOWN | Scroll toward the beginning or end of a Help topic in large increments |
| PAGE UP or PAGE DOWN | Scroll up or down in the selected gallery list |
| PAGE UP or PAGE DOWN | Move by one page when zoomed out. |
| PRTSCR | Copy a picture of the screen to the Clipboard. |
| RIGHT ARROW | For an item that has lower-level items available, displays the lower-level items. |
| RIGHT ARROW | Selects the next element within a group in Microsoft Excel. |
| SCROLL LOCK | Turn SCROLL LOCK on or off. |
| SCROLL LOCK+SHFT+END | Extend the selection to the cell in the lower-right corner of the window. |
| SCROLL LOCK+SHFT+HOME | Extend the selection to the cell in the upper-left corner of the window. |
| SHFT+arrow key | Extend the selection by one cell. |
| SHFT+BACKSPACE | With multiple cells selected, select only the active cell. |
| SHFT+CTRL+PAGE DOWN | Select the current and next sheet. To cancel selection of multiple sheets, press CTRL+PAGE DOWN or, to select a different sheet, press CTRL+PAGE UP. |
| SHFT+CTRL+PAGE UP | Select the current and previous sheet. |
| SHFT+END | Select from the insertion point to the end of the entry. |
| SHFT END | Extend selection to the end of a field in Microsoft Excel. |
| SHFT+ENTER | Move from bottom to top within the selected range. |
| SHFT+ENTER | Complete a cell entry and select the previous cell above. |
| SHFT+ENTER | Move to the first field in the previous record. |
| SHFT+F10 | In Help, display a shortcut menu |
| SHFT+F10 | Display a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHFT+F10.) |
| SHFT+F10 | Open a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHFT+F10.); open a drop-down menu for the selected gallery item |
| SHFT+F10 | Display the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHFT+F10.) for the selected item. |
| SHFT+F10 | Display a shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHFT+F10.) for a selected item such as a folder or file |
| SHFT+F11 or ALT+SHFT+F1 | Insert a new worksheet. |
| SHFT F2 | Edit a cell comment in Microsoft Excel. |
| SHFT+F3 | In a formula, display the Insert Function dialog box. |
| SHFT+F4 | Repeat the last Find action (same as Find Next). |
| SHFT+F5 | Display the Find dialog box. |
| SHFT+F6 | Switch to the previous pane in a worksheet that has been split. |
| SHFT+F6 | Switch to the previous pane in a worksheet that has been split. |
| SHFT+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. |
| SHFT+F9 | Calculate the active worksheet. |
| SHFT HOME | Select from the insertion point to the beginning of the entry in Microsoft Excel. |
| SHFT+HOME | Extend the selection to the beginning of the row. |
| SHFT+HOME | Extend selection to the beginning of a field. |
| SHFT+LEFT ARROW | Select or unselect one character to the left. |
| SHFT+LEFT ARROW | Select the character to the left within a field. |
| SHFT+PAGE DOWN | Extend the selection down one screen. |
| SHFT PAGE UP | Extend the selection up one screen in Microsoft Excel. |
| SHFT+RIGHT ARROW | Select or unselect one character to the right. |
| SHFT+RIGHT ARROW | Select the character to the right within a field. |
| SHFT+SPACEBAR | Select the entire row. |
| SHFT+TAB | In the Help windows, select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web article. |
| SHFT+TAB | Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web article. |
| SHFT+TAB | Move to the previous option or option group. |
| SHFT+TAB | Move from right to left within the selected range. If cells in a single column are selected, move up. |
| SHFT TAB | Complete a cell entry and select the previous cell to the left in Microsoft Excel. |
| SHFT+TAB | When cell A1 is selected, moves to the Introduction box in the e-mail message header. In the message header, moves to the Subject, Bcc (if displayed), Cc, To, and From (if displayed) boxes, then to the address book for the Bcc, Cc, To, and From boxes, and then to cell A1. |
| SPACEBAR | Perform the action for the selected button, or select or clear the selected check box. |
| SPACEBAR | Checks, double-checks, or clears a check box in the list. Double-check selects both an item and all of its llower-level items. |
| SPACEBAR or ENTER | Open the selected menu, or perform the action assigned to the selected button |
| SPACEBAR, with the Help button selected | Show the Assistant in a wizard or dialog box. To hide the Assistant, press SPACEBAR again. Note that not all wizards or dialog boxes have Help provided by the Assistant. |
| TAB | Move to the Help button in a wizard |
| TAB | In the Help windows, select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic. |
| TAB | Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic. |
| TAB | Move to the next option or option group in Microsoft Excel. |
| TAB | Move between options or areas in the dialog box |
| TAB | Move between unlocked cells on a protected worksheet. |
| TAB | Move from left to right within the selected range. If cells in a single column are selected, move down. |
| TAB | Complete a cell entry and select the next cell to the right. |
| TAB | Switches between the list, the OK button, and the Cancel button. |
| TAB and SHFT+TAB | Move to each field in the record, then to each command button. |
| TAB or SHFT+TAB | When a toolbar is selected, select the next or previous button or menu on the toolbar. |
| TAB or SHFT+TAB | When a task pane is active, select the next or previous option in the task pane |
| UP ARROW | In Help, select the previous book or Help topic in Microsoft Excel |
| UP ARROW | Select the previous item in a smart tag menu. |
| UP ARROW | Move to the same field in the previous record. |
| UP ARROW | Selects the previous item in the AutoFilter list. |
| UP ARROW | Selects the previous item in the list. |
| UP ARROW | Selects the next group of elements in a chart in Microsoft Excel. |
| UP ARROW or DOWN ARROW | Scroll toward the beginning or end of a Help topic |
| UP ARROW or DOWN ARROW | Scroll one row up or down. |
| UP ARROW or DOWN ARROW | Selects the previous or next field button in the list on the right. |
Subscribe to:
Posts (Atom)