![]() You have two options for adjusting the print area, depending on if you want to incorporate adjacent cells or not. Simply drag them up or down, left or right and position them where you want the pages to break. In the Sheet tab of this dialog, check whether a print area has been specified. The blue line(s) represent where the page breaks are. In the Page tab of the Page Setup dialog, check whether the sheet has been set up to fit into 1 page wide by 1 page tall. You may need to add more cells to your print area after you set it up. On the Page Layout tab of the ribbon, click the little arrow in the lower right corner of the Page Setup group. When you finish, click “Normal” or “Page Layout” to return to your sheet, depending on which view you were using. Open the View tab and select “Page Break Preview.” You’ll then see each print area you’ve set for that sheet. Once you set up your print area, you may want to confirm you’ve selected the right cells. This allows you to quickly print that same spot without resetting the print area. ![]() When it’s time to print, each print area will display on its own page.Īfter you set a print area in your Excel sheet, it will save automatically when you save your workbook. Next, head to the Page Layout tab and pick “Set Print Area” in the Print Area drop-down box. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |