Microsoft Office Tutorials and References
In Depth Information
Hide rows by
GROUPING AND OUTLINING
You can use the Excel grouping and outlining feature
to hide sets of columns and/or rows. For example,
you can hide the details relating to weekly sales
so you can compare monthly sales. Your outlines
can include up to eight levels of detail.
Outlining a set of rows or columns creates a clickable
button on the far left or top of your worksheet. The
button displays either a minus sign or a plus sign,
depending on what is displayed in the worksheet.
Click the minus sign to hide rows or columns, and
the plus sign to display them again. Adjacent to the
button is a solid line that indicates, by its length, the
approximate number of rows or columns Excel has
Outlining was designed for use with structured
information such as lists but can be used with
any worksheet. When you outline a PivotTable,
outlining has the same effect as it does in any other
A DD A G ROUP
Click and drag to select the rows
or columns to hide.
Click the Data tab.
Click Group in the Outline group.
You can also select the rows or
columns and then press
l The Group dialog box appears.
Click to select either the Rows or
the Columns option (
Click Rows if you want to group
Click Columns if you want to