Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Creating a PivotTable View Microsoft PivotTable dynamic views help you change the axis that your data is organized around. To create a PivotTable view: 1. Click anywhere inside the range of data. 2. On the Ribbon, on the Insert tab, click PivotTable. 3. In the PivotTable Field List pane, check the fields that you want to visualize. 4. Rearrange your fields by dragging the row labels, column labels, and values to where you want them. 5. To add a filter, check the desired field, and drag it to the Report Filter box. Microsoft Office Excel will display the sum of the data in the value field, but you can quickly modify the field to track other totals types, such as average, minimum value, or maximum value: 1. In the Values box, click the arrow next to the value that you want to modify. 2. Select Value Field Settings. 3. Change the setting from Sum to the desired type of calculation. 2003 to 2007 Page Layout View How many times have you walked to the printer and discovered that your Microsoft Office Excel 2003 worksheet didn't print as you expected? You can use the Page Break Preview view in Excel 2003 to scale your data to particular pages, but a more realistic preview of the printed page would be helpful. Page Layout view in Microsoft Office Excel 2007 presents an exact representation of the printer output of your worksheet. Page Layout view also makes it easy for you to add headers and footers to your worksheet by simply typing the text where you want it to appear. To use Page Layout view, click the View tab, and then click Page Layout in the Workbook Views section. • 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