Carol Bratt

You can use the Reading pane to very quickly go through your messages. Follow the steps below: Click the Mail or Folder List button on the Navigation pane and click the Unread Messages search folder. If you cannot see the contents of a message when ... you click its entry in the message list, click the Reading Pane button. Using this pane lets you quickly scan any message without having to open it. Choose Tools | Options. Click the Other tab. Click the Reading Pane button to display the Reading Pane dialog box. Select Mark Item as Read When Selection Changes, to mark mail as read when you view it ... (view more)

Each new Excel workbook starts out with three blank worksheets, and an index tab at the bottom of each worksheet identifies the sheet by name. You can add a new worksheet or delete an existing worksheet and rename or rearrange worksheets to suit ... your whim. A fourth tab is the Insert Worksheet tab. Click it and a new worksheet is created instantly as well as a fifth Insert Worksheet tab that appears just in case you want to keep adding worksheets. In Workbooks with many worksheets, you will not be able to see all the sheet names without using the four arrow buttons to the left of the sheet ... (view more)

Both rows and columns of a worksheet can be outlined or grouped. Outlining provides a way to organize details. Outlines can be collapsed or expanded to hide or show detail within the data list. Once defined, the group of rows or columns can be ... expanded or collapsed to display or hid the detail contained within them. Follow the steps below to group rows or columns in a worksheet: Select the rows or columns to be grouped. Choose Data | Group and Outline | Group. To remove the grouping follow these steps: Select the rows or columns to be ungrouped. Choose Data | Group and Outline | Ungroup. ... (view more)

There can sometimes be situations when it is necessary to add more than one summary function to a list. For example, you may want to present both subtotals and averages for the groups within a data list. To display summary functions follow these ... steps: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Choose Data | Subtotals. The Subtotal dialog box will appear. Specify options for the first subtotal. Choose OK. Choose Data | Subtotals. The Subtotal dialog box will appear again. Specify options for the second subtotal ... (view more)

When automatic subtotals are inserted, Excel outlines the list by grouping detail rows with each associate subtotal row, and grouping subtotal rows with the grand total row. To insert subtotals and grand totals in a data list, follow the ... instructions below: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Select Data | Subtotals. The Subtotal dialog box appears. Select a field by which to group from the At each change in drop-down list. Select a calculation function from the Use function drop-down list. Select the ... (view more)

Format Painter is a multi-step process. You select the text whose format you want to use, then click the Format Painter button. That copies the format to the clipboard and your mouse cursor changes into a vertical line with a paint brush symbol. ... Swipe your mouse across the text you want to apply the format to, and when you release the mouse, the copied format is applied. Follow the steps below to simulate these steps with keyboard shortcuts in Word 2002, 2003, and 2007: Select the text whose format you want to copy. Press Ctrl + Shift + C. Select the text whose format you want to change to ... (view more)

I don't know of a way to build in automatic overflow of text to a new slide in PowerPoint. However, once your presentation is designed, you can split a bullet list between two slides. Follow the steps below to split up a bulleted list in your ... PowerPoint presentation: In Normal view, switch to the Outline tab. Move the insertion point where you want to split the text. Press Enter. For this to work, you must have your AutoCorrect option set properly. From the main menu choose Tools | AutoCorrect Options. In the AutoFormat As You Type tab, find the Apply As You Type section. Un-check the AutoFit ... (view more)

Instead of relying on comments, you can set up the Track Changes feature to enable others to change the text and show what they have added and deleted. When you activate this feature, any added text is displayed underlined and in a different color. ... Any text that is deleted is shown a strikethrough and in a different color. Each person's changes are signified by a different color. Once the changes are made, one person must review them all and decide which changes to make permanent. The Reviewing toolbar has buttons to make this process go quickly. To start the Track Changes feature, choose one ... (view more)

In Office 2007 (c), depending upon which edition you own, you can use Information Rights Management to allow only specified individuals to access a document. Using Information Rights Management, you can assign specific rights to each user, including ... restricting the ability to copy, print, forward, modify, or fact a document. You can even set an expiration date after which a user cannot access the document! To restrict permission to a document, follow the steps below: Click the Microsoft Office button, point to Prepare, Restrict Permission and then click Restricted Access. In the Permission ... (view more)

After you insert a picture and have selected it, you can change it from colored to black and white, adjust the contract or alter the brightness of the image. You can use the toolbar or access the dialog box for more control. To use the mouse, follow ... these steps: To change a picture in one of the following ways, click the Image Control button and select one of the options: Automatic - Restores the picture's original colors. Grayscale - Shades of gray. Black and white - Changes your image to pure black and white. Watermark - Converts the picture to preset levels of brightness and color contrast ... (view more)