Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Automatically Update Data (Such as User Information) Throughout Your Document Content controls, a new feature in Microsoft Office Word 2007, provide the ability to structure content in a document—similar to, but with more flexibility than, traditional form controls. Among other uses, content controls enable you to bind text in your document to data sources, such as file properties or Windows SharePoint Services properties. In fact, some built-in content controls called Document Property Quick Parts are set to automatically bind to your information. As a result, if you insert a Document Property Quick Part—such as the author name or the document title—into your document, that information will automatically update in the document when it changes in file properties. To insert a Document Property Quick Part into your document, on the Insert tab, in the Text group, click Quick Parts, point to Document Property, and then click to insert the type of property you need from the options listed. Note that if you insert several of the same type of control (such as Title) in the same document, the text in all of those controls will update to match if any one of them is changed. Also note that some types of document building blocks (such as a cover page or a header that you can insert from applicable galleries on the Insert tab) contain Document Property Quick Parts. Sorting and Filtering New options for sorting and filtering make Microsoft Office Excel 2007 the ideal tool for working with large amounts of complex data. The sorting and filtering menu is sensitive to the type of data you're working with. To sort and filter: 1. To enable filter and sort options, do one of the following: a. Format your data range as a table. b. Select the headings of the columns that you want to sort or filter. c. On the Ribbon, on the Home tab, in the Editing group, click Sort and Filter. 2. To sort, click the AutoFilter arrow in the column heading, and then select the filter mode (in Office Excel 2007, you can also filter by cell color). 3. To filter, click the AutoFilter arrow in the column heading. a. Select individual values, and then select the filter mode. b. Select Number Filters, Text Filters, or Date Filters for more advanced filter options. • 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