Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Turn Your Data Range into a Table for Easy Data Management and Formatting The new tables functionality in Microsoft Office Excel 2007 provides options for formatting and managing your data more easily and dynamically than ever before. To convert a data range to a table: 1. Click anywhere in the range. 2. On the Home tab, in the Styles section, click Format as Table. 3. Click to apply a table style. The Format as Table dialog box appears, where you can confirm the data range and indicate whether your range contains headers. Click OK in this dialog box to convert the range to a table and apply selected formatting. Notice that table headers automatically contain AutoFilter arrows. Additionally, when you click into a table, the Table Tools Design tab becomes available, from which you can edit the table style, add options such as banded columns or a total row, and perform other data management tasks. Add Automatic Captions Follow these steps to add captions to your tables, figures, and graphics automatically in Microsoft Office Word 2007: 1. On the References tab, in the Captions section, click Insert Caption. 2. Click AutoCaption. 3. Select what you want to insert from the Add caption when inserting list. 4. In the Options section of the AutoCaption dialog box, choose the display options that you want to use. 5. Click OK twice. • 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