How To Print Active Multiple Worksheets in Microsoft Excel Tutorial

In this electrifying Microsoft Excel tutorial, we're unveiling a mind-blowing technique: Printing Multiple Active Worksheets at Warp Speed! When you're the Excel maestro in the room, printing multiple worksheets simultaneously is a breeze. Say goodbye to tedious, one-at-a-time printing!

Harness the Power of Active Worksheets:
Before we dive into this Excel extravaganza, let's grasp the concept of active worksheets. These are the worksheets you're actively working on, highlighted like stars on the worksheet tabs. Clicking on another sheet name makes it the active player.

Turbocharged Printing Options:
Excel's print dialog offers the usual suspects: "Print Active Sheets," "Print Entire Workbook," and "Print Selection." Yet, it lacks the finesse to select specific worksheets for printing. But we've got you covered!

The Magic of Selection:
Excel 2016 equips you with a superpower: the ability to select multiple worksheets at once. Click your first target, hold the Shift key, and click the last one. Boom! All the worksheets in between are now active and ready to roll.

Unleash Printing Efficiency:
With your chosen champions activated, head to the print dialog box. Here, choose the "Print Active Sheets" command. Excel swiftly recognizes your selection and prints only the chosen ones—no more tedious, manual clicking!

Tailored Print Settings:
For the ultimate personalization, tweak page numbers. Want specific pages from each worksheet? No problem! You can also set the number of copies for each selected worksheet. Excel bends to your will!

Unlock Time-Saving Secrets:
This isn't just printing; it's a time-saving revelation. When dealing with mammoth workbooks, this shortcut is your secret weapon, transforming your workflow into a warp-speed adventure.

Dive even deeper into Excel mastery on our cosmic website:

Stay connected across the digital galaxy:

Thank you for being a stellar part of our community. Like, comment, share, and subscribe to fuel our passion for creating engaging and informative tutorial content. Together, we'll conquer the Excel universe!

Unleash the Excel champion within you!

[abdullavazhayil]

This is to print adjacent sheet... But to print sheets not adjacent, select a sheet, press ctrl, then select another sheet, like that keep ctrl press and click sheets you want print...

[christieleturgez]

As a person who HATES using Excel, this was exceptionally helpful to me. You explained it well, and made it easy for me to follow and understand. Thank you so much! This was exactly what I was looking for.

[nazmirhassan]

Thanks a lot, this is exactly what i am searching helpful tutorial video.

[jaferhassan]

Thanks a lot. This is exactly what I have been looking for for a long time.

[jayantvedwan]

You explained it WELL.
No one else.
Keep it UP 👍

[rebeccaralte]

Thanks this is exactly what i am searching for....very helpful tutorial video

[akoblandinebesong]

Thanks alot. I did follow the procedure yet after selecting print page 1 to 1 of every active worksheet, only page one of the 1st worksheet was printed. I tried again and again, same results. Excel 2013

[sohamkhemka]

Hi, I am having an issue as for some reason, despite selecting all the worksheets to print, at the time of printing (or in my case saving as PDF) it shows a prompt to individually name and save each worksheet. Can you please help?

[igemolpindo]

Hello. How about printing with continuing page number in all worksheet?
For example,
Sheet 1 has 3 pages,
Sheet 2 has 2 pages,
If I wish to print Sheets 1 and 2 with page numbers, is it possible to have “page 4, and page5”? Or the page number for sheet 2 starts at “page 1” again? Thanks

[dhavalvithalani]

Thanks
I have one query
When i try to print multi sheet, its start printing on both the side of paper although i select print on single side


Kindly guide

[俺はユニコーンだ]

Why is the title in Japanese but the video is in English. I can speak both languages but still can the YouTube tutorials be in the same language the titles in. At least this time it's not in Hindi like a lot of the other tutorials.

[ttravis]

Thank you. This solved my problem in a short time .

[vortex]

You could’ve literally said use ctrl/shift depending on which sheet to use. Too much open bob.