Okay, so suppose we want to print out this entire table on several bits of paper.
So first of all, we have to select everything.
So keep shift pressed down and now go there.
Now to end down arrow to the bottom, and then press the right arrow until I get into the table.
So now I've selected the whole table and I've let go of the shift arrow.
So what I'm going to do because supposing I have to print this off every month or every week or something,
rather than have to go through that selection process, every time I'm going to select up an ancient
name, give it a name.
So you see this name box up here, if I just click on it.
And then I can give it a name like.
So what that means is supposing we are somewhere totally different on the spreadsheet, we can just
click the dropdown box and we see that name we've just selected, click that, then it immediately selects
the print error.
So this is really useful, especially for print areas if you use them over and over again because it's
very fiddly setting the beginning and end of a print area.
So now we've selected that.
Now the problem is if we try and print this off as it is, so file.
Print.
If we print the selection?
Well, we have selected everything says.
This is obviously way too small to read on one bit of paper.
So rather than fit all columns on one page, none of these, I mean, would work.
The physical columns on one page doesn't work.
Physical rows in one page have the same problem.
No scaling is readable, but the problem is this page one just goes up to July.
And then.
This is page two.
I just got here, so it's going of 36 pages.
And this page is meaningless because you can't see the names of the people.
So what we need to do and let's just scroll to the other pages we're going to print off, this is if
more meaningless.
It's just a load of numbers.
You can't even see what month it's in and what names they are.
So this is what you don't want to do.
So what we need to do is to set up rows to repeat.
We want the rows of the top with a months to repeat.
And also we want the column with the names to repeat, to actually print off.
And I'll just show you how to do that.
So let's go back.