Excel Group Rows: How to Add and Use the Drop-Downs

To group rows in Excel for Microsoft 365 on Windows, select the rows using their row numbers, then choose Data > Outline > Group. Excel adds outline controls beside the worksheet so you can collapse the group with a minus button and expand it again with a plus button; these are outline controls, not drop-down menus inside cells.

What Excel’s row-group drop-down means

People often call the controls for grouped rows a drop-down because they let you open and close a section of a worksheet. In Excel, the feature is called an outline. A small minus sign appears beside an expanded group. Click it to hide the grouped detail rows; the sign changes to a plus, which you can click to show those rows again. The data remains in the worksheet when the group is collapsed.

Outline level buttons, usually numbered 1, 2, and sometimes higher, appear near the upper-left corner of the sheet when an outline exists. They show different levels of summary. For example, level 1 might show only a grand total, level 2 might show each department total, and the highest level might show every detail row. The exact number of levels depends on how many nested groups the sheet contains.

This is different from a filter drop-down, which filters a table or range to show records that meet criteria, and from a data-validation drop-down, which lets someone choose a value in a cell. Grouping is for temporarily hiding and revealing rows while keeping the worksheet’s structure and underlying data intact.

How to group rows step by step

Arrange the worksheet so the detail rows you want to hide sit together. If useful, place a subtotal or other summary row immediately before or after each detail section.
Select the row headers for the rows to group. For example, click row 5, then drag down to row 12, or click row 5 and Shift-click row 12. Selecting the row numbers makes it clear that you are grouping rows rather than columns.
On the ribbon, choose Data > Outline > Group. If Excel asks whether to group Rows or Columns, choose Rows.
Look to the left of the row numbers for the outline bracket and minus button. Click the minus to collapse the selected rows. Click the resulting plus to expand them.

You can also select cells within the rows instead of selecting the row headers, but selecting whole rows avoids ambiguity. If the selection includes a summary row that should remain visible, leave that row out of the group. For instance, to keep a total in row 13 visible while hiding details in rows 5 through 12, group rows 5 through 12 only.

To remove an outline group without deleting worksheet data, select its rows and choose Data > Outline > Ungroup. If the selection contains multiple nested levels, Excel may ask which level to remove. The Clear Outline command removes outline grouping from the sheet; use it only when you intend to remove all the groups, not just collapse them.

How to collapse, expand, and use outline levels

For a single group, the plus and minus controls are the quickest way to hide or reveal detail. For several groups, the numbered outline buttons provide a broader view. Clicking a lower-numbered level hides more detail; clicking the highest available level shows the most detail. These buttons are especially useful in a monthly report where each month has its own detail rows and subtotal.

For example, imagine a sales sheet with rows for individual transactions, a subtotal after each salesperson, and a grand total at the bottom. Group the transactions under each salesperson’s subtotal. You can click each minus button to close one salesperson’s section, or use an outline level to show a more summarized view of the whole report. The subtotal formulas remain visible if you have placed them outside the grouped detail rows.

Excel can create nested groups too. You might group daily rows within each month, then group the monthly sections into quarters. When nested groups are present, clicking a control for an outer group can hide everything inside it, while inner controls manage smaller sections. Keep the hierarchy logical and test each outline level so readers can tell what information is being hidden.

Set up summary rows and automatic outlines

A useful outline usually has a clear summary row beside or below the detail it summarizes. Excel’s default behavior places summary rows below detail rows. To change the placement, open the Outline settings from the Data tab’s Outline group and adjust Summary rows below detail. The setting affects how Excel interprets summary rows when creating an outline; check the resulting brackets and controls after changing it.

If the sheet already contains subtotal formulas, Excel may be able to build groups for you. Choose Data > Outline > Auto Outline. Auto Outline looks for patterns in the data and formulas that indicate summary rows, then creates an outline based on what it recognizes. It is not a general-purpose way to group any arbitrary block: inconsistent formulas, missing subtotals, or an unusual layout can lead to an outline that does not match your intended sections. Review the result and use manual grouping when you need precise control.

