How to Use Page Setup & How to Print | Microsoft Excel

How to Use Page Setup & How to Print | Microsoft Excel


Hi, my name is Shir and I’m the founder and
CEO of shirconsulting.com where we focus on converting the existing data from your business
into massive savings and extraordinary profits. Today we’re going to learn the basics of Excel. Let’s get started. So now that you have your EXCEL SPREADSHEET
filled with data, let’s try printing it out. Here are some basic tips to follow. First thing we’re going to want to do is go
to the View Tab on the RIBBON if we have 2010 or 2007 version of EXCEL. Here, we have a bunch of different choices
– this is version 2010 – so instead of doing the Normal layout, let’s go to Page Layout. That gives us a little preview of what it
looks like on the page. We can scroll down and see the edges of the
page. What’s nice to have here is the Ruler which
you can uncheck this way just to see in terms of the measurements of the page in inches
in this case. The gridlines which of course are the EXCEL
CELLS, the borders themselves. And the different Headers and the Formula
Bar whether you want to see it or not. So here we’re going to have all this visible
so we can add a Header just by clicking on it and saying – “Title of our Data” – and
that will appear on the Header of every page. Or we could do the same thing with a Footer. We can do a page number for example. So another place we need, want to go is the
Page Layout tab which has a bunch of useful commands right here. So the main ones we’re going to focus on are
Margins to basically quickly decide how much space we want in between the content of our
page and the edge. In this case it’s Normal so it gives you the
breakdown of .75″ to the top, to the left, bottom and right. Here’s the breakdown. You can choose Wide or Narrow. I’m going to choose Narrow so we get as much
space as possible. We can change the Orientation so that it’s
Landscape or Portrait. If you want to make it all fit on one page,
it’s usually a good idea to hit Landscape in this case. We’re also going to want to go here and take
a look at the Scale to Fit option. If you have a lot of stuff on your SPREADSHEET
and you want it to fit without having to re-size or change the COLUMNS, you can simply say
– “I want it to all fit on one page of Width.” So I don’t care how many pages it goes vertically
as long as it’s one page Wide. That’s all I want. And that limits it to that, scales it in order
to make it fit. So it literally shrinks down everything so
that it fits into that criteria. I am going to Automatic so it doesn’t really
do anything. You can also say – “I don’t care how Wide
it is, I just don’t want it to be any more than one page high.” And then you can limit it that way. The other option is to simply take the Scale:
Percentage and say “I want to take whatever I have now and make it 50%” and hit ENTER
and now everything is smaller when we print it out. So I am going to hit CTRL+Z to undo that. Another way to get to all these options is
to hit CTRL+P or PRINT or we can also do the File and Print over here. Right, so if I did it with the keyboard it
would be CTRL+P – brings us to what’s called Backstage View and we have a bunch of these
options here as well. We have the – Do we want to print this Active
Sheet, the Entire WORKBOOK or just a Selection of CELLS. We’re going to choose the same Portrait/Landscape
option here, Narrow Margins. And we can also get more options with Page
Setup. Now we have these tabs. Same things that now look familiar.The portrait
or Landscape. Adjust to what percentage of the Normal size. So you’ll start to become familiar with all
these options. The Margins – you can customize it exactly
to what you want by increasing or decreasing with the mouse or you can type in .3 and hit
ENTER and then it takes effect. So you really have full control over how that
works. You can also choose a Header and a Footer
and there’s more options now so that you can say in the Footer – I want to choose Page
1 of whatever, whatever the, how many total you have. You can even choose a different odd and even
page and a different first page. These are very useful when you want to have
the title page not have a number and you want every other page to do that. And that’s how you can customize those options. As soon as you’re done, choose your printer
and then PRINT and you’re all set. And those are some of the basic tips for Page
Setup and Printing in EXCEL.