How to Group Rows and Create an Outline in Microsoft Excel

Managing extensive Microsoft Excel spreadsheets containing hundreds of detailed rows—such as monthly financial ledgers, itemised inventory lists, or department breakdown budgets—often makes it difficult for stakeholders to see the big picture. While manually hiding and unhiding rows works, it is cumbersome and hides critical row numbering context.

Excel’s Outline and Grouping tool provides an elegant, interactive solution. By grouping related rows together, Excel generates interactive plus (+) and minus (-) toggle buttons in the left margin, allowing you to expand detailed records or collapse them into clean summary rows with a single click. Here is how to group rows and create an outline in Microsoft Excel.


Step-by-Step: Group Rows in Microsoft Excel

You can create an interactive outline group using simple ribbon commands:

  1. Open your worksheet in Microsoft Excel.
  2. Highlight the contiguous rows you wish to group (click and drag across the row numbers on the far left). Tip: Do not include your summary/total row in the selection.
  3. Go to the Data tab on the Excel ribbon.
  4. In the Outline group on the right-hand side, click Group (or press Shift + Alt + Right Arrow on Windows).
  5. If prompted by a small dialogue asking whether to group by Rows or Columns, select Rows and click OK.

Excel will instantly generate a grey outline bar with a minus (-) sign next to the grouped rows in the left margin. Clicking the minus button collapses the rows into a compact summary view, turning the icon into a plus (+) sign for quick expansion.


How to Use Outline Levels (1 and 2 Buttons)

When you create grouped outlines, Excel adds numbered level buttons (1 and 2) in the top-left corner above row number 1:

  • Click ‘1’: Collapses all grouped sections across the entire worksheet at once, presenting a high-level summary view suitable for executive presentations.
  • Click ‘2’: Expands all grouped rows simultaneously to reveal full, itemised granular data.

How to Ungroup Rows or Clear the Entire Outline

If you no longer need collapsible sections or wish to reorganise your data structure:

  1. Highlight the rows that are currently grouped.
  2. Go to the Data tab on the ribbon.
  3. In the Outline group, click Ungroup (or press Shift + Alt + Left Arrow).
  4. To wipe all outlines across the entire sheet in one go, click the arrow below Ungroup and select Clear Outline.

Excel will remove all grouping margin bars and restore standard row visibility without altering any cell data, formulas, or formatting.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.