1 00:00:04,850 --> 00:00:08,360 Let's take a look at our prepare for printing challenge. 2 00:00:08,360 --> 00:00:12,230 Number one: Prepare the following data for printing. 3 00:00:12,230 --> 00:00:15,380 Make sure these instructions are not included. 4 00:00:15,470 --> 00:00:18,920 So we basically just want to print the data set. 5 00:00:18,920 --> 00:00:24,520 We don't want to include anything else on that printed version so let's just take a look at how big 6 00:00:24,520 --> 00:00:25,430 our data set is. 7 00:00:25,430 --> 00:00:34,220 It goes until line 66. To only make sure that this data is printed and nothing else, we need to set 8 00:00:34,220 --> 00:00:40,130 the print area. I'm going to use the shortcut key control+a to select this data set. 9 00:00:40,400 --> 00:00:45,960 Go to page layout, print area, set print area. 10 00:00:46,010 --> 00:00:47,180 Now let's just take a look. 11 00:00:47,240 --> 00:00:51,860 If I go to print preview, only this data is shown. 12 00:00:51,860 --> 00:00:55,970 I don't see the list of instructions. Now on the second page 13 00:00:55,970 --> 00:01:01,660 it says two of two. I see the rest of the data but I don't have the headers. 14 00:01:01,700 --> 00:01:04,920 That's what we need to fix in step 2. 15 00:01:04,940 --> 00:01:12,710 Number one is done. Number two: Center the data on paper and ensure the data heading is visible on 16 00:01:12,770 --> 00:01:13,550 each sheet. 17 00:01:13,700 --> 00:01:22,290 To do that, I can go to page set up and go to more page set up options. To make sure that it's centered 18 00:01:22,430 --> 00:01:26,860 I need to adjust that in the margins options here. 19 00:01:26,870 --> 00:01:32,120 Down here says center on page and we'll put a check mark for horizontally. 20 00:01:32,120 --> 00:01:35,570 This is a preview of how our dataset is going to look. 21 00:01:35,570 --> 00:01:41,570 I could also do vertically and then it's going to be in the middle. But it's enough that it's horizontally 22 00:01:41,570 --> 00:01:42,770 centered. 23 00:01:42,770 --> 00:01:44,970 So I'm going to go with that. 24 00:01:45,050 --> 00:01:48,840 The other task was to make sure that the headers are repeated. 25 00:01:49,040 --> 00:01:52,820 That option is available in the sheet tab here. 26 00:01:52,850 --> 00:01:58,560 So rows to repeat on top. Row seven and I can click on OK. 27 00:01:58,570 --> 00:02:02,900 But let's go and take a look at print preview directly from here. 28 00:02:02,900 --> 00:02:04,430 I see it right here. 29 00:02:04,460 --> 00:02:08,410 It's centered and I have the headers on the second page as well. 30 00:02:08,449 --> 00:02:10,039 That was number two. 31 00:02:10,070 --> 00:02:12,410 Number two is done. 32 00:02:12,530 --> 00:02:18,050 Number three: Add the page number and the tab name to the footer. 33 00:02:18,590 --> 00:02:24,950 So this is something I can do either from the page setup options here or I can go to the view tab and 34 00:02:24,950 --> 00:02:26,450 then go to page layout. 35 00:02:26,600 --> 00:02:28,840 I'll just do it directly from here. 36 00:02:28,850 --> 00:02:30,800 Let's go to header and footer. 37 00:02:30,920 --> 00:02:32,960 I want a custom footer. 38 00:02:32,960 --> 00:02:35,360 One is I want page numbers, right? 39 00:02:35,360 --> 00:02:38,780 So that's this one, insert page number. 40 00:02:38,780 --> 00:02:44,930 Let's add a slash here and let's also include the number of pages. 41 00:02:44,960 --> 00:02:48,140 The other task was to add the tab name. 42 00:02:48,140 --> 00:02:53,750 That's one of these options here. If we just hover over it you can see what that icon does. 43 00:02:53,750 --> 00:02:57,250 So it's insert sheet name and then click on OK. 44 00:02:57,680 --> 00:03:02,020 Let's just go directly to print preview and see how this looks. 45 00:03:02,030 --> 00:03:03,380 That's my sheet name. 46 00:03:03,380 --> 00:03:05,330 That's the number of pages. 47 00:03:05,330 --> 00:03:11,990 Everything looks great. Let's press escape to go back. Number three is done. Challenge completed.