So in previous lesson you have seen how to form of the page. And now let's go directly to printing sheets. And
before you just do the print,
let's do something else as well.
So we're back in our,
sheet, the worksheet,
and we're going to go to view,
and we're going to just create a page layout.
It's like the page rail view. Or we can also go to page break Preview.
And here you see
the break between pages
as a dotted line here
and now, if you want all off these things to be
on one, she told these quarterly charts,
you move it like here
and now you'll have a page one and page do,
and now it's ready to print.
And, uh, what you do next
check it again
to see if everything is looking fine,
and now you go to file
you select print. Or you could have pressed Control P as well.
And I'm going to select the Microsoft print to Pdf
because I'm not going to print anything on the paper now because you wouldn't be able to see it.
So I'm going to just print to pdf.
Uh, file, and then you will be able to,
uh, see what I have printed.
So now here you have options, like in the ah, you selected device. And then you can go to print properties
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,
although you could have checked it here is well, so it's collected,
which means that if you print multiple copies, it will print
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.
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
printing order or something will fit toe a different page or von fit on a page.
And, of course, you have customs scaling because this is the thing that we have already selected.
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.
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,
and we're just going to click print.
It's going to ask you for output and the file name, and we're going to just like test because
it doesn't matter what the
media father is cold,
and now it's finished.
So I'm just going to go to
and you can see how it looks printed.
So let's zoom out a little. So its annual sales report
and this is Page two.
So this is how it's look. It looks when it's printed,
and this is what you do in order to print your document in from Excel.
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
look professional and get on the paper. Everything that you actually need