How to drag Page Break In Excel
Click-and-drag page breaks in Excel
0:00 / 0:00
Quality:
Sharing buttons:
hello and welcome to show me academy.com
in this tutorial we're going to show you
how to click and drag page breaks in
Microsoft Excel 2007 first of all I want
explain explained briefly that in
previous tutorial we had shown you how
to insert and remove page breaks if you
go up here to the page Layout tab
there's an option here for breaks and
from here you can insert a page break or
you can remove a page break or you can
reset all page breaks
however the options to insert or remove
or reset don't always give us the finite
degree of control that we need or we
want to tweak a page break by a column
or two or by a row or two let me
illustrate to you what I'm talking about
here I have this table of NFL statistics
and everything looks fine however if I
were to print this data it would be a
bit disjointed because some of it runs
off the page and ends up creating a
second page of data that we probably
don't want in order to illustrate that
for you I'm going to go to the Print
Preview option and this is going to show
us graphically on screen what it will
look like when we send this to the
printer this looks just fine as it is
probably it's pretty hard to see this
exactly because it's shrunken down but
notice I have page 1 of 2 here if I go
to the second page and of having this
this kind of orphaned column that runs
off the first page and into the second
it does this because it couldn't quite
fit that second column in here without
bleeding over past the margins the
problem is that oftentimes when you're
going to print you know that the printer
is capable of getting that last column
in and you really don't want to have
this bled over into a second page for
printout you really want it to be listed
on one page so that you can very clearly
easily see it when you print so the way
to do that is that we're going to go to
page break preview the page break
preview button is down here at the
bottom of the screen and it's right next
to the zoom function here you see we
have this hundred percent
well the button right to the left of it
is the page break preview when I click
on that
this is going to open a different view
notice it gives me this window says
welcome to page break preview you can
adjust where the page breaks are by
clicking and dragging them with your
mouse I'm just going to click OK to get
to this window for now and notice it's
it's another form of a Print Preview
really it's showing me what would show
up on here on page one and just to the
right of this table we have this dotted
line here this dotted line represents
what would be the end of the printed
page and anything that's to the right of
this dotted line is going to end up
bleeding over into a second printed pray
page which we really don't want so in
order to fix that I'm going to mouse
over this dotted line and notice my
cursor changes changes to an arrow
pointing in both left and right
directions and when I mouse over that
I'm going to left-click on it I'm going
to hold the left mouse button down and
I'm going to drag this over to the right
and when I do that now notice that this
dotted line this blue dotted line that
used to be here now is gone you don't
see it because it's superimposed on top
of the solid line here and what that
means now is this actually going to fit
all of this into a single printed page
I'm going to illustrate that for you
further first one go back to my normal
view down here at the bottom of the page
this is the page break video if you go
to buttons over you can go to the normal
view that brings me back to my regular
spreadsheet but I really want to check
this to make sure it looks right so I'm
going to go back and look at the print
preview section when I do that notice
now it says page 1 of 1 there's only a
single page being printed out that's
happening because I basically told it to
take this last column and squeeze it
onto this page I didn't want to bleeding
over into a second page of course this
is not a magical Kiril if you have
dozens of columns or hundreds of columns
of data you're not going to be able to
effectively fit that onto a single page
in fact it will end up printing right
off the edge of the page but when you
have these situations where you have one
column or one row here there that you
want to squeeze into a given page you
can use the page break preview in order
to manually adjust that may
print things on a single page that
concludes this tutorial
thank you for using show me academy com
