How to Group in Microsoft Excel: Rows, Columns, and Sheets

How-to basics · Updated November 20, 2026

To group rows or columns in Excel, select the rows or columns, then choose Data > Group. Excel adds outline controls so you can collapse details and reopen them when needed. You can also group worksheets to edit several sheets together, or group shapes to move and format them as one object; the steps for each are below.

What You’ll Need

  • A workbook in Microsoft Excel for Microsoft 365 on Windows. The main ribbon directions below are for this version; Excel for Mac has similar commands, with some keyboard shortcuts differing.
  • For row or column grouping, a worksheet with the data you want to organize. You do not need to sort the data first, but grouping works best when related rows or columns are together.
  • If you want to group worksheets or shapes, at least two worksheet tabs or two selectable objects, respectively.

Step-by-Step

Group rows so you can collapse detail

  1. Choose the rows. Click the row number at the left of the first row you want to include, then drag down to the last row. For a non-adjacent set, Excel’s outline grouping is not designed to combine scattered rows into one group; group each continuous block separately. Keep any summary row outside the detail selection if you want it to remain visible when the group is collapsed.
  2. Open the grouping command. On the ribbon, select Data > Group. If Excel asks whether to group Rows or Columns, select Rows and choose OK. When you selected full row headers, Excel may group the rows directly without displaying that prompt.
  3. Use the outline controls. A bracket and a minus button appear beside the grouped rows. Click the minus button to hide the detail. It changes to a plus button; click plus to show the rows again. The numbered outline buttons at the top-left of the sheet show different detail levels. For a simple group, level 1 usually shows the summary view and level 2 shows the detail.
  4. Check what remains visible. Collapse the group and make sure the intended summary rows and totals are still on screen. If the total was included in the detail, it will disappear too. Undo with Ctrl+Z on Windows if you just created the wrong group, then select the correct rows and repeat.

Group columns

  1. Select the column letters across the adjacent columns you want to tuck away. For example, select C through F by clicking C and dragging across to F.
  2. Choose Data > Group. If Excel presents a Rows or Columns choice, select Columns and confirm.
  3. Click the minus control above the selected columns to collapse them, or the plus control to expand them. Leave important labels or totals outside the group if they need to stay visible in the collapsed view.

Create nested groups or several outline levels

  1. First create the larger group using the steps above, such as grouping all detail rows for a quarter.
  2. Select a smaller, continuous block of rows inside that larger section and choose Data > Group again. Repeat for other subgroups as needed. Excel displays additional outline levels and controls.
  3. Click the numbered outline buttons to switch between levels. A higher level number generally reveals more detail. Expand or collapse individual brackets when you want to show only selected sections rather than using one level for the entire sheet.

Group worksheets to make changes on several sheets

  1. At the bottom of the workbook, select the first worksheet tab. To select adjacent tabs, hold Shift and click the last tab. To select separate tabs, hold Ctrl and click each one on Windows. On Mac, use Command-click for separate tabs.
  2. Look for [Group] in the Excel title bar or otherwise confirm that multiple tabs are selected. While sheets are grouped, many edits made to one selected sheet—such as entering a value into the same cell—are also applied to the corresponding cells on the other selected sheets. This can save time for sheets with the same layout.
  3. Make only the intended changes. Check the selected tabs before typing, formatting, or deleting anything; grouped-sheet edits can affect every selected sheet.
  4. To finish, right-click one of the selected worksheet tabs and choose Ungroup Sheets. You can also click a worksheet tab that is not part of the group. Confirm that the group indicator is gone before continuing with ordinary edits.

Group shapes or other objects

  1. Click one shape, picture, or other supported object, then hold Ctrl on Windows and click the other objects you want to combine. On Mac, use Command-click. You can also drag a selection box around objects, taking care not to include objects you want to leave separate.
  2. When the objects are selected, open the contextual Shape Format tab and choose Group > Group. Depending on the selected object types and Excel layout, the Group command may be unavailable; select compatible objects on the worksheet and try again.
  3. Move or resize the group as one unit. To change one item, select the group and then select the individual object, or ungroup the objects from Shape Format > Group > Ungroup.

Common Mistakes

  • Selecting the summary row as detail. If the row containing a subtotal or heading is inside the group, collapsing the group hides it. Select only the detail rows and keep the summary outside the bracket.
  • Expecting group to combine or summarize data. Outline grouping only hides and reveals rows or columns; it does not merge cells, calculate totals, or rearrange records. Use formulas or Excel’s Subtotal or PivotTable features if you need calculations or a summary report.
  • Editing worksheets while several are grouped. A change can be repeated on all selected sheets. Ungroup the tabs as soon as the shared edits are complete.
  • Confusing grouping with hiding. Hiding rows manually does not create an outline bracket or level controls. Use Data > Group when you want a collapsible section that is easy to expand later.
  • Grouping non-adjacent rows as one section. Outline groups represent continuous blocks. Make separate groups for separate blocks rather than selecting scattered records and expecting one bracket.

