Microsoft Excel logo on a green background

If you frequently print a certain part of your spreadsheet, you can choose a designated print area in Microsoft Excel. This saves you from having to select it every time you want to print. We’ll show you how.

How to Set a Print Area in Excel

You can set one or more print areas in the same Excel sheet. To set a single print area, select the cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. Choose “Set Print Area.”

Click Print Area, Set Print Area

To set multiple print areas in your sheet, hold Ctrl as you select each group of cells.

Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. Next, head to the Page Layout tab and pick “Set Print Area” in the Print Area drop-down box. When it’s time to print, each print area will display on its own page.

Click Print Area, Set Print Area

After you set a print area in your Excel sheet, it will save automatically when you save your workbook. This allows you to quickly print that same spot without resetting the print area.

How to View a Print Area

Once you set up your print area, you may want to confirm you’ve selected the right cells. Open the View tab and select “Page Break Preview.” You’ll then see each print area you’ve set for that sheet.

Click Page Break Preview to see print areas

Advertisement

When you finish, click “Normal” or “Page Layout” to return to your sheet, depending on which view you were using.

How to Add Cells to a Print Area

You may need to add more cells to your print area after you set it up. You have two options for adjusting the print area, depending on if you want to incorporate adjacent cells or not.

If you simply want to include another set of cells in the print area setup, select the cells. Then, go to the Page Layout tab and select “Add to Print Area” in the Print Area drop-down box.

Add Nonadjacent Cells

When you do this, those additional cells are considered their own print area because they are not adjacent to another print area in the sheet. So, that group of cells will print on their own page as you can see below in the Page Break Preview.

Preview Nonadjacent Cells

Now if you want to increase the size of a current print area to include more cells, be sure to select the cells adjacent to the area. Then, select “Add to Print Area” in the Print Area drop-down box.

Add Adjacent Cells

Advertisement

Then if you use the Page Break Preview, you can see that the print area has been increased and stays on the same page.

Preview Adjacent Cells

How to View a Print Preview

If you want to see a quick preview of how the page will look when you print it, return to the Page Layout tab. Click the arrow on the bottom right corner of the Page Setup section of the ribbon.

Click the arrow for Page Setup

Click “Print Preview.”

Click Print Preview

You’ll then see exactly what the sheet will look like when you print. Hit the arrow on the top left to return to your sheet.

Print preview in Excel

Note: Alternatively, you can select File > Print or use a keyboard shortcut, Ctrl+F2, to see your print preview.

How to Clear a Print Area

If you make many changes to your sheet, prefer not to print only a specific section, or want to set up a new print area, you can remove an existing one easily.

Select the print area or a cell within it. Back on the Page Layout tab, click “Clear Print Area” in the Print Area drop-down box.

Click Print Layout, Clear Print Area

If you have more than one print area set up, simply do this for each one on your sheet.

Advertisement

For additional help printing in Microsoft Excel, learn how to print the gridlines with row and column headers or how to print an Excel sheet that has a background.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio ยป

The above article may contain affiliate links, which help support How-To Geek.