How to Ungroup Rows in Excel With a Keyboard Shortcut

How-to basics · Updated November 20, 2026

To ungroup rows in Excel for Microsoft 365 on Windows, select the grouped rows by their row numbers, then press Alt+Shift+Left Arrow. This removes the row outline grouping; it does not delete the rows or their contents. If the shortcut is unavailable, use Data > Outline > Ungroup.

What You’ll Need

  • A workbook with rows grouped using Excel’s Outline feature. Grouped rows usually have brackets and level buttons, such as 1, 2, or 3, beside the worksheet.
  • Permission to edit the sheet. If the worksheet is protected, you may need the password or the owner’s help before changing its outline.
  • A keyboard with an accessible Left Arrow key. On some laptops, you may need to hold Fn to use the arrow key as a standard key.

Step-by-Step

  1. Open the worksheet and find the outline. Look to the left of the row numbers for a vertical bracket connecting rows, a small plus or minus button, or outline level buttons near the upper-left corner of the grid. These controls indicate that rows are grouped. A minus button generally means that group is expanded; a plus means it is collapsed.
  2. Decide which group to remove. If the sheet has several separate groups, identify the bracket covering the rows you want to ungroup. For example, a monthly report might have one group for each month and a separate group for the year total. Ungroup only the relevant rows if you want to preserve the other groups.
  3. Select the grouped rows using their row headings. Click the number of the first row in the group, then drag down the row-number headings to the last row in that group. To select a range without dragging, click the first row heading, hold Shift, and click the last row heading. Selecting row headings makes the intended row operation clear and helps avoid acting on a column group instead.
  4. Press the ungroup shortcut. On Windows, press Alt+Shift+Left Arrow once. Use the left-arrow key, not the minus key. Excel removes the grouping level that applies to the selected rows. The shortcut is the inverse of Alt+Shift+Right Arrow, which groups selected rows or columns.
  5. Check the result before making other changes. Look at the outline brackets and level buttons again. The bracket for the group you removed should disappear or change, while other groups should remain. The rows themselves and their cell values are not deleted by this command.
  6. Use the ribbon if the shortcut does not work. Select the grouped row headings, open the Data tab, and choose Ungroup in the Outline group. If Excel displays an Ungroup dialog because the selection could refer to rows or columns, choose Rows and confirm. If the dialog does not appear, Excel applies the command to the selected outline.
  7. Repeat for other groups only as needed. Select the next group and use the shortcut again. Avoid selecting the whole worksheet unless you intend to remove multiple outline groups; a broad selection can change more of the outline than you meant to.

On a Mac: In Excel for Mac, the corresponding shortcut is generally Option+Shift+Left Arrow. Keyboard layouts and macOS shortcuts can affect whether a key combination is available, so use Data > Ungroup if it does not respond. In Excel for the web, use the Data tab’s Ungroup command if the desktop shortcut is unavailable or intercepted by your browser.

Common Mistakes

Confusing hiding with grouping: Grouping creates an outline bracket and controls. Manually hidden rows may have no group bracket at all. The ungroup shortcut removes an outline level; it is not the same as unhiding rows. If rows were hidden manually, select the surrounding row headings, right-click, and choose Unhide, or use Home > Format > Hide & Unhide > Unhide Rows.

Selecting cells rather than the intended rows: Excel can often infer the relevant outline from a cell selection, but that is less clear when a sheet contains both row and column groups or multiple levels. Select the row-number headings for the target range so the action is unambiguous.

Removing the wrong level in a nested outline: A worksheet can contain groups inside other groups—for example, individual weeks inside a monthly group. If the selected rows belong to more than one level, the change may affect a level you wanted to keep. Work on one clearly identified group at a time, then inspect the outline before continuing.

Expecting the shortcut to delete rows: Ungrouping changes the outline structure, not the worksheet’s data. If your goal is to remove the actual rows and their contents, that is a separate delete operation. Conversely, if rows disappear from view after ungrouping, do not assume their contents were erased; check for hidden rows or a collapsed remaining group.

Using the grouping shortcut by mistake: The right-arrow version groups; the left-arrow version ungroups. Check which arrow you are pressing before using the shortcut, especially if your keyboard has small or shared arrow keys.

