Excel 2007 for Dummies Quick Reference P2

You can change the theme in a workbook by clicking the Themes button in the Ribbon’s Page Layout tab and selecting a new theme from the gallery that appears.Remember: The three Microsoft Office applications — Excel 2007, Word 2007, and PowerPoint 2007 — share the same themes. If you create reports that combine elements from each application, your reports will have a consistent look if you use a common theme.
Nội dung trích xuất từ tài liệu:
Excel 2007 for Dummies Quick Reference P2 Formatting with Themes — Soliciting Help 17 You can change the theme in a workbook by clicking the Themes button in the Ribbon’s Page Layout tab and selecting a new theme from the gallery that appears. Remember: The three Microsoft Office applications — Excel 2007, Word 2007, and PowerPoint 2007 — share the same themes. If you create reports that combine elements from each application, your reports will have a consistent look if you use a common theme.Soliciting Help With so many features and options available in Excel, it isn’t unusual to get stuck once in a while. Fortunately, Excel provides the following methods for get- ting help easily: Enhanced ScreenTips: Standard ScreenTips (also called ToolTips) have been available in Excel for some time and provide textual context to commands. After you hover your mouse pointer over a command in earlier versions of Excel, Excel displays the action of the command using either a single word (such as Paste) or a brief phrase (such as Increase Font Size). A standard ScreenTip helps to decipher the meaning of a command button, for example, when the button has no associated text and the command meaning is unclear from the button icon. Enhanced ScreenTips take the concept a step further by adding a short description explaining the purpose of the command (hence the prefix Enhanced). Some Enhanced ScreenTips include an explanatory graphic when a text description is insufficient to explain the meaning of the com- mand. Enhanced ScreenTips are available for all commands on the Ribbon. In many cases, the ScreenTip explanation provides enough information, so you don’t have to seek additional help. By default, Excel 2007 uses Enhanced ScreenTips for all commands. Contextual help: If the Enhanced ScreenTip doesn’t offer enough for you to understand the use of a specific command, you can get more detailed help. After you hover the mouse pointer over the command, the Enhanced ScreenTip that pops up lets you know whether additional help for the com- mand is available by indicating that you can press F1 for more help. If you are in a dialog box and need help for the dialog box options, press the help button (the question mark) to get contextual help. General help: Click the help button (the question mark) on the right side of the Ribbon or press F1 when you are not in a specific context (for exam- ple, the mouse pointer is not hovering over a command in the Ribbon) to display a list of general help topics.18 Part 1: Getting to Know Excel 2007 When you use contextual help or general help, Excel displays the help viewer, shown in Figure 1-9. The viewer sports Internet browser-style controls. In fact, it was built using the same technology that Microsoft uses in its Internet Explorer browser application. Of course, the viewer is not a full-fledged browser because you can view only Excel help content. Search box Home Print Refresh Text size Stop TOC Forward Go (search) Maximize/Restore Back Pin Search scope Minimize CloseFigure 1-9 Status bar Connection status Search result window Soliciting Help 19The major features of the help viewer follow: Search box: You can enter specific search text in this box. The viewer stores a list of your text searches for the current help session. Click the drop-down arrow on the side of the box to view and select an item from the list if you want to review a previous search result. Search button: Click the Search button (or press Enter) to initiate a search after you enter the search text in the search box. Click the arrow next to the search button to define the search scope. By default, if your computer is connected to the Internet, Excel will display help content from an online source. If possible, you should use this source as your first choice because Microsoft updates the contents of online help regularly. If you are offline when you initiate a search, Excel uses help content inter- nal to your system. You can force Excel to use internal help content always by clicking the arrow next to the Search button and choosing Offline Excel Help from the menu. Whether online or offline, you can narrow you search scope further by selecting an appropriate option from the Search button menu. Search result window: This window displays the results of your search request. If you use contextual help or enter text in the search box, the window displays help information specific to the context of the search. If you use general help, the window displays a list of general help topics in the form of titled links. Clicking a link displays a new set of links with more specific titles. Click the specific link title that best matches your search cri- terion to display detailed information on the topic. Status bar: The left side of the status bar (located at the bottom of the help viewer) displays the current search scope. The right side of the status bar displays the connection s ...