Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Save and Reuse Tables Do you frequently create the same type of complex table, such as a financial table or tables to use for custom page layouts? If so, you can easily save that table for easy insertion into any document. Just select a completed example of your table and save it to the Quick Tables gallery. Here's how: Select the table and press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, and then in the Gallery list, click Tables. You can set other options as well, such as choosing or creating a category for your table, which will affect where in the Quick Tables gallery it appears. You can also choose an available template in which to store the table. But if you retain the default Save in location, Building Blocks.dotx, your table will be available for you to use in any document. To access your saved table, on the Insert tab, click Table, and then point to Quick Tables. Quick Ways to Create or Populate Lists on a SharePoint List 1. Start Microsoft Office Access and open a database by clicking the New Database icon or selecting an existing database. 2. Create a new list. a. Click Create, click SharePoint lists, and then select whichever list is appropriate. b. Enter the site address of the Microsoft SharePoint site that you want to use, and then give the list a name. 3. Fill in the data on the data entry page, or populate it from another source by using the data import features of Access. 4. Save the content in Access. 5. Go to your SharePoint site, click Lists, select the list you just created, and it will already have been published. • 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