6 hours 3 minutes
Okay, You eventually
or sometimes you will have to print what you did in Excel. For example, if you're submitting a report in hard copy or you work in a company and you want to print your reports so you can
give them to people you're presenting so that they can have card copy in front of their Selves while you are going through pages and sheets and whatever.
And in these situations, you need to know a couple of things when the 1st 1 of those is how to format the page.
So former thing the page is, Ah, one typical thing that you never do in Excel because everything is so big and you look what's in a screen and you never think off putting anything on the page.
And there is not like, for example, in my word where you automatically see the page when you start typing because it's a text oriented the software.
This one is sheet oriented, so you're not seeing the page it all
ah, the page format and everything in it is there, and all these things are located in page layout type of the river.
So if you go to page layout. First of all, the first thing you do is you
fits. You fix the size of your paper.
So I have this, um
this is what you should have had after the labs of the module seven. So this one sheet
and Ah. So when you go to size,
you see that it has been set to a four.
It could have been said to letter if you're in the United States or the part of the world, that's using that kind of paper,
but time in Europe and we use a size paper and this is a four. So the first thing I did is do the four.
The second thing I want to do is to set margins on my page of the normal setting or whatever. Setting is based on one inches.
And because even use centimeters here in in Europe, it is common to have, like, 20 millimeters on top and the bottom and maybe 25
on the left
and, uh, something like, uh,
15 or 20 on the right.
So let's say it's 15
and we can center it on the page horizontally and vertically so that the table will fit there
and that's the first thing you can do. So let's just say OK
and then go to margins again to custom margins.
And then here we have Heather and Footer.
Now I'm going to skip this because there is a nicer way to do Heather and Footer in the
Excel, and this is to go toe insert
and then you have Heather and Footer function there or option.
And when you do that, you get this very nice view in which you actually see the page format. So in Heather, we can type, for example,
report. Sorry, let's put it
and that's here
and then go to insert again. Let's go to Heather and Footer
and let's go to Footer,
and in footer. We can say you just, uh,
off on the total number of pages.
So rain on dhe. I'm going to click here,
and it gives us the full view
again. If you go into page layout for you,
we can also change the orientation of the page.
And because it's ah, sales report, it's common that we have it in landscape mode, So let's do it in, Let's get mode.
And it looks like this, and you definitely don't you don't. You see? This here is break between pages,
so it's definitely something you don't want to do.
So, uh, what you can do here is that you can scale it
until you get all off the
table. The one page,
and that's approximately something like this.
But you see, those four
are now going out,
let's keep it like this. So this is where you have set your
for months. You have, ah,
fit everything you need for your page.
And now you're pretty much
good to go on with another
part off the print preparation which you can see in the