Excel Group and Ungroup Shortcuts for Rows and Columns

How-to basics · Updated November 20, 2026

To group rows or columns in Excel for Microsoft 365 on Windows, select the rows or columns and press Alt+Shift+Right Arrow. To ungroup them, select the grouped rows or columns and press Alt+Shift+Left Arrow. Grouping adds outline controls so you can collapse detail and bring it back without deleting it.

These shortcuts are useful for making a large worksheet easier to scan—for example, hiding monthly detail beneath a yearly total or tucking away optional columns. Before starting, save your workbook if the layout is important, and make sure you select the rows or columns you intend to organize. Grouping changes the outline structure, not the underlying values.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a version of Excel with the Data tab’s Group and Ungroup commands.
  • A worksheet with the rows or columns you want to organize. You do not need formulas or special data formatting.
  • For the Windows shortcuts, use a keyboard with an Alt key. On a Mac, use Option+Shift+Right Arrow to group and Option+Shift+Left Arrow to ungroup.

Step-by-Step

  1. Identify the detail to group. Decide which rows or columns should be collapsible together. For example, if rows 4 through 9 contain daily figures and row 10 contains a monthly total, you might group rows 4 through 9 so the detail can be hidden while the total remains visible. In general, select the detail rows or columns—not the label or summary you want to keep outside the group.
  2. Select entire rows or columns. To group rows, click the row number of the first row and drag across the row numbers through the last row. To group columns, click the first column letter and drag across the column letters you want. To select a contiguous range, you can also click its first row or column header, hold Shift, and click its last header. Selecting whole rows or columns makes the intended direction clear and helps avoid an unexpected Group dialog.
  3. Create the group with the shortcut. On Windows, press Alt+Shift+Right Arrow. Excel adds an outline bracket alongside the selected rows or above the selected columns, along with a minus button. If Excel shows a Group dialog instead, choose Rows or Columns as appropriate and confirm. The dialog is particularly useful if you selected cells rather than complete row or column headers.
  4. Collapse the grouped detail. Click the minus (−) button at the end of the outline bracket to hide the group. The button changes to a plus (+). The worksheet displays the remaining rows or columns, including any summary row or column you left outside the group. This is a display change: the hidden detail is still in the worksheet.
  5. Expand it when you need the detail. Click the plus button to show the grouped rows or columns again. If the sheet has several groups, use the outline level buttons, usually numbered 1, 2, and so on near the upper-left corner, to show different levels of detail. Level 1 generally shows the most summarized view; a higher level reveals more detail.
  6. Make nested groups when there are several levels. You can group a smaller set of rows inside a larger group—for example, weekly rows inside a monthly block. Select the inner detail rows and apply the grouping shortcut, then select the wider range and group it as well. Collapse the inner group or outer group using its own outline button. Plan the ranges first, because overlapping groups can be harder to understand if their boundaries are unclear.
  7. Ungroup a specific set of rows or columns. Expand a collapsed group first if needed so you can see what it contains. Select the grouped row numbers or column letters, then press Alt+Shift+Left Arrow on Windows. If a dialog appears, choose whether to ungroup rows or columns and confirm. The group’s outline bracket is removed, but the cells and their contents remain in place.
  8. Use the ribbon if you prefer menus. Select the relevant row or column headers, then choose Data > Outline > Group to add a group. To remove a group, select its rows or columns and choose Data > Outline > Ungroup. Ribbon wording or arrangement can vary slightly by Excel build, but the commands are on the Data tab in the Outline group. These commands are also a reliable fallback if a keyboard shortcut is intercepted.
  9. Check the result before moving on. Click the plus and minus controls to confirm the correct detail is hidden and restored. If the wrong rows disappear, expand the group, inspect its bracket, and adjust the selection. For an individual mistake, use Ungroup on the affected range and create the group again with the correct boundaries.

Common Mistakes

  • Selecting the summary row by accident. If a total row should stay visible when detail is collapsed, leave it outside the selected range. For example, group rows 4–9 and leave row 10 unselected if row 10 contains the total.
  • Confusing grouping with hiding. Grouping adds outline controls; it does not erase, move, or calculate data. The plus button or an outline level can reveal the hidden rows again. Manually hidden rows do not necessarily have the same group bracket.
  • Choosing the wrong direction. If you select individual cells, Excel may need to ask whether to group rows or columns. Choose deliberately. Selecting row numbers or column letters first usually avoids this ambiguity.
  • Using Ungroup on the wrong selection. Ungroup removes outline structure from the selected group; it does not delete the values. Still, check the selected headers before using the shortcut, particularly on a sheet with nested groups.
  • Expecting a subtotal automatically. Group and Ungroup only control the outline. They do not insert a SUM formula or create a total. Add summary formulas separately if the worksheet needs them.
  • Assuming every outline button is a separate group. The numbered level buttons show a chosen level of detail across the outline. They are not the same as the plus or minus control for one specific group.

