Monday, March 9, 2009

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Windows Vista
Windows Vista
Changing File Properties
File properties or metadata can be very useful in labeling, organizing, and subsequently finding your files. Most programs add their own properties when saved; however, with Windows Vista, you can augment these attributes.
1. Click Organize, click Layout, and then click Details Pane (if necessary; you should see the details pane by default at the bottom of the Explorer).
2. Expand the details pane (click and drag the separator above the pane to resize).
3. Select the attribute that you want to change, and enter any information that you want to add.


.
For Microsoft Office Excel 2007
Convert Text to Tables
Sometimes you may find different types of information within the same piece of text, where the only thing separating the information is a space. Microsoft Office Excel makes it easy to redistribute this data by using different columns, and to display the data in a more digestible format.

1. Choose delimiters and column separators.
a. Select the cells containing the data that you want to separate.
b. On the Data ribbon, in the Data Tools section, click the Text to Columns button.
c. Select your preferred data type (that is, Delimited or Fixed width) from the options in the first step presented by the wizard.
d. In the second step of the wizard, select your preferred delimiters from the Delimiters options, or the column separator position from the Fixed width options.

2. Define the data format of your new columns.
a. In the dialog box of the wizard's third step, select one column at a time and define its data format by clicking your preferred option under Column data format.
b. Click the Finish button. The text chains will now be distributed into columns according to your chosen data format.

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
© 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)