United States
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers. About printing a PivotTable report
Applies to: Microsoft Office Excel 2003
In addition to the print settings on the Page Setup dialog box, which apply to all worksheets, Microsoft Excel has print settings that are specific to PivotTable reports. These settings are particularly helpful when you print large reports in indented format (any of formats Report 1 through Report 10, available when you click Format Report
To use these settings, you must have only one report on the worksheet, or set a print area (print area: One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.) that includes only one report.
You can repeat the row and column labels of a report on every printed page. These labels include the field and item labels for all row (row field: A field that's assigned a row orientation in a PivotTable report. Items associated with a row field are displayed as row labels.), column (column field: A field that's assigned a column orientation in a PivotTable report. Items associated with a column field are displayed as column labels.), and data fields (data field: A field from a source list, table, or database that contains data that is summarized in a PivotTable report or PivotChart report. A data field usually contains numeric data, such as statistics or sales amounts.). When you change the layout of the report so that the labels are in different worksheet rows and columns, the new label rows and columns are repeated automatically the next time you print the report. To set this feature, you must first remove any worksheet print titles (print titles: Row or column labels that are printed at the top of or on the left side of every page on a printed worksheet.) you set on the Sheet tab in the Page Setup dialog box.
When you have multiple row fields (row field: A field that's assigned a row orientation in a PivotTable report. Items associated with a row field are displayed as row labels.) and a page break falls within a group of row field items (item: A subcategory of a field in PivotTable and PivotChart reports. For instance, the field "Month" could have items such as "January," "February," and so on.), you can automatically repeat the item labels for the outer fields at the top of the next page. In the example below, you might want items East and Qtr2 from outer row fields Region and Qtr to print on the next page after the page break:
You can set automatic page breaks to print each item in an outer row field (row field: A field that's assigned a row orientation in a PivotTable report. Items associated with a row field are displayed as row labels.) on a separate page. (In a report with two or more row fields, all but the rightmost one are outer row fields.) You can then adjust individual page breaks by moving them, so that they become manual page breaks, or by deleting them. You can also add new manual page breaks. |
Email this link
Printer-Friendly Version
Share
Show All
Hide All
on the PivotTable toolbar).
Page break within an item group
Item labels from outer row fields repeat on page 2| Related Web Sites |
| ||||||
