Adding an Outline

Contact Us or call 1-877-932-8228
Adding an Outline

Adding an Outline

You can group your data in Excel by using outlines. An outline allows you to group and limit that data that you are viewing You have two types - Auto and Manual. Auto Outline works well if you have used Summaries (formulas to tally rows). Manual works well if you just have a list and you wish to choose the groups.

To add an outline to your data:

  1. On the DATA tab, from the Outline group, select the Group drop-down arrow.
  2. Select Auto Outline.
  3. You can now expand or collapse sections using the + and - signs on the side of the worksheet.
Next