Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Format Several Graphics from One Dialog Box When you format graphics (such as a SmartArt diagram, an Excel chart, or a picture) in the 2007 Microsoft Office programs Word, Excel, and PowerPoint, the Ribbon provides most of the formatting options you need. But when you need to open a dialog box to see more options, you may notice that many of the formatting dialog boxes have changed. One of the most helpful changes is that you can now click between the dialog box and your document without closing and reopening the dialog box. Even if you change your graphic selection to a different type of content (such as selecting a chart axis and then a chart data series), the dialog box automatically changes to accommodate your selection. To open a formatting dialog box for the type of graphic you've selected, click the dialog launch icon in the lower-right corner of a tab section. (For example, clicking that icon in the Picture Styles section on the Picture Tools Format tab in Word opens the Format Picture dialog box.) Then click between the dialog box and document as needed. 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 address of the 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 you'll see that it has already 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