Excel prints the active sheet by default, but you can change which sheet prints when you open the Print dialog

When you press Ctrl+P (or Cmd+P on Mac) to print from Excel, the program automatically selects the sheet you are currently viewing. If you work with multi-sheet workbooks and find yourself printing the wrong sheet repeatedly, you can change this behavior so Excel defaults to a different sheet instead.

The catch: Excel does not have a global setting that changes the default for all future workbooks. Instead, you control what prints through the Print dialog itself, and you can save that choice within a specific workbook file. This means the solution depends on whether you want to change the default for one workbook or establish a habit for how you work across all workbooks.

Key Takeaways

  • Excel always defaults to printing whichever sheet is currently active when you open the Print dialog, and this cannot be changed globally.
  • You can select a different sheet to print before opening the Print dialog, which is the fastest way to print the sheet you actually want.
  • The Print dialog offers a "Selected sheet(s)" option that lets you choose multiple sheets at once if you need to print more than one.
  • If you save a workbook after selecting specific sheets to print, Excel remembers that choice the next time you open that file.
  • Creating a print area within a sheet lets you print only a portion of that sheet, which is different from selecting which sheet prints.

Switch to the sheet you want before printing

The simplest way to print a different sheet is to click on that sheet's tab at the bottom of the Excel window before you open the Print dialog. Once you click the tab, that sheet becomes the active sheet, and it will be the one selected by default when you press Ctrl+P.

This takes one extra click but solves the problem when ready. If you work with the same sheets in a regular order—for example, always printing a summary sheet after updating a data sheet—this becomes automatic after a few times.

Use the Print dialog to select multiple sheets at once

If you need to print more than one sheet in a single print job, the Print dialog gives you that option. Open the Print dialog (Ctrl+P), and look for the section labeled "Print" near the top. You will see radio buttons or checkboxes with options like "Active sheet(s)", "Entire workbook", or "Selection".

Click "Entire workbook" if you want to print every sheet in the file. Click "Active sheet(s)" to print only the sheet you are currently on. If you need specific sheets but not all of them, you must select those sheets before opening the Print dialog: hold Ctrl and click each sheet tab you want to include, then open Print and choose "Active sheet(s)". Excel will then print all the sheets you selected.

Save your sheet selection within a workbook

Excel remembers which sheets you selected for printing if you save the workbook after making that choice. This works because the print settings are stored inside the file itself, not in a global Excel setting.

To set this up: select the sheets you want to print (hold Ctrl and click each tab), then open the Print dialog and confirm your settings. Close the dialog without printing if you just want to test, or go ahead and print. Save the file. The next time you open that workbook and press Ctrl+P, those same sheets will still be selected.

This approach is useful if you have a workbook you print from regularly and always need the same sheets. It does not affect any other workbook, and it does not change Excel's behavior for new files you create.

Define a print area to print only part of a sheet

If you want to print only a portion of a single sheet—for example, a summary table at the top of a large data sheet—you can set a print area instead of switching sheets. Select the cells you want to print, then go to the Page Layout tab (or Sheet menu on Mac), find "Print Area", and click "Set Print Area".

Once you set a print area, Excel will print only those cells every time you print that sheet, even if you select the entire sheet. To remove the print area and go back to printing the whole sheet, go to Page Layout > Print Area > Clear Print Area.

Check your print preview before sending to the printer

The Print dialog in Excel shows a preview of what will print on the right side of the screen. Before you click the Print button, look at this preview to confirm you are printing the correct sheet. This catches mistakes before paper is wasted and takes only a few seconds.

If the preview shows the wrong sheet, close the dialog, click the correct sheet tab, and open Print again. The preview will update to show the new sheet.

Frequently Asked Questions

Can I make Excel always print a specific sheet by default across all my workbooks?

No. Excel does not have a global default for which sheet prints. The active sheet (the one you are viewing) always becomes the default selection in the Print dialog. You can only save a print sheet selection within individual workbook files, not across all files.

What is the difference between printing multiple sheets and printing the entire workbook?

When you print multiple sheets, you select exactly which sheets you want. When you print the entire workbook, Excel prints every sheet in the file, including any you may not want. Use "Entire workbook" only if you need all sheets; otherwise, select the specific sheets you need.

If I set a print area, will it print that area from every sheet in the workbook?

No. A print area applies only to the sheet you set it on. If you set a print area on Sheet1 and then switch to Sheet2 and print, Sheet2 will print in full (unless you also set a print area on Sheet2). Each sheet's print area is independent.

Does Excel remember my print settings if I close and reopen the file?

Yes, but only if you save the file after selecting your sheets. The print sheet selection is stored in the workbook file itself. If you select sheets, print, and then close without saving, the selection is lost. Save the file to make the choice permanent.

Why does the Print dialog show "Active sheet(s)" even though I selected multiple sheets?

The label "Active sheet(s)" is Excel's way of saying "the sheets you have selected right now." It does not mean only one sheet will print. If you selected three sheets before opening Print, all three will print even though the button says "Active sheet(s)".