Microsoft Excel 44 Page Setup and Printing Options

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Page Setup and Printing Options in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So over here you can see that I have a table and let's say I want to do a page setup so that this

00:11data prints in a certain way. For that you can go ahead and use the page setup and printing options.

00:17So for that you can actually go around onto the page layout tab right here and then actually go

00:22around over here onto page setup right here. Click on the small icon besides the page setup and the

00:27page setup opens up. Here you can go ahead and choose landscape mode right here and even go ahead

00:32and change the scaling size right here and even go ahead and fit it out right here. That is fit the

00:38selected table right here in certain page right here. Like let's say for example fit to one page by

00:45one page tall right here. You can choose the paper size as you want and even go ahead and set up the

00:51margins as you like right here just like this as needed and even set the header and footer. So you

00:57can go ahead and let's say for example add in page right here in header and you can even go ahead

01:03and add in the seat right here on the footer and so forth. You can even go around over here and then

01:08select out the print area right here just like this right here and press ok and the page setup is done.

01:15So now you if you want to go ahead and see the preview of the printing you can actually go around

01:19over here onto the view and then go around onto page layout and you would see that the changes

01:25accordingly right here. So apart from that you can also go to file and then go to print and you get

01:31the print option right here and you can see the header and footer as we set out. You can go ahead

01:36and print only the active seats or print only the selection as well as you can see right here. You can

01:41go ahead and change the orientation later around over here as well and even the paper size and even go

01:46ahead and set the margin as you like from over here or even go ahead and fit it out. Have no scaling

01:52right here but it gets cut off as you can see or fit the seat to one piece right here. Then you can

01:57simply go ahead and print this out as you like. So now this is using my physical printer but let me

02:04just go ahead and choose let's say for example Microsoft print to PDF. So it actually prints out

02:10a PDF piece for me. So if I were to go ahead and print it out I can simply go ahead right here and

02:15then save it out as sample. Let's say for example right here and click on save and then it'll go ahead

02:21and print it out for me. And then this has been saved as a PDF file. So if I were to open it this is what

02:28you see as you can see right here. So this would how the page would actually look if it were to be printed

02:34out. And that is how you can go ahead and work around with the page setup and printing options in

02:39Microsoft Excel. So I hope you found this video useful. Be sure to hit the like button. Don't forget to share this

02:46out with our friends and family and for more contents like these do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended