Until now we took a look at printing one sheet at a time.
But what if you wanted to print many sheets in one go? Or your entire workbook?
Also how can you save these sheets as a PDF document?
Let's take a look at printing more than one sheet.
First, all you need to do is hold down the control key and select the other tab that you want.
Just remember before you need to do the work to make sure that each tab looks good when it's being printed.
Once that work is done, you just need to select them and go to print preview.
That's the first tab and this is the second tab.
If you have the page numbers activated for each of the tabs in the footer then you get the correct total
number of page numbers
when you want to print this. So it doesn't do one of one and then one of two and two of two. It updates
the page numbers to reflect your entire printout.
If you wanted to print the entire workbook in one go, you can
select that from here. What if you wanted to print most of the sheets but exclude one or two?
Let's say you have a large workbook with many sheets.
It's gonna be a pain if you need to go hold down control and select each of these sheets.
To do that you just right mouse click on any of these tabs, select all sheets. And then hold down the
control key and select the ones you don't want. And then go to print preview or print directly.
Now let's take a look at how we can save different tabs as a PDF document.
Let's start with this one.
Let's just say we want to only save this tab as a PDF.
Once I make sure everything is adjusted for printing I can go to File > Export.
Click on create PDF, select where you want to save it and give it a name.
By default it's taking the name of my workbook.
I'm just going to put Tab 2 and click on publish.
Now you can set additional options here.
If you just had selected part of the sheet, you can click on selection.
If you want the entire workbook to be saved as PDF, you can make this selection. And then click on OK
and publish.
Now let's go and take a look.
That's what I saved.
Double click. That's page one,
and that's page two. Because on this tab I just have this information.
Now what if you wanted to print more than one tab as a PDF document?
You basically have to do the same steps as when you want to get a hard copy print out.
You just have to select everything you want.
So in this case let's print these four. I'm going to go with select all sheets first. And then click on
the ones I don't want by holding down the control key.
Now this time I'm going to save a different way as PDF.
Just to show you another method.
You can go to File >
Save as,
and from this dropdown, you can select PDF.
Let's just keep this name and click on Save.
If you click on Browse, you get the same option. From this dropdown you can select PDF, choose the directory
you want to save and then click on Save.
Now let's go and take a look.
That's my PDF file.
It should include all the information in these four tabs.
The page numbers look good.
First tab has just one sheet.
Second tab has two.
That's the third tab
and the fourth tab.
OK so that's how you can save Excel files as a PDF document
and also how you can print many sheets in one go.