Microsoft Excel 2002 Keyboard Shortcuts

 

ALT+' (apostrophe)Display the Style dialog box.
ALT+ the underlined letter in an optnSelect 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+0128Enters the euro symbol.
ALT 0162Enters the cent character in Microsoft Excel
ALT+0163Enters the pound sterling character
ALT+0165Enters the yen symbol
ALT+AIn Help, switch to the Answer Wizard tab.
ALT+AAdds interactivity to the range or sheet being sent.
ALT BApply or remove the bottom border in Microsoft Excel.
ALT+BIf the Bcc box is displayed, opens the Address Book for the Bcc box.
ALT+CIn Help, switch to the Contents tab.
ALT+CMoves the selected field into the Column area.
ALT+COpens the Address Book for the Cc box.
ALT+DApply or remove the downward diagonal border.
ALT+DMoves the selected field into the Data area.
ALT+DOWN ARROWDisplay more Help topics in the Assistant list
ALT DOWN ARROWOpen the selected drop-down list in Microsoft Excel.
ALT+DOWN ARROWDisplay 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 ARROWIn the cell that contains the drop-down arrow, displays the AutoFilter list for the current column.
ALT+DOWN ARROWDisplays the drop-down list for a field in a PivotTable or PivotChart report. Use the arrow keys to select the field.
ALT+E LDelete the current sheet (Edit menu, Delete Sheet command).
ALT+E MMove or copy the current sheet (Edit menu, Move or Copy Sheet command).
ALT+ENTERStart a new line in the same cell.
ALT ENTERStart a new line in the same cell in Microsoft Excel.
ALT+F4In the Help windows, close the Help window
ALT+HIf cells in multiple rows are selected, apply or remove the horizontal divider.
ALT+IIn Help, switch to the Index tab
ALT+JGoes to the Subject box.
ALT+KChecks the names in the To, Cc, and Bcc boxes against the Address Book.
ALT LApply or remove the left border in Microsoft Excel.
ALT+LDisplays the PivotTable Field dialog box for the selected field.
ALT+LEFT ARROWGo to the previous Help topic
ALT+numberSelect a Help topic from the list the Assistant displays. ALT+1 is the first topic, ALT+2 is the second, and so on.
ALT+OIn 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+OOpens the Options menu for access to the Options, Bcc Field, and From Field commands.
ALT+O H RRename the current sheet (Format menu, Sheet submenu, Rename command).
ALT+O, and then press BIn the Help windows, display the previously viewed topic
ALT+O, and then press FIn the Help windows, display the next topic in a previously displayed sequence of topics
ALT O, and then press HIn the Help windows, return to the specified home page in Microsoft Excel
ALT+O, and then press IIn the Help windows, open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings
ALT+O, and then press PIn the Help windows, print all topics in a book or a selected topic only
ALT+O, and then press RIn the Help windows, refresh the topic (useful if you have linked to a Web page)
ALT+O, and then press SIn 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 TIn the Help windows, hide or show the pane with the Contents, Answer Wizard, and Index tabs
ALT PMoves the selected field into the Page area in Microsoft Excel.
ALT+POpens the Outlook Message Options dialog box (Options menu, Options command).
ALT+PAGE DOWNMove one screen to the right.
ALT+PAGE UPMove one screen to the left.
ALT+PERIODOpens the Address Book for the To box.
ALT+PRINT SCREENCopy a picture of the selected window to the Clipboard.
ALT RApply or remove the right border in Microsoft Excel.
ALT+RMoves the selected field into the Row area.
ALT+RIGHT ARROWGo to the next Help topic
ALT+SSends the e-mail message.
ALT+SHFT+DOWN ARROWMoves the pointer from the phonetic guides back to the parent string of characters.
ALT+SHFT+F10Display 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 ARROWUngroups rows or columns in Microsoft Excel.
ALT+SHFT+LEFT ARROWUngroups grouped items in a PivotTable field.
ALT+SHFT+RIGHT ARROWGroups rows or columns.
ALT+SHFT+RIGHT ARROWGroups the selected items in a PivotTable field.
ALT+SHFT+TABSwitch to the previous program.
ALT+SHFT+UP ARROWIn Japanese text for which you've displayed phonetic guides, moves the pointer into the phonetic guides.
ALT+SPACEBARDisplay the Control menu for the Excel window.
ALT+TApply or remove the top border.
ALT+TABSwitch to the next program.
ALT+UApply or remove the upward diagonal border.
ALT+UP ARROWDisplay previous Help topics in the Assistant list
ALT UP ARROWCloses the AutoFilter list for the current column in Microsoft Excel.
ALT+VIf cells in multiple columns are selected, apply or remove the vertical divider.
ALT+XPressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character.
Arrow keysMove between options in an open drop-down list, or between options in a group of options.
Arrow keysMove around the page when zoomed in.
Arrow keysMove one cell up, down, left, or right.
Arrow keysMove one character up, down, left, or right in Microsoft Excel.
BACKSPACEIn the Formula Bar, delete one character to the left.
BACKSPACEEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents.
CTRLSwitches 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+1Display the Format Cells dialog box.
CTRL+5Apply or remove strikethrough.
CTRL+6Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7Show or hide the Standard toolbar.
CTRL+8Displays or hides the outline symbols.
CTRL+9Hide the selected rows.
CTRL+9Hides the selected rows.
CTRL+ASelect the entire Help topic
CTRL+ASelect the entire worksheet.
CTRL+AWhen the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+ALT+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL ALT LEFT ARROWSwitch to the next nonadjacent selection to the left in Microsoft Excel.
CTRL+ALT+RIGHT ARROWIn nonadjacent selections, switch to the next selection to the right.
CTRL+ALT+SHFT+F9Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+arrow keyMove 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+BApply or remove bold formatting.
CTRL+BACKSPACEScroll to display the active cell.
CTRL+CCopy the selected items to the Clipboard
CTRL+CCopy the selected cells.
CTRL+C, immediately followed by another CTRL+CDisplay the Microsoft Office Clipboard (multiple copy and paste).
CTRL+DFill down.
CTRL DELETEDelete text to the end of the line in Microsoft Excel.
CTRL+DOWN ARROWDisplay the full set of commands on the task pane menu
CTRL+DOWN ARROWDisplay the full set of commands on a menu.
CTRL+DOWN ARROW or CTRL+RIGHT ARROWMove to the last page when zoomed out.
CTRL+ENDMove to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
CTRL+ENTERFill the selected cell range with the current entry.
CTRL+ESCDisplay the Windows Start menu.
CTRL F10Maximize or restore the selected workbook window in Microsoft Excel.
CTRL+F3Define a name.
CTRL+F5Restore the window size of the selected workbook window.
CTRL+F6When more than one workbook window is open, switch to the next workbook window.
CTRL+F7When 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+F8When 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+F9Minimize a workbook window to an icon.
CTRL HOMEMove to the beginning of the worksheet in Microsoft Excel.
CTRL+HOME or CTRL+ENDMove to the top or bottom of the selected gallery list
CTRL+HYPHENDelete the selected cells.
CTRL+IApply or remove italic formatting.
CTRL+KInsert 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 ARROWMove one word to the left.
CTRL+LEFT SHFTSwitches to left-to-right paragraph direction (the text must contain only neutral characters).
CTRL PPrint the current Help topic in Microsoft Excel
CTRL+P or CTRL+SHFT+F12Display the Print dialog box.
CTRL+PAGE DOWNMove to the next sheet in the workbook.
CTRL+PAGE DOWNStart a new, blank record.
CTRL+PAGE DOWNSelects a chart sheet: selects the next sheet in the workbook, until the chart sheet you want is selected.
CTRL+PAGE UPMove to the previous sheet in the workbook.
CTRL PAGE UPMove to the first record in Microsoft Excel.
CTRL+PAGE UPSelects a chart sheet: selects the previous sheet in the workbook, until the chart sheet you want is selected.
CTRL+PERIODMove clockwise to the next corner of the selected range.
CTRL+RFill to the right.
CTRL+RIGHT ARROWMove one word to the right.
CTRL+RIGHT SHFTSwitches 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+AWhen the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
CTRL+SHFT+arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell.
CTRL+SHFT+BOpens the Address Book.
CTRL+SHFT+ENDExtend the selection to the last used cell on the worksheet (lower-right corner).
CTRL+SHFT+ENTEREnter 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+F3Create 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+F6Switch to the previous workbook window.
CTRL SHFT GCreates a message flag in Microsoft Excel.
CTRL+SHFT+HOMEExtend the selection to the beginning of the worksheet.
CTRL+SHFT+LEFT ARROWSelect or unselect one word to the left.
CTRL+SHFT+O (the letter O)Select all cells that contain comments.
CTRL SHFT PLUS SIGNInsert blank cells in Microsoft Excel.
CTRL+SHFT+RIGHT ARROWSelect or unselect one word to the right.
CTRL+SHFT+SPACEBARWith an object selected, select all objects on a sheet.
CTRL+SHFT+TAB or CTRL+PAGE UPSwitch to the previous tab in a dialog box.
CTRL+SHFT+ZWhen the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.
CTRL SPACEBARSelect the entire column in Microsoft Excel.
CTRL+TABIn Help, switch to the next tab
CTRL+TABWhen 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 DOWNSwitch to the next tab in a dialog box.
CTRL+TAB or CTRL+SHFT+TABWhen a toolbar is selected, select the next or previous toolbar.
CTRL+UApply or remove underlining.
CTRL+UP ARROW or CTRL+LEFT ARROWMove to the first page when zoomed out.
CTRL+VPaste copied cells.
CTRL+W or CTRL+F4Close the selected workbook window.
CTRL+XCut the selected cells.
CTRL ZUndo the last action in Microsoft Excel.
CTRL+ZUndo the last action.
DELETEDelete the character to the right of the insertion point, or delete the selection.
DELETEClear the contents of the selected cells.
DOWN ARROWIn Help, select the next book or Help topic
DOWN ARROWSelect the next item in a smart tag menu.
DOWN ARROWMove to the same field in the next record.
DOWN ARROWSelects the next item in the AutoFilter list.
DOWN ARROWSelects the next item in the list in Microsoft Excel.
DOWN ARROWSelect the previous group of elements in a chart.
DOWN ARROW or UP ARROWMove among choices in a selected submenu; move among certain options in a group of options
DOWN ARROW or UP ARROWWhen a menu or submenu is open, select the next or previous command.
ENDMove to the end of the entry.
ENDMove to the cell in the lower-right corner of the window.
ENDSelects the last item in the AutoFilter list.
ENDSelects the last visible item in the list.
END keyTurn End mode on or off in Microsoft Excel.
END+arrow keyMove by one block of data within a row or column.
END+ENTERMove 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+HOMEMove to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
END+SHFT+arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell.
END+SHFT+ENTERExtend 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+HOMEExtend the selection to the last used cell on the worksheet (lower-right corner).
ENTERIn the Help windows, perform the action for the selected Show All, Hide All, hidden text, or hyperlink
ENTERIn Help, open a selected book or Help topic in Microsoft Excel
ENTERPerform the action for the selected Show All, Hide All, hidden text, or hyperlink
ENTERPerform the action for the selected item in a smart tag menu.
ENTEROpen the selected menu, or perform the action for the selected button or command.
ENTERPerform the action for the default command button in the dialog box (the button with the bold outline, often the OK button).
ENTERMove from top to bottom within the selected range in Microsoft Excel.
ENTERComplete a cell entry and select the cell below.
ENTERComplete a cell entry from the cell or Formula Bar.
ENTERComplete a cell entry and select the next cell below.
ENTERMove to the first field in the next record.
ENTERFilters the list based on the item selected from the AutoFilter list.
ENTERCloses the list and displays the selected items.
ENTER (in a cell with a hyperlink)Activate a hyperlink in Microsoft Excel.
ESCClose an Assistant message or a tip
ESCClose the smart tag menu or message.
ESCClose an open menu. When a submenu is open, close only the submenu.
ESCCancel the command and close the dialog box.
ESCCancel a cell entry.
ESCCancel an entry in the cell or Formula Bar.
ESCCancel a cell entry in Microsoft Excel
ESCStops reading when text is being read aloud.
F1Display the Assistant balloon (if the Assistant is turned off, F1 opens the Help window)
F1Display the Help window if the Assistant is turned off (if the Assistant is turned on, F1 displays the Assistant balloon).
F10 or ALTSelect 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+F1Creates a chart of the data in the current range.
F2Move the insertion point into the Formula Bar when editing in a cell is turned off.
F2Edit the active cell and position the insertion point at the end of the cell contents.
F3Paste 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+IOpen the Look in list
F4 or CTRL YRepeat the last action in Microsoft Excel.
F5Refresh the file list
F5Display the Go To dialog box.
F6In 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. )
F6Switch to the next pane in a worksheet that has been split (Window menu, Split command).
F6Move 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.)
F6Switch to the next pane in a worksheet that has been split (Window menu, Split command).
F7Display the Spelling dialog box in Microsoft Excel.
F8Turn 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 listOpen the list if it is closed and move to that option in the list.
HOMEMove to the beginning of the entry.
HOMEMove to the beginning of the row.
HOMEMove to the cell in the upper-left corner of the window.
HOMEMove to the beginning of the line.
HOMESelects the first item (All) in the AutoFilter list.
HOMESelects the first visible item in the list.
HOME or ENDGo to the beginning or end of a Help topic in Microsoft Excel
HOME or ENDSelect the first or last command on the menu or submenu.
HOME or ENDMove to the beginning or end of a field.
HOME or ENDWhen a menu or submenu is visible, select the first or last command on the menu or submenu
LEFT ARROWFor an item that has lower-level items displayed, hides the lower-level items.
LEFT ARROWSelects the previous element within a group.
LEFT ARROW or RIGHT ARROWSelect the menu to the left or right. When a submenu is open, switch between the main menu and the submenu.
LEFT ARROW or RIGHT ARROWMove one character to the left or right.
LEFT ARROW or RIGHT ARROWScroll one column left or right in Microsoft Excel.
LEFT ARROW or RIGHT ARROWMove one character left or right within a field.
LEFT ARROW or RIGHT ARROWWith two or more columns of field buttons, selects the button to the left or right.
NUM LOCK, ALT+numeric pad numbersEnter a unicode character.
PAGE DOWNMove down one screen.
PAGE DOWNMove to the same field 10 records forward.
PAGE UPMove up one screen.
PAGE UPMove to the same field 10 records back.
PAGE UP or PAGE DOWNScroll toward the beginning or end of a Help topic in large increments
PAGE UP or PAGE DOWNScroll up or down in the selected gallery list
PAGE UP or PAGE DOWNMove by one page when zoomed out.
PRTSCRCopy a picture of the screen to the Clipboard.
RIGHT ARROWFor an item that has lower-level items available, displays the lower-level items.
RIGHT ARROWSelects the next element within a group in Microsoft Excel.
SCROLL LOCKTurn SCROLL LOCK on or off.
SCROLL LOCK+SHFT+ENDExtend the selection to the cell in the lower-right corner of the window.
SCROLL LOCK+SHFT+HOMEExtend the selection to the cell in the upper-left corner of the window.
SHFT+arrow keyExtend the selection by one cell.
SHFT+BACKSPACEWith multiple cells selected, select only the active cell.
SHFT+CTRL+PAGE DOWNSelect 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 UPSelect the current and previous sheet.
SHFT+ENDSelect from the insertion point to the end of the entry.
SHFT ENDExtend selection to the end of a field in Microsoft Excel.
SHFT+ENTERMove from bottom to top within the selected range.
SHFT+ENTERComplete a cell entry and select the previous cell above.
SHFT+ENTERMove to the first field in the previous record.
SHFT+F10In Help, display a shortcut menu
SHFT+F10Display 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+F10Open 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+F10Display 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+F10Display 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+F1Insert a new worksheet.
SHFT F2Edit a cell comment in Microsoft Excel.
SHFT+F3In a formula, display the Insert Function dialog box.
SHFT+F4Repeat the last Find action (same as Find Next).
SHFT+F5Display the Find dialog box.
SHFT+F6Switch to the previous pane in a worksheet that has been split.
SHFT+F6Switch to the previous pane in a worksheet that has been split.
SHFT+F8Add 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+F9Calculate the active worksheet.
SHFT HOMESelect from the insertion point to the beginning of the entry in Microsoft Excel.
SHFT+HOMEExtend the selection to the beginning of the row.
SHFT+HOMEExtend selection to the beginning of a field.
SHFT+LEFT ARROWSelect or unselect one character to the left.
SHFT+LEFT ARROWSelect the character to the left within a field.
SHFT+PAGE DOWNExtend the selection down one screen.
SHFT PAGE UPExtend the selection up one screen in Microsoft Excel.
SHFT+RIGHT ARROWSelect or unselect one character to the right.
SHFT+RIGHT ARROWSelect the character to the right within a field.
SHFT+SPACEBARSelect the entire row.
SHFT+TABIn 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+TABSelect the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web article.
SHFT+TABMove to the previous option or option group.
SHFT+TABMove from right to left within the selected range. If cells in a single column are selected, move up.
SHFT TABComplete a cell entry and select the previous cell to the left in Microsoft Excel.
SHFT+TABWhen 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.
SPACEBARPerform the action for the selected button, or select or clear the selected check box.
SPACEBARChecks, 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 ENTEROpen the selected menu, or perform the action assigned to the selected button
SPACEBAR, with the Help button selectedShow 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.
TABMove to the Help button in a wizard
TABIn the Help windows, select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic.
TABSelect the next hidden text or hyperlink, or Show All or Hide All at the top of a topic.
TABMove to the next option or option group in Microsoft Excel.
TABMove between options or areas in the dialog box
TABMove between unlocked cells on a protected worksheet.
TABMove from left to right within the selected range. If cells in a single column are selected, move down.
TABComplete a cell entry and select the next cell to the right.
TABSwitches between the list, the OK button, and the Cancel button.
TAB and SHFT+TABMove to each field in the record, then to each command button.
TAB or SHFT+TABWhen a toolbar is selected, select the next or previous button or menu on the toolbar.
TAB or SHFT+TABWhen a task pane is active, select the next or previous option in the task pane
UP ARROWIn Help, select the previous book or Help topic in Microsoft Excel
UP ARROWSelect the previous item in a smart tag menu.
UP ARROWMove to the same field in the previous record.
UP ARROWSelects the previous item in the AutoFilter list.
UP ARROWSelects the previous item in the list.
UP ARROWSelects the next group of elements in a chart in Microsoft Excel.
UP ARROW or DOWN ARROWScroll toward the beginning or end of a Help topic
UP ARROW or DOWN ARROWScroll one row up or down.
UP ARROW or DOWN ARROWSelects the previous or next field button in the list on the right.

 

comments powered by Disqus