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. 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.Ĭlick 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.Ĭlick 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. 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.
0 Comments
Leave a Reply. |