Office for Mac Issues

Fix Excel for Mac Page Layout Settings on Grouped Sheets

Tauseeq MagsiTauseeq Magsi Nov 18, 2026 869 views

Question details

The user needs to preserve individual page layout and print settings when printing multiple worksheets in Excel for Mac.

Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Printing grouped worksheets that have different orientations, scaling, margins, page numbering, or other print settings.
Observed behavior
Excel applies the first worksheet's page layout and print settings to the other grouped worksheets.
Before you start

Check which worksheets need different page settings and confirm their intended print order. Open each sheet's Page Layout settings to review its orientation, margins, scaling, and page numbering.

Solution 1Recommended

Print Each Worksheet Separately and Combine the PDFs

Use this workaround when grouped sheets do not retain their individual print settings.

1
Ungroup the sheets

Right-click a selected worksheet tab and choose Ungroup Sheets. If that option is unavailable, click an unselected worksheet tab.

2
Check each sheet's layout

Select a worksheet tab, then use Page Layout and Page Setup to review its orientation, margins, scaling, and page numbering.

3
Save each sheet as a PDF

With one worksheet selected, choose File > Print. Check the print preview, then use the PDF menu in the macOS print dialog to save it as a PDF. Repeat for each worksheet.

4
Combine the PDFs

Open the first PDF in Preview and choose View > Thumbnails. Drag the other PDF files into the thumbnail sidebar in the desired order, then choose File > Export as PDF.

Check page numbering: Separately printed worksheets may not number pages consecutively. Review the combined PDF and adjust each worksheet's starting page number in Page Setup if needed.
Free Microsoft Office alternative

Manage Worksheet Print Layouts with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel workbooks. Its Excel format compatibility makes it easy to move existing files into WPS Spreadsheet and review worksheet print layouts.

Review worksheet orientation, margins, and print layouts in WPS SpreadsheetOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface that makes switching from Office easierWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why do grouped sheets use the same orientation in Excel for Mac?

Excel for Mac can apply the first grouped worksheet's print settings to the other sheets. If your sheets need different orientations, ungroup them and print each one separately.

How do I print a single worksheet to PDF on a Mac?

Select the worksheet tab in Excel, choose File > Print, and check the preview. Use the PDF menu in the macOS print dialog to save the sheet as a PDF.

Can I combine portrait and landscape worksheet PDFs?

Yes. Open the first PDF in Preview, choose View > Thumbnails, and drag the other PDFs into the thumbnail sidebar in the desired order. Then choose File > Export as PDF.

Will updating my printer driver fix grouped sheet settings?

A current driver or firmware is worth checking, but it may not fix this known Excel for Mac issue. After updating, use File > Print to inspect the grouped sheets' preview.