Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
Okay, You eventually
00:03
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
00:21
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.
00:32
And in these situations, you need to know a couple of things when the 1st 1 of those is how to format the page.
00:40
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.
00:54
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.
01:03
This one is sheet oriented, so you're not seeing the page it all
01:10
but
01:11
ah, the page format and everything in it is there, and all these things are located in page layout type of the river.
01:19
So if you go to page layout. First of all, the first thing you do is you
01:23
fits. You fix the size of your paper.
01:27
So I have this, um
01:32
this is what you should have had after the labs of the module seven. So this one sheet
01:38
and Ah. So when you go to size,
01:42
you see that it has been set to a four.
01:45
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,
01:53
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.
02:01
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.
02:13
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
02:25
on the left
02:28
and, uh, something like, uh,
02:31
15 or 20 on the right.
02:34
So let's say it's 15
02:37
and we can center it on the page horizontally and vertically so that the table will fit there
02:44
Um
02:45
and that's the first thing you can do. So let's just say OK
02:50
and then go to margins again to custom margins.
02:54
And then here we have Heather and Footer.
02:58
Now I'm going to skip this because there is a nicer way to do Heather and Footer in the
03:05
Excel, and this is to go toe insert
03:07
and then you have Heather and Footer function there or option.
03:13
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,
03:28
Ah,
03:29
annual sales
03:31
report. Sorry, let's put it
03:36
towards 2019
03:39
and that's here
03:43
and then go to insert again. Let's go to Heather and Footer
03:49
and let's go to Footer,
03:51
Portion
03:53
and in footer. We can say you just, uh,
03:59
page number
04:02
off on the total number of pages.
04:08
So rain on dhe. I'm going to click here,
04:12
and it gives us the full view
04:15
again. If you go into page layout for you,
04:18
we can also change the orientation of the page.
04:24
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.
04:33
And it looks like this, and you definitely don't you don't. You see? This here is break between pages,
04:42
so it's definitely something you don't want to do.
04:46
So, uh, what you can do here is that you can scale it
04:56
until you get all off the
05:00
table. The one page,
05:02
and that's approximately something like this.
05:06
But you see, those four
05:09
are now going out,
05:12
and, uh,
05:14
let's keep it like this. So this is where you have set your
05:19
page
05:21
for months. You have, ah,
05:25
fit everything you need for your page.
05:28
And now you're pretty much
05:30
good to go on with another
05:34
part off the print preparation which you can see in the
05:41
next lesson.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor