Office Settings & Configuration

How to Remove Unexpected Outline Numbers 1 and 2 in Excel

Natalie TaylorNatalie Taylor Nov 10, 2026 870 views

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.

How to Remove Unexpected Outline Numbers 1 and 2 in Excel
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 you start

Before removing the outline grouping, review the collapsed sections of your spreadsheet to ensure you do not inadvertently expand sensitive or unnecessary hidden data.

Solution 1Recommended

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.

1
Navigate to the Data Tab

Open your Excel spreadsheet and click on the 'Data' tab located in the top menu ribbon.

2
Locate the Outline Group

Look for the 'Outline' section, typically found on the far right side of the Data ribbon.

3
Select Clear Outline

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.

Clear Outline Grouping from the Data Tab
Data Preserved: Clearing the outline successfully removes the marginal numbers without deleting any underlying data or formatting.
Manage Spreadsheets Efficiently

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. 1. Open Your Spreadsheet in WPS Office: Launch WPS Spreadsheet and open the .xlsx file containing the outline numbers.
  2. 2. Access the Data Tab: Navigate to the 'Data' tab on the top ribbon.
  3. 3. Clear the Outline: Click the 'Group' button drop-down menu and select 'Clear Outline' to quickly remove the grouping structure.
Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your existing data groups load perfectly.Easily add, manage, or clear outlines with an intuitive interface.Lightweight, fast, and completely free to download and use for your daily office tasks.
microsoft office alternative - wps office

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.