Microsoft Office Tutorials and References
In Depth Information
Producing a Report with a Pivot Table
7. I wanted the information in the Duration column to display as hours, minutes, and
seconds, so I formatted the column using this custom number format:
[h]:mm:ss;;
8. I edited the column headings. For example, I replaced Count of Song with No. Songs.
9. I changed the layout to outline format by choosing PivotTable Tools
Design
Layout
Report Layout.
10. I turned off the field headers by choosing PivotTable Tools
Options
Show
Field
Headers.
11. I turned off the buttons by choosing PivotTable Tools
Options
Show/Hide
+/-
Buttons.
12. I displayed a blank row after each artist by choosing PivotTable Tools
Design
Layout
Blank Rows.
13. I applied a built-in style by choosing PivotTable Tools
Design
PivotTable Styles.
14. I increased the font size for the Genre.
15. I went into Page Layout View, and I adjusted the column widths so that the report would
fit horizontally on the page.
Step 14 was actually kind of tricky. I wanted to increase the size of the genre names but
leave the subtotals in the same font size. Therefore, I couldn’t modify the style for the
PivotTable Style that I chose. I selected the entire column A and pressed Ctrl+G to
bring up the Go To dialog box. I clicked Special to display the Go To Special dialog box.
Then I selected the Constants option and clicked OK, which selected only the nonempty
cells in column A. I then adjusted the font size for the selected cells.
 
Search JabSto ::




Custom Search