- [Instructor] Let's go over some of the options
that you have when printing a large Excel spreadsheet.
The first thing you'll do is go to File and Print,
just to see what happens.
In this case, I can see that this is 464 pages.
And as you can see,
not all of the column headers fit across the page.
So let's see what we can do about that.
I'll hit the back button.
And there are some things that we can do in this spreadsheet
to try to make it a little bit easier.
The first thing I'm going to do
is all the way on the bottom right-hand side of the screen,
to the left of the slider bar,
I'm going to click Page Break Preview.
I'll zoom in a bit so that you can see what's going on here.
This is showing me how Excel has decided
to print all of the pages.
Here, you can see a watermarked Page 1,
and to the right of that, Page 117, and then Page 233.
So what's going on is that Excel
is first printing all of these rows.
Right, here's Page 2.
If I scroll down, here's Page 3.
And it clearly has 116 pages of that
because now it's going to move on to the next columns.
It's going to print those, and then finally,
it's going to print these.
Now, that doesn't help anybody.
But in this view, you can manipulate these page breaks
to see what you're going to get before you print them.
Now, if I had data all the way on the right-hand side
that I didn't want,
I can click and drag on that data
and exclude it from the Print view.
It's shaded, meaning it's not going to print.
I'll undo that because it's this middle row
that I don't want to print.
If I'm printing my sales sheets,
I want the order number, the order date,
and all the way on the right-hand side,
I want the quantities and the prices.
So one option that I have
is clicking and dragging on these column headers
and just completely hiding these rows.
In fact, I don't want this product name either.
So I will right-click and hide them.
This looks a little bit better,
but I can see that we still have two pages.
It's not going to fit on one page.
But I might be able to make it fit on one page.
Here's my page break.
Now, before we drag it in from the right,
I'm going to drag this page break all the way across.
Now I have Page 1, and it's scrolling all the way down.
Here's Page 2.
So while all the data I want currently fits on a page,
will it print so that we can read it?
The only way to find out for sure
is to go back to the print preview.
So I'll click File, Print,
and I'll see my preview.
It's a little bit hard to read,
but there's still some more that I can do here.
For example, what happens if I change the orientation
to landscape?
And now I've got all this white space.
Let's see if we can use that and make the text bigger.
I'll click this Custom Scaling button,
and I'll choose to fit all the columns on one page.
Now it's going to grow them a bit.
The font is a little bit larger,
and it does mean I have more pages to print out,
but it's definitely readable.
So that's one way that you can get your printouts
to work just the way you want them to.
Another way, and I'll go back to the regular view,
and we do that by clicking Normal down here
on the bottom right-hand side of the screen.
I still have my columns hidden.
I'll double-click and unhide some of them.
We can also select data and only print what we've selected.
For example, if I only want columns A through D to print,
I can click File, Print.
And in Settings where it says only print active sheets,
I'm going to say Print Selection.
I'll click Show Print Preview.
It's got to think about it.
And it's only going to show me those columns
that I have selected.
Now, in addition to these options,
you can always change to the Page Layout tab.
Here, there's a whole icon bar of things that you can do
to make this print exactly how you want it.
You can set the margins, the page orientation, the size,
even the print area of what you want.
You can choose to print gridlines and headings.
It's completely up to you.
When you're all done, the easiest way
to find out what it's going to look like
is to always go to File and Print.
You can see what it will look like
in this print preview screen.
And when you're done, click Print when you're ready to go.