Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile 2003 to 2007 Excel Services Microsoft Office Excel 2003 lists are called tables in Microsoft Office Excel 2007. Just as you can convert a data range to a list in Excel 2003, you can format a data range as a table in Excel 2007 by using the Format as Table command in the Styles section of the Home tab. Excel 2003 lists can be published to Windows SharePoint Services 2.0 sites and viewed in Windows Internet Explorer, so that you can share your data with others without having to share your entire worksheet. With Excel 2007 and Microsoft Office SharePoint Server 2007, you can publish Excel tables to Excel Services, so that you can share Excel information through the browser by using Microsoft Office Excel Web Access. Excel Web Access presents the information in an Excel-like view rather than the list view of Windows SharePoint Services 2.0. This view enables the people you are sharing with to work in a familiar environment, even manipulating certain sets of data in the browser, without having access to any proprietary information contained in other parts of the worksheet. To publish an Excel 2007 table to Excel Services, you must first save the worksheet to a Windows SharePoint Services 3.0 document library. Here's how: 1. Open the online file, click the Office button, and point to Publish. 2. Click Excel Services, and then click Excel Services Options. 3. On the Show tab, click the drop-down arrow, click Sheets, and then select the individual sheets that you want to publish. 4. Click OK, and then save the file. Customize Your Pictures You can apply style, shadow, and crop effects to the pictures that you add to your presentations. You can create great-looking effects with just a few clicks. 1. On the Insert tab, click the Picture icon to browse for a picture to add to your slide. 2. After selecting your picture, go to the Picture Tools Format tab to see the available formatting options. 3. Pause on the items in the Picture Styles gallery to preview each of the prebuilt options. If you find a style you like, click it to apply the formatting to your picture. 4. If you want to apply custom formatting, select options from the Picture Shape, Picture Border, and Picture Effects galleries. • 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