Tips

  • Use clear labels and totals. Keep a descriptive heading or summary outside the detail group when you want it to remain visible in the collapsed view. This makes the compact version useful instead of leaving unexplained figures on screen.
  • Group related blocks consistently. If each month has the same number of detail rows, use matching boundaries for each month. Consistent group sizes make the outline easier for other people to navigate.
  • Use levels for a quick overview. Click a numbered outline level to show all groups at that level, rather than collapsing each one individually. Click a higher level to display more detail again. The exact number of levels depends on how many nested outline layers the worksheet contains.
  • Keep the outline markers in view. Row-group controls typically appear beside the row numbers; column-group controls appear above the column letters. If the controls seem missing, look around the worksheet edges and check whether outline symbols are enabled in Excel’s display settings.
  • Use the menu when the key combination is awkward. On Mac, the Option key may be labeled Alt on some keyboards. If your keyboard, system settings, or browser captures a shortcut, use Data > Group or Data > Ungroup instead.
  • Distinguish a group from a filter. An outline collapses a chosen block of adjacent rows or columns. A filter hides records based on conditions. If you need to show only entries matching a value, use filtering rather than creating many manual groups.

Troubleshooting

The shortcut does nothing. Confirm that Excel has focus and that you selected row or column headers, not just a cell outside the intended range. On Windows, try Alt+Shift+Right Arrow to group and Alt+Shift+Left Arrow to ungroup. On Mac, try the corresponding Option+Shift+arrow combination. If another application or a keyboard utility intercepts the keys, use the Data tab commands.

Excel asks whether to group rows or columns. This can happen when you selected cells rather than whole rows or columns. Choose the correct option in the dialog. To avoid the prompt next time, select the row numbers or column letters before grouping.

No plus or minus buttons appear. First check whether the selected range actually became a group. Look for a thin outline bracket along the edge of the selected rows or columns. If there is no bracket, select the range again and use Data > Outline > Group. If a group exists but its symbols are hidden, open Excel’s display options and enable outline symbols when an outline is applied. In desktop Excel, this setting is under File > Options > Advanced, in the display options for the worksheet.

The wrong rows or columns collapse. Expand the group and compare the bracket endpoints with the row numbers or column letters. Ungroup the incorrect range, select the intended headers, and create it again. If there are nested groups, test one bracket at a time so you can identify which level controls the unexpected change.

Ungroup does not remove everything. The selection may include only part of a group, or the outline may contain nested groups. Select the specific grouped headers and repeat Ungroup for each level that you want to remove. To remove all outline groupings from the current worksheet, use Data > Outline > Ungroup > Clear Outline if that command is available in your Excel build. Clearing the outline removes group structure from the sheet, so use it only when you intend to discard all its groups.

The steps differ in Excel for the web. Keyboard behavior can depend on the browser and its shortcuts. Use the Data tab’s Group or Ungroup command if the key combination does not work. In Excel for Mac, use the Mac shortcut given above or the ribbon command; the Windows Alt key combination is not the Mac equivalent.

Frequently Asked Questions

What is the shortcut to group rows in Excel?
In desktop Excel for Windows, select the row headers and press Alt+Shift+Right Arrow. On Mac, use Option+Shift+Right Arrow.

What is the shortcut to ungroup rows in Excel?
Select the grouped row headers and press Alt+Shift+Left Arrow on Windows. On Mac, use Option+Shift+Left Arrow. If Excel asks, confirm that you mean rows.

Can I use the same shortcuts for columns?
Yes. Select the column letters you want to group or ungroup, then use the same right-arrow shortcut to group or left-arrow shortcut to ungroup. The selected headers tell Excel that the operation applies to columns.

Does grouping delete or change my data?
No. Grouping creates an outline that can hide and show the selected rows or columns. It does not remove their contents or automatically create totals. Ungrouping removes the outline structure, not the cell values.

How do I show all grouped rows again?
Click the plus button beside each collapsed group, or use a higher outline level button to reveal more detail across the sheet. If the controls are not visible, check the worksheet’s outline-symbol display setting.

Can I group non-adjacent rows with one shortcut?
Outline groups are designed around contiguous blocks. For separate sections, create a group for each block. If you need to display records based on shared values rather than fixed blocks, use Excel’s filter tools instead.

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.