How to Group Rows in Excel With Plus Signs at the Top

How-to basics · Updated November 20, 2026

To put a plus sign above Excel’s column headings, select the columns you want to fold away, then choose Data > Group. Click the resulting minus sign to collapse the group; Excel then shows a plus sign that expands it again. For row groups, the controls appear beside the row numbers instead. These outline controls let you hide detail temporarily without deleting it.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel.
  • Adjacent rows or columns that you want to show or hide together. Grouping works best when the data has a clear detail section and, if needed, a separate summary section.
  • A saved copy of the workbook if you are about to reorganize a complex outline. Grouping itself does not remove data, but a backup makes it easier to recover from larger layout changes.

Step-by-Step

  1. Decide whether to group columns or rows. Use a column group when you want the plus and minus controls above the column letters. For example, you might group columns D through F containing monthly figures while leaving a total in column G visible. Use a row group when you want the controls beside the row numbers, such as grouping transaction rows below a subtotal. Excel uses the same outline feature for both.
  2. Check the layout before selecting anything. Make sure the columns or rows to be grouped are next to each other. Keep any totals, headings, or explanatory notes that must remain visible outside the selected range. If you have a summary column to the right of detail columns, Excel’s default outline setting places the controls above the detail columns so the summary can remain visible. For a row example, a subtotal above a block of detail rows is often easiest to read.
  3. Select the columns or rows you want to group. For columns, click the first column letter and drag across to the last, or click the first letter, hold Shift, and click the last. To select nonadjacent columns, do not use one group: make separate groups for each continuous section. For rows, select the row numbers in the same way. Selecting the whole column or row headers makes your intention clear and avoids accidentally grouping only a few cells.
  4. Open the Group command. On the ribbon, select Data > Group in the Outline area. Depending on the ribbon layout, Group may be a button with a dropdown; open it and choose Group. If you selected ordinary cells rather than full row or column headers, Excel may ask whether to group Rows or Columns. Choose the option you intended and confirm. On Excel for Mac, use the Data tab and its Group command as well; if the ribbon is arranged differently, look for Group in the Data tab rather than using a Windows-only shortcut.
  5. Check that Excel created the outline. For a column group, look above the column letters for a horizontal bracket and a small minus control. For a row group, look to the left of the row numbers. A minus sign means the group is currently expanded and its contents are visible. If you do not see the controls, first check whether outline symbols are hidden; troubleshooting below covers that setting.
  6. Collapse the group to show the plus sign. Click the minus control at the end of the bracket. Excel hides the grouped columns or rows, and the control changes to a plus sign. Click the plus to expand the group and display the contents again. The plus sign is not usually shown while the group is expanded, so collapse the group if your goal is specifically to see a plus sign at the top.
  7. Use outline level buttons for a broader view. When a sheet has groups, Excel may show numbered outline buttons near the top-left corner of the worksheet. They display different levels of detail: a lower level generally shows fewer details, while a higher level reveals more. For example, if level 1 shows only your summary columns and level 2 shows the grouped detail, clicking 1 or 2 changes the whole outline view. The plus and minus controls still let you open or close an individual group.
  8. Add additional groups carefully. To create another group, select a different continuous block and repeat Data > Group. For nested groups, group the smallest inner sections first, then select the larger outer section and group it. This creates levels that can be expanded separately. Check the brackets and level buttons after each group so you can confirm which section each control affects.
  9. Repeat the process for the other direction if needed. A worksheet can have both row and column outlines. For example, group detail columns horizontally and transaction rows vertically. Create and test one direction at a time so it is easier to spot a selection error. Collapsing a row group does not delete data, and collapsing a column group does not change formulas that refer to those columns.

Common Mistakes

Expecting the plus sign while the group is open. Excel shows a minus sign for an expanded group because clicking it will hide the details. The plus appears after you collapse the group. If you created the group but see a minus, the feature is working as intended.

Selecting the summary column by accident. If you include a total or key figure in the selected columns, it will disappear along with the detail when the group collapses. Undo immediately with Ctrl+Z on Windows if you have just made the group, then select only the detail columns. On Mac, use Command+Z.

Grouping a scattered selection as if it were one block. An outline group is for a continuous range. Separate areas should be grouped separately; otherwise Excel may infer a different selection than you intended or prompt you to choose an outline direction.

Confusing grouping with hiding. Hiding a column from its context menu conceals it, but it does not create an outline bracket with plus and minus controls. Use Data > Group when you want a repeatable expand-and-collapse control. Conversely, if you only need to hide something once and do not need an outline, ordinary Hide may be simpler.

