How to Prevent Page Layout Changes from Affecting Grouped Excel Worksheets in WPS Office
Question details
The user wants to update page layout settings such as headers, footers, page numbers, orientation, or paper size for only one worksheet, instead of all grouped worksheets.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A workbook contains grouped worksheets, and the user needs to apply page layout changes to a single sheet without changing the other sheets in the group.
- Observed behavior
- While worksheets are grouped, page layout changes are applied to every selected worksheet, which is the standard grouped-sheet behavior.
Before changing page layout settings, check the worksheet tabs at the bottom of the workbook. If multiple tabs are highlighted or the title bar shows [Group], the sheets are currently grouped and will receive the same page layout changes.
Ungroup Worksheets Before Changing Page Layout Settings
Use this method when you need to change headers, footers, page numbers, orientation, or paper size on one worksheet without applying the changes to other grouped worksheets.
When worksheets are grouped, page layout settings are shared across all selected sheets. Ungrouping the sheets is the only reliable way to limit a layout change to one worksheet while keeping the rest of the workbook unchanged.
In WPS Spreadsheets or Excel, open the workbook and look at the worksheet tabs at the bottom. If multiple tabs are highlighted or the title bar shows [Group], the worksheets are grouped.
Right-click any selected sheet tab in the group to open the worksheet tab context menu.
Click Ungroup Sheets. The tabs return to separate selections and the group indicator disappears.
Click the tab of the single worksheet you need to change, then open Page Layout or Page Setup and adjust headers, footers, page numbers, orientation, or paper size.

Ungroup Worksheets in WPS Spreadsheets to Control Page Layout Changes
WPS Spreadsheets gives you the same grouped-sheet page layout controls as Excel. Ungroup sheets before applying page layout settings so only the selected worksheet is updated, keeping your other sheets intact.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the workbook, and inspect the worksheet tabs at the bottom to identify the grouped sheets.
- 2. Right-click a grouped sheet tab: Right-click one of the selected worksheet tabs in the group to open the context menu.
- 3. Choose Ungroup Sheets: Click Ungroup Sheets to separate the worksheets. Their data, formulas, and existing formatting are preserved.
- 4. Apply page layout changes to one sheet: Select only the worksheet you need to update, then change headers, footers, page numbers, page orientation, or paper size in Page Layout or Page Setup.
- 5. Verify the other sheets remain unchanged: Click through the other worksheet tabs and open Page Setup to confirm their page layout settings were not affected.

Frequently Asked Questions
How do I know if my worksheets are grouped?
Look at the sheet tabs at the bottom of the workbook. If multiple tabs appear selected or the Excel/WPS title bar shows [Group], the worksheets are grouped. Right-clicking a selected tab also shows the Ungroup Sheets option.
Can I change headers and footers for only one sheet while keeping other sheets grouped?
No. While sheets are grouped, page layout settings such as headers and footers apply to all selected sheets. Ungroup the sheets first, select the target worksheet, and then make the change.
Does ungrouping worksheets delete any data or formatting?
No. Ungroup Sheets only removes the temporary group selection. It does not delete data, formulas, formatting, or page layout settings already applied.
What page layout settings are affected when worksheets are grouped?
Grouped-sheet page layout changes typically include headers, footers, page numbers, page orientation, paper size, margins, and print settings that can be applied to multiple sheets at once.




