How about printing larger data sets?
How could we get the data to fit properly on the printed pages so we can always tell what the header
is that that number belongs to?
So here I have some sample profit development data for these apps.
They go from January 2019 all the way to December 2020.
Notice they take up a lot of space in the rows as well as the columns.
If I go to print preview, this is gonna print on four pages which is not bad.
But check this out. On the last page here
I have no clue what this 800 belongs to.
I need to get the headers on both the rows side as well as the column side
repeated on each single page. There is an option for this.
Let's go to page layout, to page set up and let's go to more options here.
Select sheet, right here we need to select the rows to repeat on the top.
Whatever we select here is going to be repeated on every single page.
We definitely want to have our months there and we also want to get our columns repeated. Because remember
on the last page we don't see the columns either.
Now let's go back to print preview and see how this looks.
First page is nice.
Second page, we get our headers here.
Third page, we get our headers and we get our columns repeated. And the last page
we know what that 800 belongs to.
Now one thing I don't like about this is this page here where I selected the entire column.
I can also see that writing that I had on top. I don't want this in my report. It's enough to see profit
development.
So how can I get rid of that without deleting it?
I can set my print area.
I'm just going to highlight the data only and the header that I want, go to print area and set it.
Now let's go to print preview. This page looks great and everything fits properly.
Now one adjustment to this is to add page numbers. Whenever you're printing something that's more
than two pages, it's good practice to add page numbers to it. And you can do it really quickly by going
to Page Layout view.
There are different ways you can get there. A fast way is to go down here and click on page layout.
So this is the default.
It's the normal view.
This is the Page Layout view. In this view,
you can see how your printed page is going to look
and you can easily add headers and footers. So let's just click here to activate the header and footer
options.
You can type directly in there and you can use some of these elements that are directly available.
For example, you can put the file path.
You can put the file name.
You can add a logo and you can put the current date or the current time. Now to add the page numbers
we need these two.
Let's do that in the footer.
So I'm just going to scroll down here.
Go back to header and footer and click on page number.
It's also nice to see how many pages are in total.
So I'm going to add a space type "of" and put in number of pages.
This way I see the current page and how many pages there are in total.
How do I go back to normal view?
I just have to click here.
Another way of getting there is to go to the view tab here.
Notice from page layout I can switch to normal view also here.
Now let's go back to print preview and we see one of four, two of four, and four of four.