How to Group Rows in Excel With the Plus Sign

How-to basics · Updated November 18, 2026

To group rows in Excel and add a collapsible plus sign, select the detail rows, then choose Data > Outline > Group > Group on the Windows ribbon and select Rows if Excel asks. A plus sign will appear beside the row numbers; click it to hide the selected rows, and click the minus sign that replaces it to show them again. Grouping changes what is displayed, not the underlying data.

This guide uses Microsoft Excel for Microsoft 365 on Windows. Before you begin, decide which rows belong together and keep any headings or summary rows outside the group. That makes the outline easier to read and helps prevent important totals from disappearing when you collapse it.

What You’ll Need

  • An Excel workbook containing the rows you want to organize. Save a copy first if the sheet is important or you are new to outlining.
  • A clear idea of which rows are details and which are headings or totals. For example, a department heading and its detail records can stay visible while the records are grouped beneath them.
  • Access to the Data tab. The instructions below use desktop Excel for Microsoft 365 on Windows; the ribbon layout and available outline controls can differ in Excel for the web or on Mac.

Step-by-Step

  1. Arrange the worksheet before grouping. Put related detail rows together, ideally in one continuous block. If you have a heading or a subtotal, place it just outside that block. For example, if row 5 contains a heading, rows 6 through 10 contain individual transactions, and row 11 contains a total, the detail group should usually be rows 6 through 10. Check that there are no unrelated rows mixed into the selection.
  2. Select the rows you want to collapse. Click the row number for the first detail row, hold the mouse button, and drag down to the last detail row. You can also click the first row number, hold Shift, and click the last row number. To select nonadjacent rows, hold Ctrl while clicking row numbers, but a single continuous group is usually easier to use and understand. Avoid including a heading or total that you want to remain visible.
  3. Open the Group command. On the ribbon, select the Data tab. Find the Outline group and choose Group. Depending on the ribbon width and Excel window size, the Outline controls may be compact or displayed in a dropdown. If Excel presents a dialog asking what to group, choose Rows, then select OK. If you selected entire row headers, Excel may group the selection without showing that dialog.
  4. Check that the outline appeared. Look to the left of the row numbers for an outline bracket and a small minus sign near the selected block. The minus sign means the rows are currently expanded and visible. If you do not see the controls, first confirm the group was created, then check the troubleshooting section below for the worksheet display setting.
  5. Click the minus sign to collapse the rows. Excel hides the grouped detail rows and changes the control to a plus sign. The rows are still in the worksheet; they are simply hidden as part of the outline. Any visible heading or summary row outside the group stays on screen, so you can scan the sheet without losing the context of the details.
  6. Click the plus sign to expand the group. This displays the hidden rows again and restores the minus sign. You can use the control repeatedly as you review the worksheet. If your selection includes several detail sections, create a separate group for each section rather than making one large group that hides unrelated records together.
  7. Try the keyboard shortcut if you prefer. In Excel for Windows, select the rows and press Alt+Shift+Right Arrow to group them; press Alt+Shift+Left Arrow to ungroup. In Excel for Mac, the corresponding shortcuts are generally Option+Shift+Right Arrow and Option+Shift+Left Arrow. Keyboard layouts and Excel versions can affect shortcut behavior, so use the Data tab commands if a shortcut does not work.

Groups can be nested. For example, you might group individual transactions by month and then group several months into a quarter. Create the smaller groups first, then select the larger block and group it. Excel displays outline level buttons, usually numbered, above the row headings. Clicking a level button shows that level of detail across the sheet; it is different from clicking an individual plus sign, which expands one group.

Common Mistakes

  • Selecting the heading or total by accident. If the heading disappears when you click the plus or minus control, it was probably included in the group. Ungroup the rows, select only the detail rows, and group again. Leaving the label or total visible makes the collapsed section easier to identify.
  • Choosing Columns instead of Rows. When Excel asks what to group, make sure Rows is selected. A column group creates controls above the column letters instead of beside the row numbers.
  • Expecting grouping to delete or summarize data. A group only hides and reveals rows. It does not remove records, calculate totals, or create a subtotal. If you need a calculated subtotal, add an appropriate formula or use Excel’s subtotal tools separately.
  • Grouping a scattered selection and expecting a neat block. Outlines are clearest when each group is a continuous range. If the relevant rows are separated by unrelated records, sort or reorganize the sheet first, or make separate groups where the layout allows it.
  • Using Hide Rows instead of Group. The Home tab’s hide command conceals rows but does not provide the same outline plus and minus controls. If you want a collapsible section, use Data > Group.
  • Including blank or unrelated rows without checking. A blank row within a group can make the bracket look larger than expected, while unrelated rows may vanish when you collapse the section. Review the selected row numbers before applying Group.

