Microsoft Office Tutorials and References
In Depth Information
The Design tool tab contains many other tools that 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, apply banded rows to your PivotTable, and apply a
conditional format to a PivotTable.
SET UP You need the Formatting workbook located in the Chapter10 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
On the Sheet2 worksheet, right-click any data cell, and then click Number Format to
open the Format Cells dialog box.
In the Category list, click Number to display the Number page of the dialog box.