Office Settings & Configuration

How to Fix Excel's Multiple Sections Insert Error

Emma BrownEmma Brown Nov 10, 2026 868 views

Question details

The user is unable to insert a new worksheet due to an error stating the action will not work across multiple sections.

How to Fix Excel's Multiple Sections Insert Error
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is trying to insert a new worksheet while the workbook is in a grouped tab state or has multiple noncontiguous ranges selected.
Observed behavior
Excel displays the error message 'This action won't work across multiple sections' and prevents the user from inserting the new sheet.
Before you start

Review your active workbook tabs at the bottom of the screen to see if multiple sheets are highlighted in white, which indicates they are currently grouped together.

Solution 1Recommended

Ungroup Sheets and Clear Active Selections

Ungrouping the selected worksheets and removing multi-range cell selections will clear the block and allow you to insert new sheets normally.

Excel restricts certain structural modifications, such as inserting new worksheets or creating tables, when multiple sheets are grouped or noncontiguous cell ranges are selected. This is designed to prevent accidental bulk changes across your workbook.

1
Check for grouped sheets

Look at the sheet tabs at the bottom of your Excel workbook. If several tabs have a white background, they are currently grouped.

2
Ungroup the sheets

Right-click any of the selected (highlighted) worksheet tabs and choose 'Ungroup Sheets' from the context menu.

3
Select a single sheet

Click a single worksheet tab to ensure that only one active sheet is selected.

4
Clear multi-range selections

Press the 'Esc' key on your keyboard or click any single empty cell in the grid to clear any noncontiguous multi-range selections.

5
Insert the new sheet

Use the plus (+) button next to the sheet tabs or navigate to 'Home' > 'Insert' > 'Insert Sheet' to successfully add a new worksheet.

Ungroup Sheets and Clear Active Selections
Error Resolved: You can now insert new sheets and perform other structural actions without triggering the multiple sections error.
Free Microsoft Office alternative

Manage Spreadsheets Seamlessly with WPS Office

If Excel's selection and grouping errors are disrupting your workflow, try WPS Office. It provides a highly compatible, lightweight, and user-friendly spreadsheet application designed to streamline data management without the hassle.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it in seconds.
  2. 2. Open Your Workbooks: Open your existing Excel files directly in WPS Spreadsheet without any format conversion.
  3. 3. Manage Sheets Easily: Use the simplified bottom tab interface to group, ungroup, and insert new sheets without frustrating errors.
Fully compatible with Microsoft Excel formats, ensuring your .xlsx files open flawlessly.Intuitive tabbed interface makes managing and modifying multiple worksheets effortless.Free and lightweight, offering a fast installation without draining system resources.Familiar user interface guarantees a zero learning curve for experienced Excel users.
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel sheets get grouped in the first place?

Sheets are usually grouped when you hold down the 'Ctrl' or 'Shift' key while clicking on different sheet tabs. This feature is intended for applying formatting or data entry across multiple sheets simultaneously.

Can I copy data across grouped sheets without getting an error?

Yes, you can enter data or apply formatting across grouped sheets. However, actions that change the structure of the workbook, like inserting new sheets or creating Excel Tables, will trigger the multiple sections error.

What does 'multiple selections' mean in this Excel error?

Multiple selections refer to noncontiguous ranges, which happen when you hold the 'Ctrl' key and select separate, unconnected cells or ranges. Clearing this selection by clicking a single cell resolves the issue.