Fix Excel for Mac Printing the Entire Workbook by Default
Question details
The user wants Excel for Mac to print active sheets instead of the entire workbook by default.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Printing selected worksheets from an Excel workbook.
- Observed behavior
- The print dialog may default to Entire Workbook, causing Excel to print every worksheet.
Open the workbook and select the worksheet you want to print. Check which printer is selected in the print dialog, because presets may depend on the printer.
Select Active Sheets and check the print preset
Use this method to print only the selected worksheet and save the preferred settings when supported.
In Excel, select the worksheet you want, then choose File > Print. Click Show Details if the full print options are hidden.
Find the Excel print options, which may be under a menu in the expanded dialog, and select Active Sheets instead of Entire Workbook.
Open the Presets menu and choose a suitable saved preset, or select Save Current Settings as Preset if available. After choosing a preset, verify that Active Sheets is still selected.
Review the print preview and page count, then click Print if they match the selected sheets.

Update Excel and the printer software
Try this if the print selection keeps reverting or the preset does not behave as expected.
Print selected worksheets with WPS Office
WPS Office is a free, lightweight, easy-to-use alternative to Microsoft Office. Its familiar interface and Excel format compatibility make it easy to move your spreadsheets and print selected sheets, although it does not change Excel's print defaults.

Frequently Asked Questions
How do I print just one worksheet in Excel for Mac?
Select the worksheet tab, choose File > Print, and select Active Sheets in the expanded print options. Check the preview before clicking Print.
Why does Excel keep selecting Entire Workbook?
A retained print setting or preset may select Entire Workbook. Older Office builds or printer drivers can also contribute, so check the Presets menu and install available updates.
Can I save Active Sheets as my default print setting?
In File > Print, select Active Sheets and use Presets > Save Current Settings as Preset if available. Retention of Excel-specific settings can vary by version and printer driver, so verify the selection when you print.
Where can I update Excel for Mac?
In Excel, choose Help > Check for Updates to open Microsoft AutoUpdate and install available Office updates.




