How To Print Multiple Tabs In Excel

Are you tired of switching between multiple tabs in Excel to print the data you need? Wouldn’t it be nice to print multiple worksheets at once instead? (I’ll use tab and worksheet interchangeably in this post!)

Never fear, in this post I’ll explain how to print multiple worksheets quickly. We will also discuss some other print options that will come in handy.

Sounds good? Then let’s get going!

How To Print Multiple Sheets In Excel

To print multiple sheets in an Excel, follow these steps:

  1. Open the workbook that you want to print
  2. Hold the “Ctrl” key and click on the tabs that you want to print to select them
  3. Click “File” in the menu and then click “Print“. Alternatively, use the CTRL+P shortcut
  4. In the “Print” dialog box, select the printer that you want to use.
  5. Under “Settings” select the option to “Print Active Sheets“
  6. Click the “Print” button to start the printing process

That’s all there is to it!

You can also print all of the tabs in your workbook by selecting the option “Print Entire Workbook” under “Settings“. You don’t need to highlight all the tabs.

Pro tip – if you have selected multiple tabs, remember to ungroup them. Otherwise, you’ll be editing multiple tabs at once!

Select tabs and ungroup

Print Entire Workbook In Excel On Mac

It’s much easier to manipulate print page options on Excel Mac with the preview pane on the left.

Following a similar process to selecting all the tabs (press CMD to select tabs), press CMD+P to print up the print menu.

Excel Mac print options

Under the “Pages” title, you will find the various printing options like Entire Workbook or specific pages. The color option is right there as well!

Excel Print Setting Options

Here are how to change some of the common print settings in Excel.

Print Excel Tabs In Color

  1. In the Excel Print Menu, select Printer Properties under the Printer
  2. In the new dialog box, click “Paper/Quality“
  3. Under the Color title, select the Color option

Depending on your printer, there may be a “Color” tab. You can adjust the settings in there.

Print Entire Excel Workbook Double Sided

Unfortunately, this requires a bit of manual work (and is a bit of a pain). The issue is that Excel treats each worksheet as a new print job with its own print settings. Luckily you only need to do this once over the life of a workbook!

  • Select each tab individually
  • Open the Print menu (CTRL+P) and click Properties
  • Under the Layout tab, select the double-sided option and click OK
  • Click OK in the Print dialog box
  • Repeat these steps for every sheet in the workbook

Print Multiple Tabs In PDF

Depending on your team/boss, it’s easier to send a PDF of a workbook than to fire up Excel in front of them! Follow these steps to print to PDF in Excel.

  • Similar to above, select the various tabs you’d like to print
  • Open the Printer menu (CTRL or CMD + P)
  • Under the Printer Option, select the option “Microsoft Print to PDF”
  • Under Settings, select “Print Active Worksheets”
  • Press Print

Note – if you don’t have the “Microsft Print to PDF” option, I suggest saving the worksheet as a PDF type, but you’ll need to do this a tab at a time.

Thanks for reading and I hope you found this helpful!

Other Excel tutorials you may also like:

Leave a Comment