Wednesday, September 10, 2008

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
View All the Text in Your Columns
In Microsoft Office Excel, you can resize multiple columns to different widths so that you can see all the text in your spreadsheet.

1. Select the columns where your text appears by clicking the column headings. Select multiple columns if necessary.
2. To resize the columns to fit, double-click in the column heading, exactly on top of the border that divides any of the two columns you selected.

All of your selected columns are resized based on the longest text string in each column. In this way, a large and confusing spreadsheet with lots of text that you can't see is converted into a legible spreadsheet with all text showing.


.
For Microsoft Office SharePoint Server 2007
Sort Documents in SharePoint Libraries
You can change the default settings of your My SharePoint document libraries to sort by latest upload. You can then see at a glance what's changed and what's new.

1. Open your Microsoft SharePoint document library, and click Modify settings and columns under Actions in the task pane.
2. Under Views, click All Documents.
3. On the Edit View page, find the Sort section.
4. On the First sort by the column menu, click either Modified or Created, depending on whether documents will be uploaded once or changed and then uploaded again.
5. Select the Show items in descending order check box, and then click OK.

Microsoft Office SharePoint Server 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)