Microsoft Office Tutorials and References
In Depth Information
HIDE ROWS OR COLUMNS
in a PivotTable
Formatting data changes its appearance, but formatting
is not just a matter of cosmetics. Rather, formatting is
useful because the details in PivotTables can make it
difficult to see data patterns. Formatting improves data
Two PivotTable formatting options available in Excel
are grouping and sorting. With grouping, you can
hide detail so you can easily compare groups of data.
When you group columns or rows, Excel totals the
data, creates a field header, and creates a field with
a drill-down button that displays
either a plus or a minus sign.
When the drill-down button displays a minus sign, you
can click the button to collapse the data. When the
drill-down button displays a plus sign, you can click
the button to expand the data. If you do not want to
display the button, you can click Buttons on the
Options tab to toggle the display of buttons to off. If
after grouping your data, you want to ungroup it, you
Click and drag the row or
column labels to select the rows
or columns you want to hide.
l The PivotTable tools become
Click the Options tab.
Click Group Selection.
l A new cell appears, with a minus
Click the minus button.
l The details of the rows or
columns are hidden, the total
appears, and the minus sign on
the button turns into a plus sign.
Note: You can click the plus button
to see the hidden cells again.
Click the cell that contains the
Excel removes the grouping.