Now let's take a look at how we can print parts of a sheet and how we can add page breaks for full control.
This way we can decide where we want
the first page to end and the second page to start.
This is the type of report we're dealing with.
So in the first step, let's say we're just interested to print parts of this.
We just want the list of apps and sales for 2019.
One way to do this is to highlight the area you want printed and go to file, print, change this dropdown
to print selection.
The moment you do that, it shows you what you've selected on the Excel side
and that's what is going to print.
It's one of one.
So notice when I go back to active sheet, it's actually by default going to print this on four
separate sheets.
Now what if you always wanted to just print those two columns
whenever someone pressed print. You don't want them to remember to highlight and then go select print
selection.
You just want him to be able to press print
and it only prints those two columns. The way you can set this is to go to page layout, highlight the
area that you want, and then set the print area by clicking on print area and then set it.
This forces the print area to always only be this area.
Now anytime we go to print preview we only see what we selected.
Notice this side is set to print active sheets. It sees the active sheet as only these two columns.
It completely ignores everything else.
So that's the advantage of setting your print area.
Let's remove this print area, clear print area.
Now let's say I want to print this full document and I want to have my table in one page and the two
charts on another page.
How can a make Excel format this properly for me.
Well I have some options here from scale to fit.
I could say try to fit this on one page and the height should be probably two pages and I can try
one page. Scale is really low which means everything is going to be super small.
If I go to print preview I don't really want it like this.
I want them sitting on their own pages.
Now let's also change the orientation of this and see if that improves. That reduces the scale even further.
How do I get Excel to actually fit the page breaks to where I want?
This is where you can insert your own page breaks.
What I'm going to do is just set this back to automatic.
Let's go and insert a page break right here.
Now let's go and take a look at how this is going to look.
Until now the scale is still set to 54 percent.
We don't want that scaling so let's change that.
This part looks good but this part doesn't look good.
It's cutting through one of my charts.
I want both charts to fit on one page.
This is where you can directly control the page breaks.
To do that go to the view tab and click on page break preview.
This takes you out of normal view and shows you how Excel is planning to print.
The dark blue borders are the ones that we've set and the dashed ones are the ones that Excel' set
for us.
Now this one I'm not so happy about so I'm going to pull it that way because I want it to force the
page break to be here so the full chart can fit in.
Now I can also reduce that column and notice here behind there's another page break.
That's where it was cutting my chart.
I'm going to push that down as well to make this part fit
on the second page. And I can even expand this further as well and then adjust my charts.
So it takes a little bit of adjustment to get it fit the way you want.
Now let's go back to normal view.
We can see the other page breaks have adjusted.
Let's go to print preview and we can see everything fits well.
So that's how you can use page breaks to get full control over your printouts.