Tip #10: Excel: Setting Print Area

Set Print Area, a popular feature in Excel allows users to select portions of a worksheet for printing. This feature’s location has moved in Office 2007.

By default, Excel prints all data on the current worksheet. You can define a specific print area to print a portion of the worksheet by setting a print area. When you define a print area, Excel will retain settings until it is cleared or replaced.

Setting the Print Area
To set the print area, begin by selecting the group of cells to print. Navigate to the Page Layout tab. In the Page Setup group, click Print Area and select Set Print Area.

Adding to the Existing Print Area
To add more data to the print area select another group of cells. Navigate to the Page Layout tab. In the Page Setup group, click Print Area and select Add to Print Area. The selected cells will be added to the existing print area.

Clearing the Print Area
Navigate to the Page Layout tab. In the Page Setup group, click Print Area and select Clear Print Area.

For more information on printing options in Excel 2007 be sure to check out Microsoft Office Online’s How-to sheets.

Where can I find more information about Office 2007? The ISS Training site provides Quick Reference Guides and Courseware for Microsoft Office. https://portal.twu.edu/iss-training/appstraining/ms_applications.htm