Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
So in previous lesson you have seen how to form of the page. And now let's go directly to printing sheets. And
00:09
before you just do the print,
00:11
let's do something else as well.
00:15
So we're back in our,
00:17
ah,
00:18
sheet, the worksheet,
00:21
and we're going to go to view,
00:24
and we're going to just create a page layout.
00:29
It's like the page rail view. Or we can also go to page break Preview.
00:36
And here you see
00:38
the break between pages
00:40
as a dotted line here
00:43
and now, if you want all off these things to be
00:48
on one, she told these quarterly charts,
00:53
you move it like here
00:55
and now you'll have a page one and page do,
01:00
and now it's ready to print.
01:03
And, uh, what you do next
01:06
is you
01:07
check it again
01:10
to see if everything is looking fine,
01:12
and now you go to file
01:15
you select print. Or you could have pressed Control P as well.
01:21
And I'm going to select the Microsoft print to Pdf
01:26
because I'm not going to print anything on the paper now because you wouldn't be able to see it.
01:30
So I'm going to just print to pdf.
01:34
Uh, file, and then you will be able to,
01:38
uh, see what I have printed.
01:42
So now here you have options, like in the ah, you selected device. And then you can go to print properties
01:49
and the cop they copied the orientation off from your excel in everything and just you check to your paper size. It's a four,
01:59
although you could have checked it here is well, so it's collected,
02:04
which means that if you print multiple copies, it will print
02:07
Page one page to page three up to last page of the document and then print print it again and again and again so you won't have to sort all this sheets.
02:16
And, uh, you have here the market margin settings, which you can change for the print. But I don't recommend it because it might change your
02:29
printing order or something will fit toe a different page or von fit on a page.
02:37
And, of course, you have customs scaling because this is the thing that we have already selected.
02:43
And here you can select which pages to print So only active sheets or the entire workbook, um, or just the selection in this case we're going to print just deceptive sheet.
02:57
How many copies because it's going to Pdf is going to be one. And you see here Heather and Footer. So annual sales report 2019. And we have Page one off, too,
03:07
and we're just going to click print.
03:12
It's going to ask you for output and the file name, and we're going to just like test because
03:20
it doesn't matter what the
03:22
media father is cold,
03:27
and now it's finished.
03:29
So I'm just going to go to
03:31
this
03:36
test file.
03:38
Open it,
03:40
and you can see how it looks printed.
03:45
So let's zoom out a little. So its annual sales report
03:50
Paige run,
03:52
and this is Page two.
03:53
So this is how it's look. It looks when it's printed,
03:57
and this is what you do in order to print your document in from Excel.
04:02
So there are things that you need to do. If you're used to Microsoft Word and you see something on the screen and it fits on the page and just say print and it goes out directly here, you have to do a few things that you have seen in order to make it
04:17
look professional and get on the paper. Everything that you actually need

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