Printing Problems

Fix Excel for Mac Printing the Entire Workbook by Default

Maira MehtabMaira Mehtab Nov 18, 2026 868 views

Question details

The user wants Excel for Mac to print active sheets instead of the entire workbook by default.

Fix Excel for Mac Printing 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.
Before you start

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.

Solution 1Recommended

Select Active Sheets and check the print preset

Use this method to print only the selected worksheet and save the preferred settings when supported.

1
Open the print dialog

In Excel, select the worksheet you want, then choose File > Print. Click Show Details if the full print options are hidden.

2
Choose Active Sheets

Find the Excel print options, which may be under a menu in the expanded dialog, and select Active Sheets instead of Entire Workbook.

3
Save or choose a preset

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.

4
Check the preview

Review the print preview and page count, then click Print if they match the selected sheets.

Select Active Sheets and check the print preset
Preset behavior can vary: Depending on the Excel version and printer driver, a preset may not retain every Excel-specific option. Check Active Sheets before printing if the setting returns to Entire Workbook.
Free Microsoft Office alternative

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.

Print selected worksheets from WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.