Restore Missing Excel Grouping and Outline Icons
Question details
The user needs to restore the outline level buttons and plus or minus icons for grouped Excel rows.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet has working row grouping, but its outline controls are no longer visible.
- Observed behavior
- Grouped rows remain functional, while the outline level buttons and plus or minus symbols are hidden.
Open the affected worksheet and confirm that rows are already grouped. Check the current zoom percentage and whether the sheet is protected before changing Excel options.
Enable Excel outline symbols in Advanced options
Use this solution when grouping works but the outline controls are hidden across the worksheet.
Excel can keep an outline active while hiding its symbols through an Advanced display setting. Enabling this option restores the level buttons and the plus or minus controls when an outline is applied.
Select File in Excel, choose Options, and open the Advanced category.
Scroll to the Display options for this worksheet section and select Show outline symbols if an outline is applied.
If the setting includes a worksheet selector, choose the worksheet containing the grouped rows, then click OK.
Return to the worksheet and check the left margin for the outline level buttons and plus or minus grouping icons.
Correct the zoom level and worksheet protection settings
Use these checks when the outline option is enabled but the grouping controls still do not appear.
Manage grouped spreadsheet data with WPS Office
WPS Office provides a free, lightweight spreadsheet experience with a familiar interface and strong Microsoft Excel format compatibility. Open or migrate your workbook in WPS Spreadsheets when you need an easy alternative for organizing grouped rows and working with .xlsx files.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open from the home screen and choose the Microsoft Excel .xlsx file you want to work with.
- 3. Review grouped rows: Use the spreadsheet ribbon and worksheet view to inspect the grouped rows, then save the edited workbook in Excel format when needed.
Frequently Asked Questions
Why are Excel grouping icons missing even though the rows are still grouped?
Excel can hide outline symbols independently of the grouping state. Go to File > Options > Advanced and enable Show outline symbols if an outline is applied for the affected worksheet.
Where can I turn on the plus and minus symbols in Excel?
Select File > Options > Advanced, locate Display options for this worksheet, and select Show outline symbols if an outline is applied. Click OK to apply the setting.
Can a low zoom level hide Excel outline controls?
Yes. Open View > Zoom and set the worksheet to 100%. Then check the left edge of the grouped rows for the outline buttons and symbols.
Does worksheet protection prevent Excel outline icons from appearing?
Protection can restrict outline-related changes or affect how the controls are displayed. On the Review tab, select Unprotect Sheet if you have the required password, then recheck the outline settings.
