Compacting the Space Required for Row Labels in Font

Printer PDF-417 2d barcode in Font Compacting the Space Required for Row Labels

There are several row fields in your pivot table, and when you print, the row field labels fill the first page. You d like to reduce the space required for the labels so it s easier to read the printed report.

With the pivot table in Outline layout, you can reduce the column width for many of the row fields: 1. Double-click the field button for the outer row field. 2. Click the Layout button to open the PivotTable Field Layout dialog box. 3. Select the Show items in outline form option, and add a checkmark to Display subtotals at top of group. 4. Click OK to close the PivotTable Field Layout dialog box.

5. Click OK to close the PivotTable Field dialog box. 6. Repeat Steps 1 5 for each remaining row field, except the innermost field. 7. At the top of the worksheet, select the columns for all the row fields that you formatted. 8. Adjust the width of the selected columns so they show only a few characters. 9. At the left of the worksheet, select the row that contains the row field buttons. 10. In the Excel worksheet menu, choose Format Cells. 11. On the Alignment tab, change the Orientation to 90 degrees, and set the Horizontal Text alignment to Center. 12. Click OK to close the Format Cells dialog box. The pivot table row fields now require much less space, and the labels and data may fit on the same printed page, as shown in Figure 11-2.

You need to give each salesperson a printed copy of the pivot table with their sales results visible.

You can use the Show Pages feature to create a worksheet for each item in the Salesperson page field:

1. On the PivotTable toolbar, choose PivotTable Show Pages. 2. If there are multiple page fields, the Show Pages dialog box will appear. Select the Salesperson field, and click the OK button. 3. Select all the worksheets that were created, and print them. 4. After printing, you can delete the sheets that were created by the Show Pages command, or close the workbook without saving the changes.

Your pivot table has Customer and Product in the row area, and when you print your pivot table, you want each customer s data to start on a new page.

You can set the Customer field so each item starts on a new page: 1. Right-click the Customer field button, and choose Field Settings. 2. Click the Layout button, and add a checkmark to Insert page break after each item. 3. Click OK to close the PivotTable Field Layout dialog box, and click OK to close the PivotTable Field dialog box.

When starting each item on a new page, your pivot table may be easier to understand if you set the Tip pivot table print titles, as described in Section 11.1. This repeats the pivot table headings on each page, so they ll be visible with each customer s data.

Depending on how you ve formatted the pivot table, the bottom border may be missing from each customer s subtotal when you use the Insert page break after each item option (see Figure 11-3).

Figure 11-3. The bottom border is missing when the Insert page break after each item option is used. To ensure that the border prints, you can format the subtotal row: 1. Point to the left edge of a subtotal row, and when the pointer changes to a thick black arrow, click to select all the subtotal rows for that field. 2. On the Excel Worksheet menu, choose Format Cells. 3. On the Border tab, if the bottom border is showing in the preview area, click on it to remove it (see Figure 11-4).