Office Settings & Configuration

How to Fix Excel Outline Symbols Missing from Grouped Rows or Columns

Adam Davis Oct 12, 2026 870 views

Question details

The user needs to restore the plus and minus outline symbols for grouped rows or columns that have disappeared from the worksheet.

How to Fix Excel Outline Symbols Missing from Grouped Rows or Columns

Product: Microsoft Excel
Device & OS: not provided
Scenario: Working with grouped rows or columns in a spreadsheet where the data is still grouped, but the visual expand/collapse controls are missing.
Observed behavior: The plus (+) and minus (-) outline buttons disappear from the worksheet margins, frequently caused by hidden rows or inconsistent row heights.

Before you start

Before troubleshooting, ensure that your worksheet actually contains grouped data by checking if the 'Ungroup' option in the Data tab is active. It is also recommended to save a quick backup of your spreadsheet before adjusting row heights globally.

Solution 1Recommended

Unhide Rows and Standardize Row Heights

This is the most effective fix for missing outline symbols, as hidden or zero-height rows can cause the outline margin to glitch and disappear.

In many cases, row heights that are inconsistent or rows that are hidden past a certain point in the worksheet will cause Excel to hide the outline margin entirely. Resetting the row heights temporarily restores the symbols.

Select the entire worksheet

Click the small triangle in the top-left corner of the spreadsheet, right between column header A and row header 1, to select all cells.

Unhide all rows

Right-click any row number on the left side of the screen and select 'Unhide' to reveal any hidden rows in the worksheet.

Standardize row heights

With the entire sheet still selected, right-click a row number again, select 'Row Height', enter a standard value like 15, and click 'OK'.

Re-hide necessary rows

Check the left margin to confirm the outline symbols have returned. You can now select the specific rows you want hidden, right-click, and select 'Hide'—the symbols will remain visible.

Symbols Restored Permanently: Once the row heights are made consistent across the worksheet, the plus and minus grouping buttons will stay visible even after you hide rows again.

Solution 2

Enable Outline Symbols in Advanced Options

Use this method if your row heights are normal but the symbols are still missing, as the display setting might be turned off.

Try WPS Spreadsheet

Group and Outline Data Easily with WPS Office

WPS Office Spreadsheet provides a seamless, glitch-free experience for grouping rows and columns. If you regularly experience interface glitches or missing buttons in your spreadsheets, WPS is a reliable and lightweight alternative.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
2. Select your data range: Highlight the specific rows or columns that you want to group together.
3. Group the data: Navigate to the 'Data' tab on the top ribbon and click the 'Group' button to instantly create an outline with clearly visible plus and minus symbols.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats, meaning your existing groups and outlines will load perfectly.Stable display engine that reliably shows outline symbols, grouping, and subtotal features without disappearing.Lightweight software that runs smoothly on older devices, preventing common interface lag and glitches.Free to download and use, featuring a highly familiar interface so you can start working immediately.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel grouping buttons disappear only when I hide specific rows?

If hidden rows intersect with or heavily modify the grouped range, Excel's display renderer can sometimes glitch, hiding the outline margin. Standardizing the row heights before re-hiding them resets the display parameters and usually resolves the bug.

Can I expand or collapse grouped rows using a keyboard shortcut if the symbols are missing?

Yes. Even if the symbols are invisible, you can expand grouped data by selecting the area and pressing 'Alt' + 'Shift' + '+' (plus sign). To collapse the data, press 'Alt' + 'Shift' + '-' (minus sign).

Does protecting the worksheet cause outline symbols to vanish?

Protecting a worksheet doesn't typically hide the symbols, but it can prevent you from clicking them to expand or collapse data. If your sheet is protected, you must enable outlining permissions (often via VBA or specific protection settings) to keep the buttons functional.

Will copying the data to a new worksheet bring back the outline symbols?

Sometimes. Copying the data and pasting it into a fresh worksheet strips away any corrupted display settings or irregular row heights, which can restore the grouping symbols when you re-apply the outline.

Office App Problems