Overview Transcript



You want to print a worksheet on a set number of pages. There are several ways to do this without shrinking the worksheet, possibly making it hard to read.

Want more?

Freeze or lock panes

Insert headers and footers

Print a worksheet or workbook

Page Layout view shows us that this worksheet is wider than a page by just one column, resulting in six total pages. The page count is down here.

But you want to print the entire worksheet on three pages. There are several ways to do this without shrinking the worksheet, which may make it hard to read.

Which way works best for a worksheet depends on its dimensions and how you want it to look when it prints.

One way is to adjust the worksheet's margins.

Click the PAGE LAYOUT tab, click Margins, click Narrow.

The page to the right is grayed out, meaning it doesn't contain data, and it therefore, won't print.

The entire worksheet will now print in full size on three pages.

Another way to print the entire worksheet on three pages is to change the worksheet's page orientation.

On the PAGE LAYOUT tab, click Orientation, click Landscape, and the entire worksheet will now print in full size on three pages.

To use a combination of page orientation and paper size to make the worksheet fit on three pages, on the PAGE LAYOUT tab, I click Orientation, and click Landscape. It is still six pages.

So, I click Size, and click Legal and the entire worksheet will now print in full size on three pages.

You can also choose to shrink the worksheet to make it fit on three pages, but be careful that doing so doesn't make the worksheet hard to read.

You can use the Page Break Preview view to configure how the worksheet will print.

Click the VIEW tab, click the Page Break Preview view. A dotted line indicates an automatic page break.

I put the mouse over it, click and hold the left mouse button, drag the dotted line to the right, and the worksheet is now on three pages.

Since we shrunk the worksheet, it is a good idea to print preview and zoom to the actual size of the page to make sure you can still read it.

Click FILE, Print, click Zoom to Page in the lower right corner of Excel, and you can look at the preview and see if you can still read it.

I want to have certain information on the same page, and I can do this by manually setting page breaks.

In the Page Break Preview view, I click the row I want to set a page break above. You can also click a column.

On the PAGE LAYOUT tab, I click Breaks and click Insert Page Break.

The manual page break is marked by a solid line. I select another row and do the same thing. And the worksheet will still print on three pages, but have page breaks where I want them.

You can change the scale of a worksheet to make it print bigger or smaller.

Up here, on the PAGE LAYOUT tab, you can see that the worksheet's scale is 100% and down here that it'll print on six pages.

To make it print on three pages, we need to decrease the scale. Click the arrow next to Width, and click 1 page.

This shrinks the worksheet to 1 sheet wide, which happens to shrink it to three pages in length, just what we want.

Again, since we shrunk the worksheet, it is a good idea to print preview to make sure you can still read it.

You can also set the scale to a specific number.

Click the scale down arrow until the worksheet is of the size you want. You can also click in Scale and type a number.

Up next, Print headings, gridlines, formulas, and more on your worksheet.