we're going to talk about setting up page breaks and margins in excel when
you print a page or create a PDF you end up with a
column on another page we will discuss how to set up your page to have the page
breaks in the margins the way you want them here we have a relatively large
document now on it in Excel there is are wonderful little buttons here
they are quick to go back and forth so right now you're on the normal view
which is this one and then let's go to the page break view and here your
document is displayed for you and the dotted line is where the page break is
going to be so basically you're going to have one page here in the second page
with two columns
so what we can do is because we have that and then on the bottom we have the
same thing
the page break is here and you can bring it down to the end of your page but so
if we want to have include these columns beyond our one sheet so it doesn't put
on on two different sheets
what we can do is click and drag the dotted line over to the edge to include
both of the columns and so now the entire document will print onto one page
now be careful with this do not drag past
one or two columns and it reduces the size of the text when it accommodates
your desires and if you go much more than one or two columns the text will be
difficult to read
now the dotted line into your the dotted line indicates a page break the solid
line indicates the
the actual end of the page so if we go down to the bar
go down to the bottom of the page here you see that the the end of the page has
dave on the first half of that end of this page in the first off the next page
so I'd like to have days all of Dave sales on one page so what I'm going to
do is I'm going to click and drag it out to to end this at Terry and now your
next page will start with Dave so that isn't another great function that you
can have related darker related information on one page
by changing a page break preview the next thing we're going to talk about is
the page layout view
so let's click on the bottom the bottom button here and we get the page
layout view and basically it shows you how your document is going
to be printed now to actually go to manipulate your page and the page layout
view you'll have to go to page layout on the on your tabs at the top here and
there are many things you can do with your page here
the first thing you you can do is you can go to margins and drop down list
arrow below the margins icon and then you can see that we are normal right now
and you can you can switch to wide and then you can switch to a narrow
and the last thing we have on this list is we have custom now I want on my
margin to be 0.4 on the sides so right now it says .25 so i'm going to go .
.4 and change them both . for
the other thing that that custom has that's nice if you have a smaller
document that doesn't their most to page is you can you can click the box to centre
horizontally and centered vertically but I'm not to select this option right now
and so i'm going to say okay so the other things you have in page layout is
you have the orientation so this is where you can change the portrait which
is in to landscape which would make it horizontal
I'm going back to and then you can select the size of page you like would
you like to put this on a legal page on executive page and so on and so forth so
that is the pages now to get back to your normal view the quickest way to do
is go to your normal View button here on the bottom and there you have your page
setup for you
the dotted line now on your normal on the normal view indicates that this is
where your page is going to end when you printed so hopefully now you'll be able
to create documents either making a printing printed document or a PDF in
the format that you'd like it please subscribe