Show or hide outlined data

  1. If you don't see the outline symbols one two three, plus, and minus, click Options on the Tools menu, click the View tab, and then select the Outline symbols check box.
  2. Do one or more of the following:

ShowShow or hide the details for a group

  • To display the detail data within a group, click the plus box for the group.
  • To hide the detail for a group, click the minus box for the group.

ShowExpand or collapse the entire outline to a particular level

  • In the one two three outline symbols, click the number of the level you want. Detail at lower levels is then hidden.

For example, if an outline has four levels, you can hide the fourth level while displaying the rest of the levels by clicking three.

ShowShow or hide all of the outlined detail

  • To show all detail, click the lowest level in the one two three outline symbols. For example, if there are three levels, click three.
  • To hide all detail, click one.
Applies to:
Excel 2003