Remove Plus and Minus Outline Symbols from Grouped Rows or Columns in Excel
Question details
Remove the plus and minus buttons displayed beside grouped rows or above grouped columns in an Excel worksheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The worksheet contains grouped rows or columns, and the user wants to remove the outline controls or all grouping levels.
- Observed behavior
- Plus and minus outline symbols appear next to row numbers or above column letters. They expand and collapse grouped data, which may make rows or columns appear hidden.
Check whether the outline applies to rows, columns, or both. If the grouping may be needed later, save a separate copy of the workbook before clearing all outline levels.
Ungroup the selected rows or columns in Excel
Use this option when you want to remove outline symbols from only a selected group while keeping other worksheet groups intact.
Excel displays plus and minus symbols when rows or columns have been grouped with the Outline feature. Ungrouping removes the selected grouping and its related expand/collapse control.
Click and drag across the grouped row headers or column headers that you want to remove from the outline.
On the Excel ribbon, select the Data tab and locate the Outline section.
Select Ungroup, then choose Rows or Columns, depending on the type of grouping you selected.
Clear all outline levels from the Excel worksheet
Use this option when you no longer need any grouped rows or columns in the current worksheet.
Remove Grouping Symbols Easily in WPS Spreadsheets
WPS Spreadsheets lets you manage worksheet outlines with familiar grouping commands. Select grouped rows or columns to ungroup them, or clear the worksheet outline when you want to remove every expand and collapse symbol.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, open the workbook, and select the worksheet containing the grouped rows or columns.
- 2. Select the grouped rows or columns: Click the relevant row numbers or column letters to select the group whose outline symbols you want to remove.
- 3. Ungroup the selection: Go to the Data tab and select Ungroup, then choose the applicable rows or columns option.
- 4. Clear all groups if needed: To remove every outline level on the sheet, use the Data tab's outline or ungroup options and select Clear Outline.
Frequently Asked Questions
Why do plus and minus buttons appear in my Excel worksheet?
They appear when rows or columns are grouped with Excel's Outline feature. The buttons let you collapse or expand the grouped data.
Will Ungroup delete the rows or columns in Excel?
No. Data > Ungroup only removes the grouping structure and outline symbols. The rows and columns remain in the worksheet.
How do I remove all row and column groups at once in Excel?
Open the affected worksheet, go to Data > Outline, open the Ungroup drop-down menu, and select Clear Outline to remove all outline levels.
Why are my Excel columns hidden when I click the minus symbol?
Clicking the minus symbol collapses the grouped columns or rows, so they are temporarily hidden. Click the plus symbol to expand them again.
