How to Remove Unexpected Outline Numbers 1 and 2 in Excel
Question details
The user needs to remove unexpected numbers 1 and 2 appearing outside the worksheet grid, which indicate that rows or columns have been grouped.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working on a spreadsheet and noticing unwanted outline level buttons located outside the standard cell boundaries.
- Observed behavior
- Numbers 1 and 2 appear outside the worksheet margins due to existing row or column outlines.
Before removing the outline grouping, review the collapsed sections of your spreadsheet to ensure you do not inadvertently expand sensitive or unnecessary hidden data.
Clear Outline Grouping from the Data Tab
The most effective way to remove the 1 and 2 outline numbers is by using the Clear Outline feature to remove all structural groupings from the worksheet.
These numbers appear because the data grouping feature was applied to your worksheet, creating an outline. Clearing the outline will remove the structural grouping buttons but will not delete your actual cell data.
Open your Excel spreadsheet and click on the 'Data' tab located in the top menu ribbon.
Look for the 'Outline' section, typically found on the far right side of the Data ribbon.
Click the drop-down arrow next to the 'Ungroup' button and select 'Clear Outline'. This action instantly removes the row or column grouping along with the outline level numbers 1 and 2.

Easily Manage Data Grouping and Outlines with WPS Office
WPS Office offers a powerful, user-friendly Spreadsheet application that makes organizing large datasets, including grouping rows and columns, incredibly straightforward.
- 1. Open Your Spreadsheet in WPS Office: Launch WPS Spreadsheet and open the .xlsx file containing the outline numbers.
- 2. Access the Data Tab: Navigate to the 'Data' tab on the top ribbon.
- 3. Clear the Outline: Click the 'Group' button drop-down menu and select 'Clear Outline' to quickly remove the grouping structure.

Frequently Asked Questions
What exactly do the numbers 1 and 2 mean on the side of my Excel sheet?
These numbers represent different outline levels. They appear when rows or columns are grouped, allowing you to quickly expand (level 2) or collapse (level 1) specific sections of your data for easier viewing.
Will clearing the outline delete the data inside the grouped rows or columns?
No, clearing the outline only removes the structural grouping mechanism (the collapsible buttons and numbers). Your actual cell data and formulas will remain completely intact.
How do I remove just one specific group instead of the entire outline?
To remove a single group, highlight the specific rows or columns that are grouped, go to the Data tab, and click 'Ungroup' instead of selecting 'Clear Outline'.
Why is the Ungroup or Clear Outline button greyed out?
The button may be disabled if your worksheet is protected or if you have multiple sheets selected simultaneously. Try unprotecting the sheet via the Review tab, or click on a single sheet tab at the bottom before attempting to clear the outline.




