Fix Excel for Mac Page Layout Settings on Grouped Sheets
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.
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.
Print Each Worksheet Separately and Combine the PDFs
Use this workaround when grouped sheets do not retain their individual print settings.
Right-click a selected worksheet tab and choose Ungroup Sheets. If that option is unavailable, click an unselected worksheet tab.
Select a worksheet tab, then use Page Layout and Page Setup to review its orientation, margins, scaling, and page numbering.
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.
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.
Update Printer Software and Check the Microsoft Community Discussion
Check for printer updates and follow the known issue if you want to troubleshoot grouped printing further.
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.

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.




