Print Area Setting

Excel enables you to define the area of your worksheet you want to print. Setting the print area involves the following steps: 

1. Open the sheet you want to print.
   
2. Select the Page Layout tab of the ribbon. 
3. Highlight the cells making up the print area. 
4. Click the Print Area tool in the Page Setup group. Excel displays some choices below the tool. 
5. Click on Set Print Area. 

Another way to set the print area. which provides more flexibility, is to: 

1. Open the worksheet you want to print.
   
2. Select the Page Layout tab of the ribbon. 
3. Open the Page Setup dialogue box by clicking the small icon in the bottom right corner of the page setup group.
4. Select the Sheet tab.  
5. Click the up arrow at the end of the Print Area field and select the range to print or input the range in the print area field 
6. Click on OK. 

To print multiple ranges, simply enter the ranges (or names) separated by commas, for example, A5:H20,D30:K50. 

Be aware, though, that if you use this method, that once the print area is defined, Excel will only print that selection until the option is changed or removed. You will need to change it if you need to print a different range or the entire spreadsheet.

Alan Salmon