Printing Problems

Set Active Sheets as Default Print Option in Excel for Mac

Partner Editor Sep 28, 2026 868 views

Question details

The user wants to prevent Excel for Mac from switching between printing active worksheets and the entire workbook, specifically aiming to lock in Active Sheets as the persistent default when printing or creating PDFs.

How to Set Active Sheets as the Default Print Option in Excel for Mac

Product: Microsoft Excel for Mac
Device & OS: macOS Sonoma
Scenario: Printing worksheets or exporting them to PDF via the print dialog.
Observed behavior: Excel fails to remember the active sheet print setting, frequently reverting to printing the Entire Workbook instead of just the Active Sheets.

Before you start

Ensure your macOS is updated to the latest version of Sonoma and that your printer drivers are correctly installed, as Excel for Mac relies heavily on the macOS print subsystem for these settings.

Solution 1Recommended

Create and Save a macOS Print Preset for Active Sheets

Since Excel for Mac uses the native macOS print dialog, saving a custom preset at the system level is the most effective way to lock in Active Sheets as your default print and PDF option.

On macOS, Excel delegates most of its print behavior to the operating system's print subsystem. Creating a dedicated print preset ensures that your preferences are remembered every time you print or save a PDF.

Open the Print Dialog

Open your workbook in Excel for Mac and press 'Cmd + P' on your keyboard, or go to 'File' > 'Print' in the top menu.

Select Active Sheets

In the Print dialog box, locate the print options section and ensure that 'Active Sheets' is selected instead of 'Entire Workbook'.

Access Presets

Click on the 'Presets' dropdown menu located near the top of the print dialog window.

Save as New Preset

Select 'Save Current Settings as Preset...' from the dropdown list.

Name and Apply Preset

Name the preset something recognizable like 'Active Sheets Only', choose whether to make it available for all printers or just the current one, and click 'OK'. Use this preset for all future print jobs and PDF exports.

Create and Save a macOS Print Preset for Active Sheets

Preset Configuration: Once saved, macOS will typically remember the last used preset. Ensure 'Active Sheets Only' remains selected the next time you open the print dialog.

Free Microsoft Office alternative

Try WPS Office for a Hassle-Free Printing Experience on Mac

If you are tired of battling Excel's system print settings on macOS, switch to WPS Office. It offers a straightforward, built-in PDF converter and print dialog that easily retains your page range preferences without requiring complex system presets.

1. Download and Install: Download WPS Office for Mac from the official website and complete the installation.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file without worrying about format issues.
3. Print or Export: Press Cmd + P to open the built-in print dialog, select your active sheet settings, and easily print or export to PDF.

Free, lightweight, and fast Office suite optimized for MacFully compatible with Microsoft Excel (.xlsx) formatsBuilt-in Print and Export to PDF tools that intuitively remember your settingsClean, familiar tabbed interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for Mac keep defaulting to the entire workbook?

On macOS, Excel delegates print behavior to the operating system's print subsystem. If a specific preset isn't saved and actively selected, the system may revert to its default behavior or the last unrecorded state, causing the entire workbook to print.

Will this preset work for saving Excel files as PDFs?

Yes, if you use the 'Save as PDF' option located at the bottom of the native macOS print dialog, it will respect the active sheets preset you have selected.

Can I change this default setting directly inside Excel's preferences?

No, Excel for Mac does not have a built-in preference toggle to permanently set the print range default. It must be managed externally through the macOS Print dialog presets.

Document & File Issues