MS-Excel provides you with the option of selecting a specific area for printing. This saves you from printing unnecessary pages. To set the print are, do as follows:
- Select the area that you wish to print
- Go to Page Layout tab
- Click on Print Are button
- Select “Set Print Area”
The selected area will be marked with distinctive border. You can select and add more print areas –and all the selected areas will be printed in one command. But these areas may not necessarily be on one page.