Office Settings & Configuration

How to Prevent Page Layout Changes from Affecting Grouped Excel Worksheets in WPS Office

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

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.

How to Prevent Page Layout Changes from Affecting Grouped Excel Worksheets in WPS Office
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 you start

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.

Solution 1Recommended

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.

1
Open the workbook and check for grouped tabs

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.

2
Right-click a selected worksheet tab

Right-click any selected sheet tab in the group to open the worksheet tab context menu.

3
Choose Ungroup Sheets

Click Ungroup Sheets. The tabs return to separate selections and the group indicator disappears.

4
Select the worksheet you want to update

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 Before Changing Page Layout Settings
Layout changes are now limited to one sheet: After ungrouping, page layout settings apply only to the active worksheet. Other worksheets remain unchanged.
WPS Spreadsheets

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. 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. 2. Right-click a grouped sheet tab: Right-click one of the selected worksheet tabs in the group to open the context menu.
  3. 3. Choose Ungroup Sheets: Click Ungroup Sheets to separate the worksheets. Their data, formulas, and existing formatting are preserved.
  4. 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. 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.
Free, lightweight spreadsheet app with familiar worksheet grouping and page layout controlsFull compatibility with Microsoft Excel .xlsx, .xls, and other Office document formatsClear worksheet tab and Ungroup Sheets options for precise page layout editsEasy migration from Excel with a familiar tabbed workbook interface
microsoft office alternative - wps office

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.