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.