Microsoft Office Tutorials and References
In Depth Information
The Design contextual tab contains many other tools you can use to format your PivotTable,
but one of the most useful is the Banded Columns check box, which you can find in the
PivotTable Style Options group. If you select a PivotTable style that offers banded rows as
an option, selecting the Banded Rows check box turns banding on. If you prefer not to have
Excel band the rows in your PivotTable, clearing the check box turns banding off.
In this exercise, you’ll apply a number format to a PivotTable values field, apply a PivotTable
style, create your own PivotTable style, give your PivotTable banded rows, and apply a
conditional format to a PivotTable.
SET UP You need the Formatting_start workbook located in your Chapter09 practice
file folder to complete this exercise. Open the Formatting_start workbook, and save it
as Formatting . Then follow the steps.
1. On the Sheet2 worksheet, right-click any data cell, and then click Number Format .
The Format Cells dialog box opens.
2. In the Category list, click Number .
The Number page is displayed.