How to Fix Excel's Multiple Sections Insert Error
Question details
The user is unable to insert a new worksheet due to an error stating the action will not work across multiple sections.

- 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.
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.
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.
Look at the sheet tabs at the bottom of your Excel workbook. If several tabs have a white background, they are currently grouped.
Right-click any of the selected (highlighted) worksheet tabs and choose 'Ungroup Sheets' from the context menu.
Click a single worksheet tab to ensure that only one active sheet is selected.
Press the 'Esc' key on your keyboard or click any single empty cell in the grid to clear any noncontiguous multi-range selections.
Use the plus (+) button next to the sheet tabs or navigate to 'Home' > 'Insert' > 'Insert Sheet' to successfully add a new worksheet.

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. Download and Install: Get WPS Office for free from the official website and install it in seconds.
- 2. Open Your Workbooks: Open your existing Excel files directly in WPS Spreadsheet without any format conversion.
- 3. Manage Sheets Easily: Use the simplified bottom tab interface to group, ungroup, and insert new sheets without frustrating errors.

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.




