How to Set, Clear, and Expand Print Areas in Microsoft Excel

Setting a print area in Microsoft Excel ensures you only print the essential data, saving paper and highlighting key insights without unnecessary rows or columns. As Excel experts with years of experience optimizing spreadsheets for professionals, we've streamlined this process for you.

Excel printing doesn't have to be daunting. Follow these proven steps to master it.

How to Set a Print Area in Microsoft Excel

1. Select the cells you want to define as the print area by dragging across them.
2. Go to the Page Layout tab on the ribbon. In the Page Setup group, click Print Area > Set Print Area.

To print multiple areas: Hold Ctrl and select each range. Each area prints on its own page.

You don't need to print immediately—print areas are saved with the workbook.

How to Clear the Print Area in Microsoft Excel

If you make a mistake, clearing is simple and removes all print areas at once.

1. Click anywhere in the worksheet.
2. On the Page Layout tab, in the Page Setup group, click Print Area > Clear Print Area.

How to Expand a Print Area in Microsoft Excel

Missed some adjacent cells? Add them easily. Non-adjacent cells create a new print area on a separate page.

1. Select the cells to add to the existing print area.
2. On the Page Layout tab, click Page Setup > Print Area > Add to Print Area.

Print areas go beyond saving toner—they make your data clearer and more professional.