Trying to group a sheet that is protected. Worksheet protection can prevent changes to the outline. If the Group command is unavailable or Excel refuses the action, check whether the sheet is protected and whether you have permission to unprotect it.

Tips

  • Keep summaries outside the detail group. For example, if D:F contains quarterly detail and G contains a total, group D:F and leave G visible. Readers can compare the total with the expanded detail without reopening the group.
  • Use clear headings before grouping. Label the visible summary columns or rows so the collapsed view remains understandable. A collapsed outline is most useful when someone can tell what the hidden section represents.
  • Make nested groups from the inside out. Create small subgroups first, then the larger group around them. That order makes it easier to build a useful outline with several levels rather than one large block that hides everything at once.
  • Use the keyboard shortcut on Windows if you prefer. Select the rows or columns and press Alt+Shift+Right Arrow to group. Press Alt+Shift+Left Arrow to ungroup the selected outline level. On Mac, use the Data tab’s Group and Ungroup commands because Windows Alt shortcuts do not transfer reliably between Mac keyboards and Excel settings.
  • Change where outline controls appear if necessary. Excel normally puts summary columns to the right of detail and summary rows below detail. If your layout uses summaries on the opposite side, open the Outline settings from the small dialog launcher in the Data tab’s Outline group and adjust the relevant summary-position option. This affects where the outline buttons sit, not the underlying values.
  • Remember that formulas remain in the sheet. Collapsing a group only hides its rows or columns from view. Formulas elsewhere can still refer to those cells, and the cells are still part of the workbook.

Troubleshooting

The plus and minus controls are missing. In desktop Excel for Windows, open File > Options > Advanced. Under Display options for this worksheet, select the worksheet if needed and enable Show outline symbols if an outline is applied. Choose OK. If the outline has not yet been applied, there will be no group controls to show. In Excel for Mac, check Excel’s preferences or settings for display options related to outline symbols; the location and wording can differ by release.

The Group button is disabled. Check whether the worksheet is protected, whether you are editing a cell, or whether the workbook is in a mode that restricts structural changes. Press Esc to finish cell editing, select the headers again, and retry. If the sheet is protected, ask the workbook owner to unprotect it or allow outline use; do not remove protection without authorization.

The wrong rows or columns disappear. Expand the group, then select the correct headers and use Data > Ungroup. If multiple outline levels exist, Excel may ask which level to remove; choose the level that matches the unwanted bracket. Then create the group again with only the intended contiguous detail section. Undo with Ctrl+Z on Windows or Command+Z on Mac is useful immediately after an accidental grouping.

The plus sign is on the wrong side of the summary. Open the Outline settings from the Data tab’s Outline group and review whether summary rows are below detail and summary columns are to the right of detail. Adjust the setting to match your sheet, then inspect the controls again. If your summary itself was included in the group, changing this setting will not fix that selection; ungroup and select the detail range correctly.

Some columns remain visible after collapsing. This can be expected if those columns were outside the group, or if a nested group is still expanded. Check the bracket’s endpoints, click the relevant minus control, and use the outline level buttons to see whether another level is open. Also check for manually hidden columns, which do not necessarily belong to the outline.

You are using Excel for the web. The web version may show outline controls in workbooks that already contain groups, but the available editing commands can vary. If the Data tab does not offer the Group command in your account or current interface, open the workbook in the Excel desktop app and create the outline there. The desktop app is also the better choice for changing outline settings.

Frequently Asked Questions

Why does my grouped column show a minus instead of a plus?
The group is expanded. Click its minus control to hide the columns; the control changes to a plus sign when the group is collapsed.

Can I put the plus sign above the column letters?
Yes. Select the columns and use Data > Group. Excel places column outline controls above the headings. Row-group controls appear beside the row numbers instead.

Does grouping delete or change cell values?
No. Grouping hides and reveals rows or columns; it does not delete their contents. Formulas and references remain in place.

How do I remove a group without deleting its data?
Select the grouped rows or columns, then choose Data > Ungroup. This removes the outline control and leaves the cell contents intact. Use Clear Outline only if you intend to remove all outline groups on the sheet.

Can I create more than one plus sign?
Yes. Create separate groups for separate continuous sections. You can also create nested groups for multiple levels of detail, then expand or collapse each section using its own controls or the numbered outline levels.

Can I group rows and columns on the same worksheet?
Yes. Excel supports row and column outlines together. Create each group from its own selection and test the controls separately to confirm that each one hides the intended detail.

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.