To hide columns and keep a plus sign you can click to show them again, group the columns: select their column letters, choose Data > Group, and collapse the group with the minus sign that appears above it. The control changes to a plus sign; click it to expand the columns. This uses Excel’s outline feature, rather than the standard Hide command, so you can reveal the columns without selecting the hidden range.
The steps below are for Excel for Microsoft 365 on Windows. Save a copy first if the workbook is important, and make sure you can edit its structure. The columns can contain data or formulas; grouping only changes whether they are displayed, not their contents.
What You’ll Need
- An Excel workbook that you can edit.
- The column letters for the columns you want to collapse. Adjacent columns are simplest to manage as one group.
- Access to the Data tab. If the sheet is protected or the workbook is open in a restricted view, you may need permission to change its outline.
Step-by-Step
- Open the worksheet and identify the columns. Find the column letters at the top of the grid, such as C, D, and E. Check the data before grouping so you do not accidentally include a column you want to keep visible. Grouping does not delete values, formulas, formatting, or other worksheet content.
- Select the columns as whole columns. Click the first column letter, then drag across the column-letter headers to the last column you want to hide. For example, drag from C to E to select columns C:E. To select a range that is not visible all at once, click the first header, hold Shift, and click the last header. If you need separate, nonadjacent groups, create each group separately rather than trying to collapse unrelated columns as one range.
- Open the grouping command. On the ribbon, select Data > Group, in the Outline area. If you selected whole columns, Excel will usually recognize that you want to group columns. If a Group dialog asks whether to group Rows or Columns, choose Columns and confirm. Do not choose Rows: that would add outline controls beside the row numbers instead.
- Check that Excel created a group. Look above the worksheet grid, around the letters for the selected columns. You should see an outline bracket spanning the grouped columns and a minus sign control. The bracket marks the range that will collapse. If the bracket or control is not visible, see Troubleshooting below before repeating the selection.
- Collapse the columns. Click the minus sign above the group. Excel hides the grouped columns from view, and the control changes to a plus sign. The column letters for the hidden range disappear from the visible sequence; for example, after collapsing C:E, the next visible column may be F. The plus sign is the control for expanding that specific group.
- Expand the columns when needed. Click the plus sign once. The hidden columns return, and the control changes back to a minus sign. You can collapse and expand the group as often as you like. This is useful when a sheet has optional detail, such as monthly figures beside a yearly summary.
- Save the workbook. Save after setting up the outline so the grouped state is retained with the workbook. If you share the file, tell collaborators that the plus sign expands the hidden detail. They can use the control without changing the underlying values.
- Remove the grouping if you no longer need it. Expand the columns first if you want to see the range, select the grouped columns, then choose Data > Ungroup. If you want to remove every outline on the worksheet, use the menu beside Ungroup and choose Clear Outline where that option is available. Ungrouping removes the plus/minus controls; it does not delete the columns or their contents.
Keyboard option on Windows: After selecting the columns, press Alt+Shift+Right Arrow to group them. Use Alt+Shift+Left Arrow to ungroup a selected outline. The ribbon path is easier to verify if your keyboard layout or Excel version handles a shortcut differently. In Excel for Mac, select the columns and use Data > Group; shortcuts can differ by keyboard and settings. Excel for the web may show a different ribbon layout, so use the Data tab if Group is available, or choose Open in Desktop App if it is not.
Common Mistakes
- Choosing Hide instead of Group. The command Home > Format > Hide & Unhide > Hide Columns hides a selection, but it does not create an outline plus sign. Use Data > Group when you want a clickable expand/collapse control. You can unhide ordinary hidden columns later, but that is a different workflow.
- Selecting cells instead of the column headers. If you drag across cells, Excel might group rows or make a different selection than intended. Select the letters at the top of the sheet to make the column choice clear, and choose Columns if Excel asks.
- Clicking the wrong outline control. A worksheet can have several groups, each with its own bracket and plus/minus sign. Follow the bracket that spans the columns you intend to hide. A control for a nested group may collapse only part of a larger range.
- Assuming a collapsed group is deleted. The data is still present. Formulas that refer to grouped columns generally continue to calculate, and expanding the group restores the display. Do not clear contents or delete columns just to make them disappear temporarily.
- Grouping a very large range by accident. Selecting the corner button between the row numbers and column letters selects the entire worksheet. Check the highlighted headers before choosing Group so you do not create an outline for more columns than intended.
Tips
- Use a summary next to the details. For a report, keep totals or key results visible and group the supporting columns. For example, leave a yearly total outside the group and place monthly breakdown columns inside it. Readers can scan the summary, then click plus to inspect the detail.
- Give groups a clear structure. A group should represent columns that belong together, such as quarterly values or optional assumptions. Consider adding a visible heading or note near the group so people understand what the plus sign will reveal.
- Use nested groups sparingly. You can create smaller groups inside a larger group to let readers reveal detail in stages. First group the inner ranges, then create the larger group around them. Test each plus and minus control so the levels behave as you expect.
- Know what the outline level buttons do. When groups exist, Excel may show numbered level buttons such as 1 and 2 near the upper-left of the worksheet. Clicking a level displays that outline level across the sheet; it is not the same as expanding just one group. Use the individual plus sign when you want to change only one range.
- Remember that grouping is a display aid, not security. Anyone with access to the workbook may expand the columns and view their contents. Do not use a collapsed group to protect confidential information. Use appropriate access controls or remove sensitive data if it should not be shared.
- Keep the group manageable. A narrow group is easier to understand and less likely to hide useful labels. Include only the columns that readers are meant to reveal together, and check the worksheet at both expanded and collapsed levels before sharing.
Troubleshooting
I do not see a plus sign. First check whether the columns were grouped: look for an outline bracket above the headers. If there is no bracket, select the column letters again and use Data > Group, choosing Columns in the dialog if prompted. If a bracket exists but the group is expanded, click its minus sign; the plus sign appears after the group collapses.
The bracket and controls are missing even though I grouped the columns. In Windows Excel, open File > Options > Advanced. Under Display options for this worksheet, check that Show outline symbols if an outline is applied is enabled for the correct worksheet. If the workbook has several sheets, confirm you are changing the setting for the sheet you are viewing. On Mac, check Excel’s View settings for the outline-symbol display option; wording and placement can vary by release.
Excel grouped rows instead of columns. Undo immediately with Ctrl+Z on Windows (Command+Z on Mac), select the column headers rather than cells or row numbers, and group again. If you do not want to undo, select the mistaken row group and choose Data > Ungroup, then make the column group.
The Group command is unavailable. Check whether the worksheet is protected. A protected sheet can prevent outline changes unless the protection settings allow them. If you are authorized to change the sheet, use Review > Unprotect Sheet and enter the password if required; otherwise ask the workbook owner. Shared-workbook restrictions or a limited web interface can also affect commands, so try opening the workbook in desktop Excel if appropriate.
The plus sign expands the wrong columns. You may have clicked a control for another group, or the outline may contain nested ranges. Expand the groups, inspect the brackets, and use Data > Ungroup on the incorrect range before creating the intended group again. Avoid Clear Outline unless you want to remove all outline groupings on the sheet.
Frequently Asked Questions
Does the plus sign delete or erase the columns?
No. It collapses a grouped range so the columns are out of view. The values and formulas remain in the worksheet, and clicking plus displays them again. Grouping is reversible and is not a way to remove data.
Why does Excel show a minus sign before a plus sign?
The minus sign means the group is currently expanded. Click minus to collapse it; after that, Excel displays plus as the control to expand the hidden columns. The sign changes according to the group’s current state.
Can I put a plus sign beside the column letters?
Excel places outline controls near the top of the grouped columns, above the worksheet grid, rather than inserting a plus character into a cell or the column header. The exact position can depend on the group range and outline settings. Use the bracket to identify which columns the control affects.
Can I group columns that are not next to each other?
Create separate groups for separate ranges. For example, group C:D, then group F:G. Each range gets its own outline control, which makes it possible to collapse one set of columns while leaving the other visible. Avoid treating gaps between ranges as part of a group unless you also want those columns hidden.
Will the plus sign still work when I share the workbook?
Usually, the outline is saved with the workbook and can be expanded by someone who can interact with the worksheet. Protection settings, file format, or the app used to open it can limit editing or affect the controls. Share an Excel workbook format and ask the recipient to use desktop Excel if the outline controls are unavailable in their version.
Related
- Excel Letter Count: Count Letters and Characters in Cells
- Excel Very Slow Loading Data? Causes and Fixes
- How to Calculate VaR 99 in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Today in Google Sheets: How the TODAY Function WorksTo show today’s date in Google Sheets, enter =TODAY() in a cell and press Enter. The function returns…
- Brochure in Word: Layout, Design, and Printing TipsYes—you can make a brochure in Microsoft Word, either by customizing a brochure template or by setting up…
- Excel Not Responding and Unsaved? Recover Your WorkIf Excel is not responding and your work is unsaved, wait briefly and avoid repeatedly clicking; the app…
- Tableau Export to Excel: Steps, Limits, and OptionsTo export a Tableau view to Excel, open the view and choose Download > Crosstab, then select the…
- Conditional Formatting Across Sheets in Excel: How It WorksYes, Excel can use conditional formatting to compare cells on one worksheet with values on another, but a…
- Microsoft Excel Find Circular References: A Clear GuideTo find a circular reference in Microsoft Excel for Microsoft 365 on Windows, select Formulas > Error Checking…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.