PlayInfoBox

Home /Utilities /How to Print Multiple Sheets at Once in Excel

How to Print Multiple Sheets at Once in Excel

Tap a step to see how to print several sheets in one go.

  1. Click the first sheet tab

    Click the first of the sheet tabs you want to print.

  2. Ctrl+click the other sheet tabs

    Hold Ctrl and click each additional sheet tab you also want to print.

  3. Open "File > Print"

    Click "Print" from the "File" tab.

  4. Confirm "Print Active Sheets," then print

    Make sure the print settings show "Print Active Sheets," then run the print job.

  5. Why is this useful?

    Instead of opening and printing each sheet in a file separately, you can select exactly the ones you need and print them all in a single job.

Skip Printing Sheet by Sheet

When a workbook is split across several sheets β€” a summary, a detail view, supporting data β€” printing each one separately wastes time you do not need to spend. Selecting several sheet tabs at once and printing them together saves several trips to the print dialog.

Also Worth Setting: Print Area

If you also want to control exactly which cells get printed on each sheet rather than the whole page, it is worth learning how to set a print area β€” combined with selecting multiple sheets, you get precise control over exactly what comes out of the printer.

Frequently Asked Questions

What happens if the selected sheets have different print settings?

Each sheet's own predefined print area and scaling settings apply as-is when printed, so it is a good idea to double-check each sheet's settings beforehand.

How do I print every sheet in the file at once?

Right-click any sheet tab, choose "Select All Sheets," then follow the same printing steps to print every sheet in the file in one job.