Formatting Page

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

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