In the second case, each print area in that worksheet will print as a separate page.
If you are adding adjacent cells, you will just enlarge the existing print area but if you are adding non-adjacent cells, you will create a new print area. To extend an existing print area, select the cells you want to add, and in the Ribbon, go to Page Layout > Print Area > Add to Print Area. To add another range to the print area, select another range of data, and then in the Ribbon, go to Page Layout > Print Area > Add to Print Area.Īs a result, you simultaneously have two ranges of data in the print area. Then in the Ribbon, go to Page Layout > Print Area > Set Print Area.Ģ. To set multiple ranges, start by selecting the first range you want to set as print area. To do that, in the Ribbon, go to Page Layout > Print Area > Set Print Area.Īs a result, you have three print areas, and each will print as a separate page.ġ.
Now that you’ve selected your non-adjacent range, you can proceed to set that as a print area.Ģ. Then press the CTRL key on the keyboard and individually select the rest of the cells you want to add. To set non-adjacent ranges, click on the first cell you want to choose. In the Ribbon go to View > Page Break Preview.Īs a result, you can see the print area that you selected.ġ. Then in the Ribbon, go to Page Layout > Print Area > Set Print Area.Ģ. To set the print area a range of data in Excel, first select the range you want to set as print area.
Excel keyboard shortcut to print selection how to#
In this tutorial, you will learn how to set print areas in Excel and Google Sheets.ġ.
0 kommentar(er)