Tips

  • Keep labels visible. Put a section title or total just outside the grouped detail so readers can understand the collapsed section. A common layout is a subtotal row followed by its detail rows, with only the detail selected.
  • Use the outline level buttons for quick views. If the sheet has many groups, the numbered controls can show a high-level summary or reveal more detail across the outline at once. Use individual plus and minus buttons when you want a custom combination.
  • Use keyboard shortcuts on Windows. With the rows or columns selected, press Alt+Shift+Right Arrow to group, and Alt+Shift+Left Arrow to ungroup. These are Windows shortcuts; Mac keyboard equivalents can vary by Excel version and system settings, so use the Data tab commands if the shortcut does not work.
  • Plan an outline before adding many levels. Group the largest sections first, then add smaller groups inside them. This gives the outline a logical structure and makes the level buttons more useful.
  • Save a copy before restructuring a shared workbook. Grouping itself does not remove data, but collapsing rows can make content easy to overlook, and grouped-sheet edits can affect multiple tabs. A copy gives you a straightforward recovery point.
  • Remember that collapsing is not deletion. The hidden rows and columns remain in the worksheet. Expand the outline before printing or reviewing the full data if the detail needs to be included.

Troubleshooting

  • The Group command is greyed out. Check that you selected worksheet rows or columns rather than a chart, cell range with an incompatible selection, or a protected sheet. If the worksheet is protected, review Review > Unprotect Sheet if you have permission to unprotect it, then select the row or column headers and try Data > Group again.
  • No plus or minus controls appear. The outline symbols may be hidden. In Excel for Windows, open File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if an outline is applied. Also check whether the sheet is zoomed or scrolled so the controls are outside the visible area.
  • The wrong rows disappear. Click the plus button to expand the group, then select the correct row numbers and group again. If there is a summary row, move it outside the detail selection before collapsing. A visible outline bracket helps identify exactly which rows belong to a group.
  • Excel says it cannot create an outline. A worksheet can have restrictions or existing outline settings that prevent the change. Check sheet protection, remove an incorrect existing group with Data > Ungroup, and try selecting a clean, continuous block. If you are working in a shared or coauthored workbook, confirm that you have permission to change its structure.
  • Changes appear on multiple worksheets. The sheets are still grouped. Right-click a selected tab and choose Ungroup Sheets, then verify that [Group] no longer appears in the title bar. If an unwanted edit was just made, use Ctrl+Z on Windows or Command+Z on Mac before ungrouping, where available.
  • The grouping buttons are missing in Excel for the web. The web version has a reduced set of desktop features and its ribbon can differ. Open the workbook in the Excel desktop app for the full outline controls and the menu paths described here, especially if you need nested groups or are managing grouped worksheets.

Frequently Asked Questions

What does grouping do in Excel?

Grouping rows or columns adds outline controls that let you hide and reveal a continuous block without deleting it. Grouping worksheet tabs instead selects several sheets so many edits can be made to them together. Grouping shapes makes selected objects behave as one item.

How do I ungroup rows or columns?

Select the grouped rows or columns, then choose Data > Ungroup. If Excel asks whether to ungroup rows or columns, choose the right option and confirm. To remove all outline groups on a sheet, use the arrow under Data > Ungroup and choose Clear Outline, if that command is available in your Excel ribbon. Clearing an outline removes the grouping structure, not the underlying cell values.

Can I group rows that are not next to each other?

Not as one outline group. Excel’s row and column outlines are based on adjacent blocks. Create a separate group for each continuous section, or reorganize the data if the related rows need to collapse together.

Will grouping hide or delete my data?

Collapsing a group hides rows or columns from view but does not delete their contents. Expand the group to see the data again. Be aware that hidden content may be omitted from some printouts depending on the print settings.

Why did the same change appear on two worksheets?

The worksheets were grouped when you edited the cell or format. Ungroup them by right-clicking a selected sheet tab and choosing Ungroup Sheets. Check the tabs first whenever you open a workbook with several sheets selected.

Can I group rows and columns at the same time?

You can create row groups and column groups on the same worksheet, but create them as separate operations: select the rows and group them, then select the columns and group those. Their outline controls let you collapse each direction independently.

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.