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 hidden.
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 worksheet.
Note:
To Add a Group in Excel 2007
1. Click and drag to select the rows or columns to hide.
2. Click the Data tab.
3. Click Group in the Outline group.
You can also select the rows or columns and then press Shift+Alt+Right Arrow. The Group dialog box appears.
4. Click to select either the Rows or the Columns option.