In the Help windows, hide or show the pane with the Contents, Answer Wizard, and Index tabs In the Help windows, stop the Help window from opening a Help topic (useful if you want to stop a Web page from downloading) In the Help windows, refresh the topic (useful if you have linked to a Web page) In the Help windows, print all topics in a book or a selected topic only In the Help windows, open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings
In the Help windows, return to the specified home page in Microsoft Excel In the Help windows, display the next topic in a previously displayed sequence of topics In the Help windows, display the previously viewed topic Rename the current sheet (Format menu, Sheet submenu, Rename command).
Opens the Options menu for access to the Options, Bcc Field, and From Field commands. To see more buttons, click Toolbar Options at the end of the toolbar.) command. To display a toolbar, use the Customize dialog box (point to Toolbars on the View menu and click Customize). 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. ALT+1 is the first topic, ALT+2 is the second, and so on. Select a Help topic from the list the Assistant displays. If cells in multiple rows are selected, apply or remove the horizontal divider.Ĭhecks the names in the To, Cc, and Bcc boxes against the Address Book.Īpply or remove the left border in Microsoft Excel.ĭisplays the PivotTable Field dialog box for the selected field. In the Help windows, close the Help window Start a new line in the same cell in Microsoft Excel. Move or copy the current sheet (Edit menu, Move or Copy Sheet command). Use the arrow keys to select the field.ĭelete the current sheet (Edit menu, Delete Sheet command). In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column.ĭisplays the drop-down list for a field in a PivotTable or PivotChart report. The first row of the list has labels for the columns.).
MICROSOFT EXCEL KEYBOARD SHORTCUTS PRINTABLE SERIES
Open the selected drop-down list in Microsoft Excel.ĭisplay 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.
Moves the selected field into the Data area.ĭisplay more Help topics in the Assistant list Moves the selected field into the Column area.Īpply or remove the downward diagonal border. If the Bcc box is displayed, opens the Address Book for the Bcc box. In Help, switch to the Answer Wizard tab.Īdds interactivity to the range or sheet being sent.Īpply or remove the bottom border in Microsoft Excel. Insert an AutoSum formula with the SUM function.Įnters the cent character in Microsoft Excel Select the visible cells in the current selection. Select an option, or select or clear a check box. Microsoft Excel 2002 Keyboard Shortcuts - printable cheatsheet Microsoft Excel 2002 Keyboard Shortcuts