Back on the Page Layout tab, click “Clear Print Area” in the Print Area drop-down box. Select the print area or a cell within it. This saves you from having to select it every time you want to print. It also creates a named range for the selected area (the name PrintArea would be. This would set the selected cells as the print area. Go to Page Layout > Page Setup > Print Area > Set Print Area. If you make many changes to your sheet, prefer not to print only a specific section, or want to set up a new print area, you can remove an existing one easily. If you frequently print a certain part of your spreadsheet, you can choose a designated print area in Microsoft Excel. Here are the steps to set the print area in Excel: Select the range of cells that you want to set as the print area in that Excel worksheet. Note: Alternatively, you can select File > Print or use a keyboard shortcut, Ctrl+F2, to see your print preview.
Hit the arrow on the top left to return to your sheet. You’ll then see exactly what the sheet will look like when you print. Click the arrow on the bottom right corner of the Page Setup section of the ribbon. If you want to see a quick preview of how the page will look when you print it, return to the Page Layout tab. Then if you use the Page Break Preview, you can see that the print area has been increased and stays on the same page. Open the View tab and select “Page Break Preview.” You’ll then see each print area you’ve set for that sheet. Note: The print area that you set is saved when you save the workbook. You can follow the question or vote as helpful, but you cannot reply to this thread. Once you set up your print area, you may want to confirm you’ve selected the right cells. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area. How do you set the print area of a worksheet using Excel Mobile This thread is locked. 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. To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. To set a single print area, select the cells. You can set one or more print areas in the same Excel sheet.
0 kommentar(er)