Before creating many groups, consider whether sorting or inserting rows will change the relationship between details and summaries. Grouping is most dependable when each detail block is contiguous and its summary row is clearly separated. A neat structure also makes the worksheet easier to maintain for colleagues who did not create it.

Common problems and fixes

No plus or minus buttons are visible: Check that a group was actually created and that outline symbols are enabled. In Windows Excel, open File > Options > Advanced, find the display options for this worksheet, and check Show outline symbols if an outline is applied. Also look for hidden worksheet rows or a narrow window that makes controls hard to see.
Group is unavailable or Excel asks Rows or Columns: Select the intended row headers and try again. If the worksheet is protected, protection settings may prevent outlining; the sheet may need to be unprotected or configured to allow outline use.
Clicking a control hides a subtotal too: The summary row may be inside the grouped selection. Ungroup the affected rows and recreate the group without including the subtotal row.
Only part of the intended section collapses: Check the group bracket and selected row range. Adjacent groups, nested levels, or gaps in the selected rows can make the outline behave differently from a single continuous section.
Outline symbols vanish after sharing or editing: Confirm the recipient is opening the workbook in an Excel version that supports the outline controls and that the worksheet is not protected in a way that prevents their use. The rows themselves are not deleted by collapsing a group.

It is worth distinguishing a collapsed group from deleted or filtered data. A collapsed group hides rows but leaves them in place. A filter changes which records are displayed according to filter criteria. If a user needs to find rows by a field such as region, status, or date, a filter is usually more suitable than manually opening groups.

Grouping compared with hiding rows and filtering

Manual hiding is appropriate for a few isolated rows, but it does not provide the same expandable hierarchy as an outline. To hide rows, select their row headers, right-click, and choose Hide; use Unhide to restore them. With grouped rows, the visible outline buttons communicate that detail is available and offer a quick way to reveal it.

Filters are better when users need to display records that match changing conditions. For example, a filter can show only transactions for one region, while row grouping can keep each region’s detail tucked under a visible subtotal. A worksheet can use both, but filtering and outlining solve different problems. Avoid using grouping as a substitute for a well-structured Excel Table when the main task is sorting, filtering, and adding records.

Excel for Mac and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. Excel for Mac also supports row outlines, but ribbon organization and keyboard shortcuts can differ by release. Look on the Data tab for the grouping and ungrouping commands; if the Windows path or dialog is not identical, use the Mac ribbon’s Group control rather than assuming the Windows menu layout.

On Windows, the standard shortcuts are Alt+Shift+Right Arrow to group the selected rows and Alt+Shift+Left Arrow to ungroup them. On Mac, the corresponding outline shortcuts commonly use Option+Shift+Right Arrow and Option+Shift+Left Arrow; keyboard mappings can vary with the Excel build and system settings. Menu commands are a dependable alternative if a shortcut is intercepted by macOS or does not work on your keyboard.

Excel for the web has a different ribbon layout from desktop Excel, and available outline commands can depend on the current web interface and workbook. Look under the Data tab for grouping controls. If the command is unavailable or you need outline settings not exposed in the browser, open the workbook in the desktop app. Confirm the workbook is saved before switching apps, especially when several people are editing it.

Frequently Asked Questions

How do I add a drop-down arrow to grouped rows in Excel?
Excel normally uses plus and minus outline buttons, not a drop-down arrow. Select the row headers and choose Data > Outline > Group; then use the minus button to collapse the rows and the plus button to expand them.

How do I group rows without hiding the subtotal?
Select only the detail rows and leave the subtotal row outside the group. If the subtotal disappears when you collapse the section, ungroup the rows and create the group again with a narrower selection.

Can I group non-adjacent rows?
An outline group is intended for a continuous block of rows. For separate sections, create separate groups rather than expecting one group control to manage scattered rows.

How do I remove grouping but keep the rows?
Select the grouped rows and choose Data > Outline > Ungroup. Ungrouping removes the outline structure; it does not delete the row contents. Use Clear Outline only if you want to remove all outline groups from the worksheet.

Why can’t I see the outline buttons?
Check that rows are grouped and that outline symbols are enabled in Excel’s advanced worksheet display options. Also check whether the sheet is protected or whether the controls are obscured by the worksheet window.

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.