To hide columns that readers can reopen with a plus button, select the columns, choose Data > Group, and then click the minus button that appears above the column headings. Excel collapses the grouped columns and changes the control to a plus button; clicking the plus expands them again. This is different from ordinary Hide, which conceals columns but does not create an expand control.
What the expand button does
Excel’s expand and collapse controls are part of its worksheet outline feature. Grouping adds an outline around a set of rows or columns. The group is initially expanded, so its contents remain visible; click the minus sign to collapse it. The grouped columns disappear from view, and the minus changes to a plus sign that restores them when clicked.
Outline controls are useful when a worksheet contains detail that some readers need only occasionally. For example, a monthly sales report might show the product name and total by default while grouping columns for January through December. A reader can collapse those month-by-month figures to focus on the total, then expand the group to inspect the monthly breakdown.
The buttons do not delete or protect data. Collapsing a group only changes what is displayed on the worksheet. Formulas that refer to the hidden cells continue to calculate, and users who can edit the workbook can expand the group or use other methods to reveal the columns.
Group columns and add the control
In Excel for Microsoft 365 on Windows, use the column headings to select the columns you want to put behind the expand button. Selecting whole columns makes it clear that you want a column outline rather than a row outline.
- Click the letter of the first column, then drag across the column letters to select the full range. For example, select C through E to group columns C, D, and E.
- Open the Data tab and choose Group in the Outline area. If Excel asks whether to group Rows or Columns, choose Columns.
- Look above the selected columns for the outline control. Click the minus sign to collapse the group. Excel hides the grouped columns and displays a plus sign.
- Click the plus sign when you want to show the columns again.
You can also select a range of cells within the columns, but selecting the column letters is the clearest approach, especially when the worksheet has both row and column groups. On Excel for Mac, the outline feature is available from the Data tab as well; ribbon labels or placement can vary by release. If a keyboard shortcut differs or is unavailable, use the ribbon command. Excel for the web may present a more compact ribbon, so check its Data tab for Group and Ungroup.
Collapse, expand, and use outline levels
A plus button appears only after a group has been collapsed. When the group is expanded, the corresponding control is a minus sign. The control is an interaction for the outline, not a permanent graphic or a button inserted into a cell. It is normally shown above the column headings, close to the columns it controls.
When a sheet has several groups, Excel can show outline level buttons labeled 1, 2, and so on near the upper-left edge of the worksheet. These provide a quick way to display a broader summary or more detail across the outline. For instance, a workbook with several groups can use a lower level to show its summarized layout and a higher level to show more of the grouped columns. The plus and minus controls still let a reader expand or collapse an individual group.
Groups can also be nested. If you group a small set of columns inside a larger group, the outline can show more than one level of detail. Plan the ranges before adding nested groups: overlapping or confusing outlines can be harder to navigate than a simple set of separate groups. If the controls seem to affect more columns than expected, inspect the outline levels and the selected group boundaries.
Grouping versus ordinary Hide
Both methods make columns disappear from the normal worksheet view, but they serve different purposes. Use Group when readers should have an obvious, repeatable way to reveal detail. Use Hide when you simply want to keep columns out of view and do not need an outline control.
- Group: Adds outline controls, supports collapse and expansion, and can organize levels of detail.
- Hide: Conceals selected columns without adding a plus or minus control. A reader usually reveals them by selecting the columns around the hidden range and using Unhide.
- Filter: Hides rows that do not match filter criteria; it is not a replacement for grouping columns.
For ordinary hiding in Windows Excel, select the column or columns, then choose Home > Format > Hide & Unhide > Hide Columns. The Windows shortcut Ctrl+0 also hides selected columns in many Excel setups. To unhide manually, select the visible column headings on both sides of the hidden range, then choose Home > Format > Hide & Unhide > Unhide Columns. On a Mac, use the ribbon path if the keyboard shortcut is unavailable or conflicts with macOS settings.
Neither hiding nor grouping is a security measure. Hidden values can still be exposed by expanding a group, unhiding columns, or inspecting the workbook. If information must not be available to a particular audience, do not rely on a hidden-column arrangement as access control.
Set which side contains the outline controls
Excel generally places column outline controls above the column headings. Their exact position relative to the grouped columns depends on the outline and summary settings. By default, summary columns are commonly placed to the right of the detailed columns, but a workbook may be configured differently. This can make a group appear to collapse toward a different side than expected.
In Windows Excel, open the Data tab and use the dialog launcher in the Outline group to review the outline settings. The setting Summary columns to right of detail controls the usual placement convention for summary columns. If the worksheet uses a summary column on the left, changing this option can make the outline behavior and controls easier to understand. Take care when changing settings in a workbook that already has several outlines; check the resulting layout rather than assuming every group will be arranged as before.
If the worksheet has an outline but its symbols are missing, check the display option for the current sheet. In Windows, go to File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if an outline is applied. The selected worksheet matters because this is a per-worksheet display setting. On Mac, look for the corresponding outline display setting in Excel’s preferences or workbook options; the exact location can differ between releases.
Common problems and fixes
- No plus or minus appears: Confirm that you used Data > Group rather than Home > Format > Hide & Unhide > Hide Columns. Also check that outline symbols are enabled for the worksheet.
- The columns are still visible after grouping: Grouping creates the outline but does not necessarily collapse it immediately. Click its minus sign to hide the detail.
- The wrong range disappears: Expand the group, review the column letters selected when creating it, and remove or rebuild the outline if its boundaries are incorrect.
- Unhide does not restore the columns: The columns may be inside a collapsed group. Click the plus control first. If they were hidden manually, select the columns on both sides of the hidden range and use Unhide Columns.
- The outline controls disappeared after copying or changing the sheet: Check the worksheet’s outline-symbol display setting and whether the outline itself remains. Copying cells alone does not necessarily reproduce the outline structure.
To remove a group but keep its columns visible, select the grouped columns and choose Data > Ungroup. If you want to remove all outline groups from a worksheet, use the Clear Outline command from the Ungroup menu, where available. Clearing an outline removes the grouping structure; it is not the same as deleting the columns or their contents. If the columns were also manually hidden, you may still need to unhide them separately.
When to use an expand button
A grouped outline is most helpful when the workbook has a stable detail-and-summary structure. Examples include weekly figures under a monthly total, component costs beneath a project total, or optional supporting measures beside a key report. Keep the summary information visible and group only the detail that readers may want to inspect. That makes the collapsed view useful on its own instead of leaving a confusing gap.
For a simple one-off cleanup, manual hiding may be quicker and less visually busy. For worksheets that readers will revisit, grouping communicates that concealed columns are intentionally available. For very wide tables that users need to explore in many ways, consider whether a separate detail sheet, a PivotTable, or a filtered table would be easier to navigate. Those alternatives organize information differently; they do not create the same plus button over a chosen set of columns.
Before sharing a workbook, test the collapsed and expanded views, confirm the summary columns remain understandable, and save the workbook after setting the desired starting view. A reader can still change that view, but a saved collapsed outline can make the initial presentation more concise.
Frequently Asked Questions
Can I hide columns and show a plus button without grouping?
Not with Excel’s standard Hide command. Use Data > Group to create an outline, then collapse it with the minus control. The resulting plus button expands that group.
How do I expand hidden columns in Excel?
Click the plus sign associated with the collapsed group. If there is no plus sign, the columns may have been hidden manually; select the headings on either side and use Home > Format > Hide & Unhide > Unhide Columns.
Does grouping columns delete their contents or formulas?
No. Grouping and collapsing only change what is displayed. Cell values and formulas remain in the worksheet, and formulas can continue to use the grouped cells.
Can I group nonadjacent columns under one expand button?
Excel’s outline groups are based on contiguous ranges. For separated ranges, create separate groups or reorganize the worksheet so the related detail columns sit together.
Why can’t I see outline buttons in Excel?
The group may not be collapsed, the range may not actually be grouped, or outline symbols may be turned off for that worksheet. In Windows, check File > Options > Advanced > Display options for this worksheet and enable Show outline symbols if an outline is applied.
Related
- Excel File Corrupted? How to Recover and Repair It
- Excel Group By and Remove Duplicates: How to Choose
- Excel Not Responding? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Share an Outlook Calendar Between Two DomainsYes. You can share an Outlook calendar with someone whose email address belongs to another domain, provided your…
- Excel Find and Replace Part of a String in a Cell or RangeTo replace part of a string in Excel, press Ctrl+H on Windows, enter the text to find and…
- How to Add or Remove a Draft Watermark in Microsoft WordTo add a Draft watermark in Word for Microsoft 365 on Windows, open the document and choose Design…
- Excel Heat Map Colours: How to Apply and Choose ThemIn Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional Formatting >…
- How to Change a Date Format to a Custom Format in ExcelTo change a date to a custom format in Excel for Microsoft 365 on Windows, select the date…
- Automatic Text to Columns in Excel: Options and LimitsExcel does not have a built-in setting that automatically runs Text to Columns whenever you type or paste…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.