1 00:00:00,560 --> 00:00:04,340 Until now we took a look at printing one sheet at a time. 2 00:00:04,370 --> 00:00:09,200 But what if you wanted to print many sheets in one go? Or your entire workbook? 3 00:00:09,200 --> 00:00:14,190 Also how can you save these sheets as a PDF document? 4 00:00:14,210 --> 00:00:16,510 Let's take a look at printing more than one sheet. 5 00:00:16,640 --> 00:00:23,210 First, all you need to do is hold down the control key and select the other tab that you want. 6 00:00:23,210 --> 00:00:30,590 Just remember before you need to do the work to make sure that each tab looks good when it's being printed. 7 00:00:30,590 --> 00:00:35,520 Once that work is done, you just need to select them and go to print preview. 8 00:00:35,540 --> 00:00:39,030 That's the first tab and this is the second tab. 9 00:00:39,140 --> 00:00:45,740 If you have the page numbers activated for each of the tabs in the footer then you get the correct total 10 00:00:45,740 --> 00:00:47,560 number of page numbers 11 00:00:47,600 --> 00:00:55,220 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 12 00:00:55,220 --> 00:00:58,550 the page numbers to reflect your entire printout. 13 00:00:58,580 --> 00:01:02,410 If you wanted to print the entire workbook in one go, you can 14 00:01:02,420 --> 00:01:08,840 select that from here. What if you wanted to print most of the sheets but exclude one or two? 15 00:01:08,870 --> 00:01:11,630 Let's say you have a large workbook with many sheets. 16 00:01:11,750 --> 00:01:16,860 It's gonna be a pain if you need to go hold down control and select each of these sheets. 17 00:01:16,880 --> 00:01:23,060 To do that you just right mouse click on any of these tabs, select all sheets. And then hold down the 18 00:01:23,060 --> 00:01:30,290 control key and select the ones you don't want. And then go to print preview or print directly. 19 00:01:30,290 --> 00:01:36,210 Now let's take a look at how we can save different tabs as a PDF document. 20 00:01:36,260 --> 00:01:38,010 Let's start with this one. 21 00:01:38,030 --> 00:01:42,350 Let's just say we want to only save this tab as a PDF. 22 00:01:42,620 --> 00:01:48,920 Once I make sure everything is adjusted for printing I can go to File > Export. 23 00:01:48,950 --> 00:01:54,830 Click on create PDF, select where you want to save it and give it a name. 24 00:01:54,830 --> 00:01:58,340 By default it's taking the name of my workbook. 25 00:01:58,460 --> 00:02:02,630 I'm just going to put Tab 2 and click on publish. 26 00:02:02,630 --> 00:02:05,690 Now you can set additional options here. 27 00:02:05,690 --> 00:02:09,919 If you just had selected part of the sheet, you can click on selection. 28 00:02:09,919 --> 00:02:17,030 If you want the entire workbook to be saved as PDF, you can make this selection. And then click on OK 29 00:02:17,510 --> 00:02:18,810 and publish. 30 00:02:18,830 --> 00:02:21,010 Now let's go and take a look. 31 00:02:21,020 --> 00:02:22,200 That's what I saved. 32 00:02:22,210 --> 00:02:25,650 Double click. That's page one, 33 00:02:25,720 --> 00:02:31,190 and that's page two. Because on this tab I just have this information. 34 00:02:31,210 --> 00:02:35,110 Now what if you wanted to print more than one tab as a PDF document? 35 00:02:35,230 --> 00:02:40,120 You basically have to do the same steps as when you want to get a hard copy print out. 36 00:02:40,120 --> 00:02:42,400 You just have to select everything you want. 37 00:02:42,400 --> 00:02:47,590 So in this case let's print these four. I'm going to go with select all sheets first. And then click on 38 00:02:47,590 --> 00:02:51,700 the ones I don't want by holding down the control key. 39 00:02:51,700 --> 00:02:54,870 Now this time I'm going to save a different way as PDF. 40 00:02:54,910 --> 00:02:56,950 Just to show you another method. 41 00:02:56,950 --> 00:02:58,110 You can go to File > 42 00:02:58,120 --> 00:02:59,290 Save as, 43 00:02:59,290 --> 00:03:03,430 and from this dropdown, you can select PDF. 44 00:03:03,670 --> 00:03:06,680 Let's just keep this name and click on Save. 45 00:03:06,880 --> 00:03:14,320 If you click on Browse, you get the same option. From this dropdown you can select PDF, choose the directory 46 00:03:14,350 --> 00:03:17,470 you want to save and then click on Save. 47 00:03:17,470 --> 00:03:19,240 Now let's go and take a look. 48 00:03:19,480 --> 00:03:21,070 That's my PDF file. 49 00:03:21,070 --> 00:03:25,030 It should include all the information in these four tabs. 50 00:03:25,030 --> 00:03:26,430 The page numbers look good. 51 00:03:26,470 --> 00:03:28,230 First tab has just one sheet. 52 00:03:28,330 --> 00:03:29,890 Second tab has two. 53 00:03:29,950 --> 00:03:31,750 That's the third tab 54 00:03:31,750 --> 00:03:32,870 and the fourth tab. 55 00:03:33,400 --> 00:03:38,980 OK so that's how you can save Excel files as a PDF document 56 00:03:38,980 --> 00:03:41,950 and also how you can print many sheets in one go.