Office Settings & Configuration

How to Fix Missing Plus and Minus Group Buttons in Excel

Algirdas Jasaitis Oct 22, 2026 868 views

Question details

The user needs to restore the missing plus (+) and minus (-) outline symbols used for expanding and collapsing grouped rows in a spreadsheet.

How to Fix Missing Plus and Minus Group Buttons in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working with grouped rows or columns where the outline controls have disappeared from the interface, even though the data is still functionally grouped.
Observed behavior: The plus and minus buttons for grouped data are hidden or missing from the worksheet margins.

Before you start

Ensure your worksheet is not protected, as worksheet protection can sometimes restrict formatting changes or hide specific outline controls.

Solution 1Recommended

Adjust Row Height to Reveal Hidden Outline Buttons

Zero-height or hidden rows can obscure the grouping symbols. Unhiding them restores the visibility of the plus and minus buttons.

If rows within your grouped section are accidentally hidden or have their height set to zero, the outline controls tied to those rows will vanish from the margin.

Select the entire worksheet

Click the top-left corner triangle between the row numbers and column letters, or press 'Ctrl + A' to select all cells in the worksheet.

Open Row Height formatting

Navigate to the 'Home' tab, locate the 'Cells' group, click on 'Format', and select 'Row Height' from the dropdown menu.

Set a visible row height

Enter a standard visible value, such as 15 or 20, into the Row Height dialog box and click 'OK'.

Verify button visibility

Check the left margin of your worksheet. The plus and minus buttons for your grouped rows should now be visible.

Adjust Row Height to Reveal Hidden Outline Buttons

Quick Check: If you only want to adjust a specific range, just highlight the rows above and below the grouped section instead of the entire worksheet.

Solution 2

Enable Outline Symbols in Advanced Options

Excel has a specific setting that globally hides or shows outline symbols for the active worksheet.

Solution 3

Remove Problematic Custom Views

Custom views can save specific hidden states that override your standard outline visibility.

Manage Spreadsheet Outlines

Easily Group and Manage Data with WPS Spreadsheet

WPS Spreadsheet offers intuitive grouping features with clear outline symbols, ensuring your data management is hassle-free without complex settings to troubleshoot.

1. Open your workbook: Launch WPS Spreadsheet and open the document containing your data.
2. Select the rows to group: Highlight the rows or columns you want to organize by clicking and dragging across the row numbers.
3. Apply grouping: Navigate to the 'Data' tab on the top ribbon and click the 'Group' button.
4. Use outline buttons easily: Use the highly visible plus (+) and minus (-) buttons generated in the margin to expand or collapse your selected data instantly.

100% compatible with Microsoft Excel (.xlsx and .xls) formatsClear, user-friendly interface that prevents outline buttons from vanishingLightweight and fast performance for large, complex datasetsFree to use with a familiar ribbon layout

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel group buttons disappear suddenly?

They often disappear if the rows containing the outline controls are manually hidden or if their height is reduced to zero. Using the keyboard shortcut 'Ctrl + 8' can also accidentally toggle the visibility of outline symbols off.

Can I expand or collapse groups without the plus and minus buttons?

Yes. If the buttons are missing, you can select the grouped data cells, navigate to the 'Data' tab, and use the 'Show Detail' and 'Hide Detail' buttons located in the Outline group to manage them.

Does clearing custom views always restore grouping buttons?

Not always, but it is a common fix. Custom views save specific display settings, including hidden rows and print layouts. If a custom view was saved while rows were hidden, applying that view will hide the outline buttons. Deleting the view removes this conflict.

How do I group columns instead of rows?

Select the entire columns you want to group by highlighting the column letters at the top of the worksheet. Then, go to the 'Data' tab and click 'Group'. The plus and minus buttons will appear in the top margin above the columns.

Office App Problems