Let's take a look at our prepare for printing challenge.
Number one: Prepare the following data for printing.
Make sure these instructions are not included.
So we basically just want to print the data set.
We don't want to include anything else on that printed version so let's just take a look at how big
our data set is.
It goes until line 66. To only make sure that this data is printed and nothing else, we need to set
the print area. I'm going to use the shortcut key control+a to select this data set.
Go to page layout, print area, set print area.
Now let's just take a look.
If I go to print preview, only this data is shown.
I don't see the list of instructions. Now on the second page
it says two of two. I see the rest of the data but I don't have the headers.
That's what we need to fix in step 2.
Number one is done. Number two: Center the data on paper and ensure the data heading is visible on
each sheet.
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
I need to adjust that in the margins options here.
Down here says center on page and we'll put a check mark for horizontally.
This is a preview of how our dataset is going to look.
I could also do vertically and then it's going to be in the middle. But it's enough that it's horizontally
centered.
So I'm going to go with that.
The other task was to make sure that the headers are repeated.
That option is available in the sheet tab here.
So rows to repeat on top. Row seven and I can click on OK.
But let's go and take a look at print preview directly from here.
I see it right here.
It's centered and I have the headers on the second page as well.
That was number two.
Number two is done.
Number three: Add the page number and the tab name to the footer.
So this is something I can do either from the page setup options here or I can go to the view tab and
then go to page layout.
I'll just do it directly from here.
Let's go to header and footer.
I want a custom footer.
One is I want page numbers, right?
So that's this one, insert page number.
Let's add a slash here and let's also include the number of pages.
The other task was to add the tab name.
That's one of these options here. If we just hover over it you can see what that icon does.
So it's insert sheet name and then click on OK.
Let's just go directly to print preview and see how this looks.
That's my sheet name.
That's the number of pages.
Everything looks great. Let's press escape to go back. Number three is done. Challenge completed.