Create an outline

Outlined list

This outline lets you show and hide the detail rows for monthly sales.
Callout 1 If your summary rows are above the detail rows, or your summary columns are to the left of the detail columns, change the direction setting.

ShowHow?

  1. On the Data menu, point to Group and Outline, and then click Settings.
  2. Clear the Summary rows below detail check box, the Summary columns to right of detail check box, or both check boxes.

ShowHow?

  1. On the Data menu, point to Group and Outline, and then click Settings.
  2. Select the Automatic styles check box.

 Note   If you don't want to apply automatic styles before you begin, you can apply them after you create the outline.

Callout 3 Decide whether to outline the worksheet automatically or manually.

If you aren't sure whether your worksheet meets these requirements, try outlining automatically, and if the results aren't as you expect, undo the operation and outline manually instead.

Callout 4 Do one of the following:

ShowOutline the data automatically

  1. Select the range of cells you want to outline.

To outline the entire worksheet, click any cell on the worksheet.

  1. On the Data menu, point to Group and Outline, and then click Auto Outline.

ShowOutline the data manually

  1. Select the rows or columns that contain detail data.

Detail rows or columns are usually adjacent to the row or column that contains the summary formula or a heading. For example, if row 6 contains totals for rows 3 through 5, select rows 3 through 5. If row 8 contains a heading that describes rows 9 through 12, select rows 9 through 12.

  1. On the Data menu, point to Group and Outline, and then click Group.

The outline symbols (outline symbols: Symbols that you use to change the view of an outlined worksheet. You can show or hide detailed data by pressing the plus sign, minus sign, and the numbers 1, 2, 3, or 4, indicating the outline level.) appear beside the group on the screen.

  1. Continue selecting and grouping detail rows or columns until you have created all of the levels you want in the outline.
Callout 5 If you didn't select automatic styles, you can apply styles now.

ShowHow?

  1. Select the cells that you want to apply outline styles to.
  2. On the Data menu, point to Group and Outline, and then click Settings.
  3. Select the Automatic styles check box.
  4. Click Apply Styles.
 
 
Applies to:
Excel 2003