Microsoft Office Tutorials and References
In Depth Information
Sorting and Filtering Pivot Table Data
Banded Rows or Banded Columns check box, or you can remove this banding
by clearing these check boxes.
Formatting values in the pivot table
To format the summed values entered as the data items of the pivot table
with an Excel number format, you follow these steps:
1. Click the field in the table that contains the words “Sum of” and the
name of the field whose values are summarized there, click the Active
Field command button on the Analyze tab under the PivotTable Tools
contextual tab, and then click the Fields Settings option on its pop-up
menu.
Excel opens the Value Field Settings dialog box.
2. Click the Number Format command button in the Value Field Settings
dialog box to open the Format Cells dialog box with its sole Number
tab.
3. Click the type of number format you want to assign to the values in
the pivot table on the Category list box of the Number tab.
4. (Optional) Modify any other options for the selected number format,
such as Decimal Places, Symbol, and Negative Numbers that are
available for that format.
5. Click OK twice, the first time to close the Format Cells dialog box, and
the second to close the Value Field Settings dialog box.
Sorting and Filtering Pivot Table Data
When you create a new pivot table, you’ll notice that Excel automatically
adds drop-down buttons to the Report Filter field, as well as the labels for the
column and row fields. These drop-down buttons, known officially as filter
buttons (see Chapter 11 for details), enable you to filter all but certain entries
in any of these fields, and in the case of the column and row fields, to sort
their entries in the table.
If you’ve added more than one column or row field to your pivot table, Excel
adds collapse buttons (-) that you can use to temporarily hide subtotal
values for a particular secondary field. After clicking a collapse button in
the table, it immediately becomes an expand button (+) that you can click to
redisplay the subtotals for that one secondary field.
Search JabSto ::




Custom Search