Tips

  • Keep summaries outside the detail range. A common layout is a subtotal or heading above or below its detail rows, with only the details grouped. This allows the key label or total to remain visible when the group is collapsed.
  • Use more than one group for long sheets. Grouping each month, team, or category separately makes it possible to open only the section you need. Give each section a clear label in the worksheet so the meaning of each plus sign is obvious.
  • Use outline levels for a quick overview. If the sheet has nested groups, the numbered buttons near the top-left of the row headings can display a broader or more detailed level throughout the worksheet. Click an individual plus or minus control when you want to change just one group.
  • Understand that collapsing does not protect data. Hidden rows can still be edited, included in calculations, or revealed by someone with access to the workbook. Grouping is a viewing aid, not a security feature or a replacement for a backup.
  • Check the summary-row setting if the bracket is awkward. In Excel for Windows, open the Data tab and use the small dialog box launcher in the Outline group to open outline settings. The option for summary rows below detail controls where Excel expects summary rows to sit. Choose a layout that matches your sheet, then inspect the outline again.
  • Save after organizing. Excel normally stores the outline with the workbook. Save the file after creating or changing groups so the structure is available the next time you open it.

Troubleshooting

No plus or minus sign appears: Confirm that you used Data > Group and selected Rows. Then check whether outline symbols are hidden for the worksheet. On Windows, go to File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if an outline is applied. If the workbook has more than one sheet, check that the setting applies to the sheet you are viewing. Also look at the far left of the row headings; the bracket and controls can be easy to miss in a narrow window.

The wrong rows disappear: Expand the group if necessary, select the affected row numbers, and choose Data > Outline > Ungroup. If prompted, choose Rows. Select the correct detail range and group it again. If the worksheet contains several nested levels, use the numbered outline buttons or expand the groups so you can see exactly which rows belong to each level before changing them.

Group or Ungroup is unavailable: Check whether the worksheet is protected. Protection can restrict structural changes; if you are authorized to edit the sheet, use Review > Unprotect Sheet and provide the password if Excel requests one. Also check whether you are editing in a version or view that does not expose the full outline controls. Open the workbook in desktop Excel for Microsoft 365 if necessary.

The shortcut inserts or changes something else: Click a cell or select the row headers again, then use the ribbon command instead. Shortcuts can depend on the active cell, keyboard layout, and Mac or Windows version. If you cannot find Group in the ribbon, maximize the Excel window or look for a collapsed Outline dropdown on the Data tab.

A group remains after you expand it: That is expected. Expanding reveals the rows but does not remove the outline. To remove a group, select its rows and choose Data > Outline > Ungroup. To remove all outline levels from the worksheet, use the dropdown beside Group or Ungroup and choose Clear Outline, if available. This removes the grouping structure, not the worksheet data.

The workbook is in Excel for the web or on Mac: The arrangement of outline controls may differ from Windows desktop Excel, and some commands can be limited by the current version or workbook. Look for Group or Ungroup on the Data tab. If the controls are missing, use the desktop app to create or adjust the outline, then save the workbook.

Frequently Asked Questions

How do I add a plus sign to grouped rows in Excel?

Select the detail rows and choose Data > Outline > Group, then choose Rows if prompted. Excel adds an outline control beside the row numbers. The group shows a minus sign while expanded and a plus sign after you collapse it.

Why do I see a minus sign instead of a plus sign?

The minus sign means the group is expanded and its rows are visible. Click the minus sign to hide the rows; Excel then displays a plus sign that you can click to expand the group again.

Can I group rows without hiding them?

Yes. Creating a group initially leaves the selected rows expanded and visible. The outline controls appear, but the rows stay on screen until you click the minus sign. You can leave the group expanded whenever you want to preserve the full view.

Can I group several sections independently?

Yes. Select and group each continuous block of detail rows separately. Each block gets its own control, so you can collapse one section without hiding the others. You can also nest groups to create multiple outline levels.

How do I remove the plus sign and grouping?

Expand the rows if needed, select the grouped row range, and choose Data > Outline > Ungroup. If the worksheet has multiple outline levels, remove only the level you intend to change, or use Clear Outline to remove all grouping structure.

Does grouping rows change formulas or delete data?

No. Grouping hides rows from view when collapsed; it does not delete their contents. Formulas may still include hidden rows, depending on the formula. Review the relevant calculation if you need a result that excludes hidden records.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.