Sunday, November 16, 2008

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Microsoft Office Word 2007
Microsoft Office Word 2007
Smarter Navigation in Word
You may already know that in Microsoft Office Word, the up-and-down double arrows below the vertical scroll bar will page up and down through an open document. But you might not know that you can use the Select Browse Object button (the little dot) below the vertical scroll bar to change the function of the double-arrow buttons and of the CTRL+PAGE UP and CTRL+PAGE DOWN keyboard shortcuts. You can, for example, choose to browse by heading, which means the buttons will automatically move the cursor up or down to the next heading. Other choices include browsing by footnote, endnote, comment, graphic, or table.


.
For Microsoft Office Excel 2007
Apply a Sum or Other Function to Every Row in a Data Range in One Step
When you format a data range as a table in Microsoft Office Excel 2007, you can add a calculated column—a column of functions (such as sums or averages)—in just one step. To convert a data range to an Excel 2007 table, click in the range, and then on the Home tab, in the Styles section, click Format as Table, and then click to apply a table style.

When your range is formatted as a table, click in a cell of any empty table column, or a cell in the column directly to the right of the table, on any data row. Then in just that cell, add the function or formula you need. (For example, sum all data on that row of the table.) When you press ENTER to apply your formula in that cell, the entire table column is populated with the same formula, adjusted for each applicable data row. If your insertion point was in the column to the right of the table, Excel formats that column to become part of the table when it generates the calculated column.

Microsoft Office Excel 2007

Quick Links
Tips and Tricks Web site
Microsoft Office Online
Help
Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery.

To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site.

Legal information

Microsoft Corporation
One Microsoft Way
Redmond, WA 98052
Sign up for other newsletters | Unsubscribe | Update your profile
© 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement
Microsoft

Your cOmment"s Here! Hover Your cUrsOr to leave a cOmment.


Subscribe to: Post Comments (Atom)