Excel Reference
(Page 1 of 6 )
If you work with Excel 2007, keep reading. This article will show you where to find all sorts of useful Excel commands, navigational shortcuts, and much more. It is excerpted from chapter four of the
Excel 2007 Pocket Guide, Second Edition, written by Curtis Frye (O'Reilly; ISBN: 0596514522). Copyright © 2007 O'Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O'Reilly Media.
This chapter provides reference information that is hidden within Excel, including:
Useful Excel commands that are not on any toolbar or menu by default (Table 4-1)
Native data and graphic file formats (Tables 4-2 and 4-3)
Startup switches to control how Excel launches (Table 4-4)
Wildcard characters used in Excel searches and filters (Table 4-5)
Default locations of important files and folders (Table 4-6)
This chapter also lists default keyboard shortcuts for the following types of tasks:
General program and navigational shortcuts (Tables 4-7 and 4-8)
Data entry and formatting (Tables 4-9 through 4-13)
Manipulating shortcut menus (Table 4-14)
Creating and manipulating charts (Table 4-15)
Working with macros (Table 4-16)
Displaying and hiding items in a PivotTable (Table 4-17)
Using Smart Tags (Table 4-18)
Command Reference There are hundreds of commands available in Excel 2007; there wasn’t room for them all on the Ribbon. Table 4-1 lists some of the useful commands that you can find in the “Commands Not in the Ribbon” list in the Excel Options dialog box’s Customize page. (To display that list, click Office Button -> Excel Options -> Customize. Click the “Choose commands from” down arrow, and click “Commands Not in the Ribbon”.) You can use the techniques in Chapter 2 to make these commands available. You can find any others in Help.
Table 4-1. Useful Excel commands
| Command | Action | Suggested uses |
|---|
| Publish As Web Page | Displays the Publish dialog box accessed from the Save As Web Page dialog box. | Add button to the Quick Access Toolbar to facilitate publishing worksheets to the Web. |
| Web Page Preview | Displays the worksheet as if it were a web page. | Add button to the Quick Access Toolbar to facilitate publishing worksheets to the Web. |
| Select Visible Cells | Selects only the visible cells (those not hidden by a filter). | Add button to the Quick Access Toolbar to avoid selecting hidden cells. |
| Constrain Numeric | Requires users to enter numbers into the selected cells. | Add to the Quick Access Toolbar when setting data validation rules. |
| Cycle Font Color | Change cell text to the next color in the Font Color palette. | Add to the Quick Access Toolbar. |
| Scenario | Displays a list of scenarios available for the active worksheet. | Add list box to the Quick Access Toolbar for use in presentations. |
| Lighting | Changes the lighting sources and characteristics for objects on a worksheet. | Add button to the Quick Access Toolbar when you edit drawing objects. |
| Calculator | Displays the Windows calculator for quick calculations. | Add button to the Quick Access Toolbar for calculations that don’t involve data in the worksheet. |
| Close All | Closes all open workbooks but does not exit Excel. | Add button to the Quick Access Toolbar if you work with lots of workbooks at a time. |
| New | Creates a new workbook without displaying the New Workbook dialog box. | Add button to the Quick Access Toolbar to create new workbooks quickly. |
Next: Native Formats >>
More Database Articles
More By O'Reilly Media
|
 This article is excerpted from chapter four of the Excel 2007 Pocket Guide, Second Edition, written by Curtis Frye (O'Reilly; ISBN: 0596514522). Copyright © 2007 O'Reilly Media, Inc. Check it out today at your favorite bookstore. Buy this book now.
|
|