Tips

Expand a group before inspecting its contents. Click its plus button to show the rows, if needed. This makes it easier to identify the exact range and distinguish a nested group from the larger group around it. Expanding is optional; it changes what you can see, not whether the rows are grouped.

Use outline levels to understand a complicated sheet. The numbered buttons above the row headings show different summary levels. Clicking a level changes how much detail is displayed; it does not ungroup rows. Use the brackets to locate the group to remove, and use the numbered buttons only to change the current display.

Keep a copy when the outline is important. If the sheet has a complex, hand-built outline, save a copy of the workbook before removing many groups. Ungroup is usually straightforward to undo immediately with Ctrl+Z on Windows or Command+Z on Mac, but a saved copy is a useful fallback if you continue editing or are unsure which levels changed.

Use the ribbon for precision. The Data tab is a good alternative when keyboard shortcuts are intercepted by another app, when you are working on a Mac with a different keyboard layout, or when Excel asks whether to ungroup rows or columns. It also makes the action easier to spot for someone reviewing your steps.

Remember that grouping and filtering are different. A filter hides rows that do not match criteria, while an outline group lets you collapse and expand a chosen range. Ungrouping will not clear a filter. If rows remain out of sight and there is no relevant outline bracket, check the filter controls in the header row.

Troubleshooting

The shortcut does nothing: First click inside the worksheet, confirm that the target rows are grouped, and select the row headings. Press the keys together rather than typing them one at a time. On a laptop, try holding Fn if the arrow keys share another function. If the combination is still ignored, use Data > Outline > Ungroup. In a browser, another shortcut handler may capture the keys, so the ribbon is often the simplest option.

Ungroup is unavailable or dimmed: Check that the selection overlaps an existing outline group. If there is no bracket or outline control beside the rows, they may not be grouped. Also check whether the sheet is protected: go to Review > Unprotect Sheet if that command is available and you have permission to unprotect it. A protected workbook or restricted editing permission can prevent outline changes.

The wrong rows or level changed: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac. Then select a smaller, clearly defined range of row headings and try again. For nested outlines, test one group at a time and check the bracket after each operation rather than applying the shortcut to a large block.

The rows are still not visible: Ungrouping is not a guarantee that every hidden row will appear. Check whether another outer group is still collapsed, whether a filter is active, or whether rows were hidden manually. Expand remaining outline groups with their plus buttons, clear or adjust filters as appropriate, or select the rows around the hidden range and choose Unhide.

The outline brackets are gone, but you still see level buttons: Excel may retain outline controls for other groups elsewhere on the sheet. Inspect the brackets and test the relevant rows rather than assuming all grouping has been removed. If you truly want to remove the entire outline structure, use Data > Outline > Ungroup as needed for the affected ranges; do not choose a clear-outline command unless you intend to remove the worksheet’s outline structure more broadly.

Frequently Asked Questions

What is the shortcut to ungroup rows in Excel?
In Excel for Microsoft 365 on Windows, select the grouped row headings and press Alt+Shift+Left Arrow. On Mac, try Option+Shift+Left Arrow; use the Data tab if the shortcut is unavailable.

Does ungrouping rows delete data?
No. Ungroup removes an outline grouping, not the rows, formulas, or cell contents. If rows remain hidden, check for a collapsed parent group, a filter, or manual hiding.

How do I ungroup only one section?
Select the row headings covered by that section’s outline bracket, then use the shortcut once. Check the bracket afterward to confirm that the intended group changed and nearby groups remain.

Can I ungroup rows without a keyboard shortcut?
Yes. Select the grouped rows, then choose Data > Outline > Ungroup. If Excel asks you to choose, select Rows.

Why do I see a plus or minus sign instead of the rows?
The group is collapsed or expanded. Click the plus sign to show collapsed detail rows or the minus sign to collapse them. Those controls change visibility; they do not remove the grouping.

Can I undo an ungroup action?
Usually, yes, immediately after the change: press Ctrl+Z on Windows or Command+Z on Mac. If you have made many later edits, restoring a saved copy may be safer than undoing a long sequence.

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.