Excel prints only the sheet tab you have open unless you tell it otherwise

When you open an Excel workbook with multiple sheets and hit print, Excel sends only the active sheet—the one whose tab is highlighted at the bottom—to the printer. If you want a different sheet to print by default, you need to make that sheet active before you save the file. The next time someone opens that workbook and prints, that sheet will be the one that goes to the printer.

This is not a setting you change in the Print dialog. It is a property of the file itself: whichever sheet tab is selected when you save the workbook becomes the default sheet that prints. If you want to change it, you select a different sheet, then save.

Key Takeaways

  • Excel prints whichever sheet tab is currently active (highlighted) when you press print, so changing the default sheet means making a different sheet active before saving.
  • Click the sheet tab at the bottom of the screen to switch to the sheet you want to print by default.
  • Save the file after selecting the new sheet, and that sheet will remain the default the next time the file opens.
  • This change affects only the print behavior for that specific workbook file, not your Excel settings overall.

How to select a different sheet as the default

At the bottom of the Excel window, you will see a row of sheet tabs. Each tab is labeled with the sheet name—usually "Sheet1", "Sheet2", and so on, though they may have custom names like "Sales" or "Budget". Click the tab for the sheet you want to print by default.

That sheet is now active. You will see its data fill the main window, and the tab itself will appear highlighted or in a lighter color than the other tabs. This is the sheet that will print if someone opens this file and presses Ctrl+P or uses File > Print without making any other changes.

Now save the file. Use Ctrl+S or go to File > Save. The workbook closes and reopens with that sheet still active, and Excel remembers it as the default sheet for printing.

Why Excel works this way

Excel treats the active sheet as the one the user was last working on, so it assumes that is the sheet they want to print. This design prevents accidental printing of the wrong sheet—if you were editing the "Budget" sheet, Excel prints the "Budget" sheet, not "Sheet1" from three months ago.

The downside is that there is no separate "default print sheet" setting. You cannot tell Excel "always print Sheet2" independent of which sheet you are viewing. The active sheet and the default print sheet are the same thing.

What happens if you want to print multiple sheets at once

If you need to print more than one sheet in a single print job, you select all the sheets you want before opening the Print dialog. Right-click any sheet tab and choose "Select All Sheets", or hold Ctrl and click individual tabs to select only the ones you need. The tabs will appear highlighted.

When you print with multiple sheets selected, Excel prints all of them in the order they appear in the workbook. However, this selection does not persist after you close the file—the next time you open it, only one sheet will be active again.

Preventing accidental printing of hidden sheets

If your workbook has hidden sheets—sheets that do not appear as tabs at the bottom—they will not print even if they are selected. Hidden sheets are useful for storing data or calculations you do not want users to see or print by accident.

To hide a sheet, right-click its tab and choose "Hide". To unhide it later, right-click any visible sheet tab, choose "Unhide", and select the sheet you want to show again. Hidden sheets do not affect which sheet prints by default; only visible, selected sheets print.

Checking your print preview before sending to the printer

Before you print, open the Print preview to confirm you are about to print the correct sheet. In Excel, go to File > Print, and the preview pane on the right shows you exactly what will print. If the wrong sheet appears in the preview, close the Print dialog, click the correct sheet tab, and try again.

Print preview is especially useful in workbooks with many sheets, because it takes only a few seconds to verify you have the right one selected. This step prevents wasted paper and ink.

Frequently Asked Questions

Does changing the default print sheet affect other people's copies of the file?

Yes. When you save the file with a different sheet active, that change is saved into the file itself. Anyone who opens that file will see the same sheet active by default. If you share the file with others, they will print that sheet unless they manually select a different one first.

Can I set a print area instead of changing which sheet prints?

Yes. A print area is a range of cells within a single sheet that prints instead of the whole sheet. Go to the sheet you want, select the cells you need, then use Page Layout > Print Area > Set Print Area. This is useful if you want to print only part of a large sheet, but it does not change which sheet is the default.

What if I want different sheets to print by default for different people?

You cannot do this within a single file. Each workbook has one active sheet, and that is the default for everyone who opens it. If different users need different sheets to print, you would need separate workbook files or a macro that changes the active sheet based on who opens the file.

Does the default sheet change if I just view a different sheet without saving?

No. If you click a different sheet tab but do not save the file, the original sheet remains the default. The change takes effect only when you save. If you close the file without saving, Excel forgets that you switched sheets and reopens with the original sheet active.