| 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+Shift+DOWN ARROW |
Moves the pointer from the phonetic guides back to the parent string of characters. |
| ALT+Shift+F10 |
Display the menu or message for a smart tag. If more than one smart tag is present, switch to the next smart tag and display its menu or message. |
| ALT Shift LEFT ARROW |
Ungroups rows or columns in Microsoft Excel. |
| ALT+Shift+LEFT ARROW |
Ungroups grouped items in a PivotTable field. |
| ALT+Shift+RIGHT ARROW |
Groups rows or columns. |
| ALT+Shift+RIGHT ARROW |
Groups the selected items in a PivotTable field. |
| ALT+Shift+TAB |
Switch to the previous program. |
| ALT+Shift+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+Shift+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 Shift |
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+Shift+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 Shift |
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+Shift+! |
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| CTRL+Shift+ (quotation mark) |
Copy the value from the cell above the active cell into the cell or the Formula Bar. |
| CTRL Shift |
#Apply the Date format with the day, month, and year in Microsoft Excel. |
| CTRL+Shift+$ |
Apply the Currency format with two decimal places (negative numbers in parentheses). |
| CTRL+Shift+% |
Apply the Percentage format with no decimal places. |
| CTRL+Shift+& |
Apply the outline border to the selected cells. |
| CTRL+Shift+( (opening parenthesis) |
Unhide any hidden rows within the selection. |
| CTRL+Shift+( (opening parenthesis) |
Unhides any hidden rows within the selection. |
| CTRL+Shift+) (closing parenthesis) |
Unhide any hidden columns within the selection. |
| CTRL+Shift+) (closing parenthesis) |
Unhides any hidden columns within the selection. |
| CTRL+Shift+* (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+Shift+* (asterisk) |
Selects an entire PivotTable report. |
| CTRL Shift : (colon) |
Enter the time in Microsoft Excel |
| CTRL+Shift+@ |
Apply the Time format with the hour and minute, and AM or PM. |
| CTRL+Shift+^ |
Apply the Exponential number format with two decimal places. |
| CTRL+Shift+_ |
Remove the outline border from the selected cells. |
| CTRL+Shift+{ (opening brace) |
Select all cells directly or indirectly referenced by formulas in the selection. |
| CTRL+Shift+| |
In a selected column, select the cells that don't match the value in the active cell. |
| CTRL+Shift+} (closing brace) |
Select cells that contain formulas that directly or indirectly reference the active cell. |
| CTRL Shift ~ |
Apply the General number format in Microsoft Excel. |
| CTRL+Shift+A |
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses. |
| CTRL+Shift+arrow key |
Extend the selection to the last nonblank cell in the same column or row as the active cell. |
| CTRL+Shift+B |
Opens the Address Book. |
| CTRL+Shift+END |
Extend the selection to the last used cell on the worksheet (lower-right corner). |
| CTRL+Shift+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+Shift+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+Shift+F6 |
Switch to the previous workbook window. |
| CTRL Shift G |
Creates a message flag in Microsoft Excel. |
| CTRL+Shift+HOME |
Extend the selection to the beginning of the worksheet. |
| CTRL+Shift+LEFT ARROW |
Select or unselect one word to the left. |
| CTRL+Shift+O (the letter O) |
Select all cells that contain comments. |
| CTRL Shift PLUS SIGN |
Insert blank cells in Microsoft Excel. |
| CTRL+Shift+RIGHT ARROW |
Select or unselect one word to the right. |
| CTRL+Shift+SPACEBAR |
With an object selected, select all objects on a sheet. |
| CTRL+Shift+TAB or CTRL+PAGE UP |
Switch to the previous tab in a dialog box. |
| CTRL+Shift+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+Shift+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+Shift+arrow key |
Extend the selection to the last nonblank cell in the same column or row as the active cell. |
| END+Shift+ENTER |
Extend the selection to the last cell in the current row. This key sequence does not work if you have turned on transition navigation keys (Tools menu, Options command, Transition tab). |
| END+Shift+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 option 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+Shift+END |
Extend the selection to the cell in the lower-right corner of the window. |
| SCROLL LOCK+Shift+HOME |
Extend the selection to the cell in the upper-left corner of the window. |
| Shift+arrow key |
Extend the selection by one cell. |
| Shift+BACKSPACE |
With multiple cells selected, select only the active cell. |
| Shift+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. |
| Shift+CTRL+PAGE UP |
Select the current and previous sheet. |
| Shift+END |
Select from the insertion point to the end of the entry. |
| Shift END |
Extend selection to the end of a field in Microsoft Excel. |
| Shift+ENTER |
Move from bottom to top within the selected range. |
| Shift+ENTER |
Complete a cell entry and select the previous cell above. |
| Shift+ENTER |
Move to the first field in the previous record. |
| Shift+F10 |
In Help, display a shortcut menu |
| Shift+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.) |
| Shift+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 |
| Shift+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. |
| Shift+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 |
| Shift+F11 or ALT+Shift+F1 |
Insert a new worksheet. |
| Shift F2 |
Edit a cell comment in Microsoft Excel. |
| Shift+F3 |
In a formula, display the Insert Function dialog box. |
| Shift+F4 |
Repeat the last Find action (same as Find Next). |
| Shift+F5 |
Display the Find dialog box. |
| Shift+F6 |
Switch to the previous pane in a worksheet that has been split. |
| Shift+F6 |
Switch to the previous pane in a worksheet that has been split. |
| Shift+F8 |
Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range. |
| Shift+F9 |
Calculate the active worksheet. |
| Shift HOME |
Select from the insertion point to the beginning of the entry in Microsoft Excel. |
| Shift+HOME |
Extend the selection to the beginning of the row. |
| Shift+HOME |
Extend selection to the beginning of a field. |
| Shift+LEFT ARROW |
Select or unselect one character to the left. |
| Shift+LEFT ARROW |
Select the character to the left within a field. |
| Shift+PAGE DOWN |
Extend the selection down one screen. |
| Shift PAGE UP |
Extend the selection up one screen in Microsoft Excel. |
| Shift+RIGHT ARROW |
Select or unselect one character to the right. |
| Shift+RIGHT ARROW |
Select the character to the right within a field. |
| Shift+SPACEBAR |
Select the entire row. |
| Shift+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. |
| Shift+TAB |
Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web article. |
| Shift+TAB |
Move to the previous option or option group. |
| Shift+TAB |
Move from right to left within the selected range. If cells in a single column are selected, move up. |
| Shift TAB |
Complete a cell entry and select the previous cell to the left in Microsoft Excel. |
| Shift+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 Shift+TAB |
Move to each field in the record, then to each command button. |
| TAB or Shift+TAB |
When a toolbar is selected, select the next or previous button or menu on the toolbar. |
| TAB or Shift+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. |
