When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed.
In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. This feature is known as Print Area.Ī print area is a range of cells to be included in the final printout. But what if you don't really need all the content of a huge worksheet on paper? Luckily, Excel provides the ability define the parts for printing. When you hit the Print button in Excel, the entire spreadsheet is printed by default, which often takes multiple pages. In this tutorial, you will learn how to select print area in Excel manually and how to set print ranges for multiple sheets by using macros.
