HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Print Multiple Active Worksheets in Microsoft Excel 2016 Tutorial | The Teacher

105,512 views October 26, 2016 3:37

Watch on YouTube
ChannelThe Teacher

Description from the creator

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 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:
theteacherpoint.com/print-multiple-active-works…

Stay connected across the digital galaxy:
- Twitter: twitter.com/TheTeacherPoint
- Facebook: facebook.com/TheTeacherPoint
- Instagram: instagram.com/TheTeacherPoint
- Pinterest: in.pinterest.com/TheTeacherPoint

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!

About this tutorial

The Teacher published this 3:37 video tutorial on October 26, 2016. It has been watched 105,512 times on YouTube.

Category
Education
Duration
3:37
Published
October 26, 2016
Views
105,512
Likes
598

Tags

Share

Further reading

This tutorial in other languages