Print Some or Print All
Today’s tip comes from a reader who wanted to know how to print an entire MS Excel workbook all at once.
That’s a good question. After all, it’s a royal pain to print each worksheet individually.
So, how exactly can you print an entire workbook at one time?
The answer takes you back to the Print dialogue window (Ctrl + P).
Once again, you’re looking for the “Print what” section.
This time, you’ll want to select the “Entire workbook” choice and then proceed with the printing.
Now, let’s take this one step further.
What if you want to print multiple worksheets, but not all of them?
Before you start the printing process, hold down the Ctrl key and select the tabs of the worksheets to be printed.
At this point, you’re ready to move on to the Print dialogue window (Ctrl + P).
In the “Print what” section, make sure the “Active sheet(s)” option is selected and then proceed as usual.
Print one, print some or print it all. It’s all up to you!