Tips and Tricks - October 27
Finding Words on a Web Page
Customizing the Quick Access Toolbar in Office 2007
Filtering in Excel 2007
Add Slide Numbers in PowerPoint 2007
Empty Deleted Items Folder When Exiting Outlook 2007
Turn Off Full Screen Reading View in Word 2007
Did you know that you can quickly and easily find certain words on a Web page without having to read the entire page? Here's how:
- On the Web page you wish to search, press "Ctrl + F" on your keyboard.
- A small toolbar window will appear on the page. In the toolbar window's "Find" box, enter the word or phrase you wish to search for. If the word or phrase is present on the page, all occurrences will be automatically highlighted.
- Press the "Enter" key or click on the "Next" or "Previous" button to search for other instances of the word on the page.
- If your search doesn't return any results, the text "No matches found" (in Internet Explorer) or "Phrase not found" (in Firefox) will appear in the window.
- To find other words or phrases, just delete the existing term from the search box and enter your new search term.
In Microsoft Office 2007's Word, Excel, and PowerPoint, the title bar contains a set of icons known as the "Quick Access Toolbar." If unchanged, it will contain three default icons: Save, Undo, and Redo. All of these will be displayed as long as they are active selections for the current file.
To customize the Quick Access Toolbar:
- Click the small arrow to the right of the toolbar, and then click "More Commands" to view a configuration form.
- Select the command that you want to add to the toolbar and click the "Add" button. To move the command up or down in the list, click the "Move Up" or "Move Down" arrows. You can also specify whether the command menu appears just for the current document or as the default for all documents by selecting the appropriate choice in the "Customize Quick Access Toolbar" drop-down menu.
- When you are finished, click "OK."
Filtering can be a handy alternative to sorting in Excel. It allows you to selectively block out data that you don't want to see.
To filter, first select the cells you would like to filter (including the header row), click on the "Data" tab, and click the "Filter" button.
You can then click on the down arrows next to each column heading to sort by that column. For instance, if one of the columns is a date column, you can sort from oldest to newest, or from newest to oldest. If another column contains text, you can sort from A to Z or Z to A. Based on the type of data in the column, you can also choose to sort by color, apply custom filters, or apply built-in filters.
PowerPoint can automatically add numbers to each slide in your presentation. Slide numbers provide a handy reference for both the presenter and the audience, and they will update automatically if you rearrange the order of the slides. To add slide numbers to your presentation:
- 1. On the Insert tab, in the Text group, select "Header & Footer."
- In the "Slide" tab, check the box next to "Slide number." Most presentations do not show a slide number on the title slide, so you might want to check the box next to "Don't show on title slide" at the bottom of the screen.
- Click "Apply" or "Apply to All."
- Slide numbers will now appear in the bottom right-hand corner of the slide(s).
Depending on the number of items you delete (including emails, tasks, notes, and other items), the contents of your "Deleted Items" folder can multiply rapidly, taking up unnecessary hard drive space. If you forget to purge its contents, you can have Outlook 2007 do so for you automatically when you exit the program:
- From the "Tools" menu, select "Options."
- Click the "Other" tab.
- Under the "General" heading, check the box next to "Empty the Deleted Items folder upon exiting."
- "OK" to close the dialog box.
"Review" toolbar, making it easy to add comments and track changes.
However, Full Screen Reading View is not a print preview of the document. It is not recommended for viewing documents with complex formatting because elements such as graphical text and text in tables are not resized for the screen.
If you want to turn off Full Screen Reading View for email attachments, you can disable it by following these steps:
- Click the Office button in the upper left-hand corner of Word 2007.
- Select the "Word Options" button.
- Select "Popular" in the left-hand pane.
- Uncheck the box next to "Open e-mail attachments in Full Screen Reading view."