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. Group in Outline Group of Data Tab
  2. Select Auto Outline. Auto Outline
  3. You can now expand or collapse sections using the + and - signs on the side of the worksheet. Plus and Minus Signs
Next