Wednesday, May 13, 2009

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Microsoft Office Excel 2007
Microsoft Office Excel 2007
Customize the Appearance of Conditional Formats Such as Data Bars, Color Scales, and Icon Sets
When you need conditional formatting in your Microsoft Office Excel 2007 worksheet, try one of the new data visualization options, including color scales, icon sets, and data bars. You can apply these formats with just a click from galleries of preset options, or customize your own conditional formatting rules.

To access the new conditional formats, on the Home tab, in the Styles section, click Conditional Formatting, and then point to Data Bars, Color Scales, or Icon Sets. Or to create a custom rule for one of these formats, at the bottom of the Conditional Formatting menu, click New Rule. In the New Formatting Rule dialog box, select the rule type Format all cells based on their values to use the new data visualization tools. In the lower half of the box, you can then choose among data bars, color scales, and icon sets; specify conditions for each formatting type; and customize colors for data bars or color scales.

Note: In Excel 2007, it's also possible to edit existing conditional formatting rules. To access existing rules for editing, at the bottom of the Conditional Formatting menu, click Manage Rules.


.
For Microsoft Office Groove 2007
Synchronizing Your Own Computers
If you have multiple computers, you can set up your Microsoft Office Groove 2007 account on each of them to keep a synchronized copy of key workspaces and files on each computer.

1. From the File menu, click Use Account on Another Computer, and then save the account file to your desktop by clicking OK in the dialog box.
2. Transfer the account file to a second computer through an e-mail attachment or a removable storage device.
3. On the second computer, install Groove 2007. In the Account Configuration Wizard, click Use a Groove Account you have already created, and follow the instructions to select your saved account file.
4. Your workspaces will appear in the Launchbar labeled as Not on this computer. Double-click each workspace to download it from your other computer.

Note: Your Groove administrator may have set policies for your account that restrict you from adding it to other computers.

Microsoft Office Groove 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
© 2009 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)