Print Area


If you set a print area in Excel, only that area will be printed. The print area is saved when you save the workbook.

To set a print area, execute the following steps.

1. Select a range of cells.

Select Range

2. On the Page Layout tab, in the Page Setup group, click Print Area.

Click Print Area

3. Click Set Print Area.

Set Print Area

4. Save, close and reopen the Excel file.

5. On the File tab, click Print.

Result. See the print preview below. Only the print area will be printed.

Print Preview

6. Use the Name Manager to edit and delete print areas.

Do you like this free website? Please follow us on Google+

9/9 Completed! Learn much more about printing >
Back to Top: Print Area   |   Go to Next Chapter: Share