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. You can change the scale of a worksheet to make it print bigger or smaller. And the worksheet will still print on three pages, but have page breaks where I want them. I select another row and do the same thing. The manual page break is marked by a solid line. On the PAGE LAYOUT tab, I click Breaks and click Insert Page Break. In the Page Break Preview view, I click the row I want to set a page break above. I want to have certain information on the same page, and I can do this by manually setting page breaks. 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 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. A dotted line indicates an automatic page break. 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. 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. So, I click Size, and click Legal 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. On the PAGE LAYOUT tab, click Orientation, click Landscape, and the entire worksheet will now print in full size on three pages. The entire worksheet will now print in full size on three pages.Īnother way to print the entire worksheet on three pages is to change the worksheet's page orientation. The page to the right is grayed out, meaning it doesn't contain data, and it therefore, won't print. One way is to adjust the worksheet's margins.Ĭlick the PAGE LAYOUT tab, click Margins, click Narrow. Which way works best for a worksheet depends on its dimensions and how you want it to look when it prints. There are several ways to do this without shrinking the worksheet, which may make it hard to read. The page count is down here.īut you want to print the entire worksheet on three pages. Educators earn digital badges that certify knowledge, skill, and experience.Page Layout view shows us that this worksheet is wider than a page by just one column, resulting in six total pages. Save time lesson planning by exploring our library of educator reviews to over 550,000 open educational resources (OER).Īn all-in-one learning object repository and curriculum management platform that combines Lesson Planet’s library of educator-reviews to open educational resources with district materials and district-licensed publisher content.Ī comprehensive online edtech PD solution for schools and districts. Timely and inspiring teaching ideas that you can apply in your classroom Manage saved and uploaded resources and foldersīrowse educational resources by subject and topic Search reviewed educational resources by keyword, subject, grade, type, and more
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |