Remove White Borders from Grouped Rows and Columns in Excel
Question details
Remove unexpected white borders or outline indicators created by grouped rows or columns in a worksheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to restore a normal worksheet view after rows or columns were grouped.
- Observed behavior
- White borders or outline symbols appear around grouped worksheet rows or columns instead of normal cell formatting.
Check whether outline level buttons or plus/minus expand and collapse controls appear beside the row numbers or above the column letters. These controls indicate that the worksheet contains grouped rows or columns.
Clear the row and column outline in Excel
Use this method when the white borders are associated with grouped rows or columns and outline controls are visible.
Clearing the outline removes all row and column groupings on the active worksheet. It does not remove normal cell borders, fills, or other formatting.
In the Excel ribbon, select the Data tab.
In the Outline group, select the arrow next to Ungroup.
Choose Clear Outline to remove all row and column grouping levels and the related outline borders or symbols.
Clear Grouped Rows and Columns in WPS Spreadsheet
WPS Spreadsheet lets you remove row and column outlines when grouping controls or outline-related borders affect the worksheet view. Open the Data tools, clear the outline, and continue editing in a familiar spreadsheet interface.
- 1. Open the worksheet in WPS Spreadsheet: Launch WPS Office, open the workbook, and select the worksheet that shows the grouping controls.
- 2. Select the Data tab: On the WPS Spreadsheet ribbon, click Data to access grouping and outline commands.
- 3. Find the outline controls: Locate the Group or Outline area on the Data tab and open the Ungroup options.
- 4. Clear the outline: Choose Clear Outline to remove grouped rows and columns from the current worksheet.
Frequently Asked Questions
Why do white borders appear around rows or columns in Excel?
They can be caused by worksheet outlining rather than cell border formatting. If you see level numbers or plus/minus controls beside headings, rows or columns are grouped.
Will Clear Outline delete my worksheet data?
No. On the Data tab, choose Ungroup > Clear Outline to remove grouping only; your cell values and standard formatting remain in place.
Can I remove grouping from only selected rows or columns?
Yes. Select the grouped rows or columns, then go to Data > Ungroup. Use Clear Outline only when you want to remove all grouping levels on the active sheet.
Why are the plus and minus symbols still visible after I change cell borders?
Those symbols are outline controls, not cell borders. Remove them through Data > Ungroup > Clear Outline rather than using the Home tab border tools.
