What the print area does and why you'd change it

The print area in Excel is the section of your spreadsheet that actually prints when you hit print. By default, Excel prints everything on your sheet — but most of the time you only want certain rows, columns, or a specific table to come out on paper. Changing the print area tells Excel exactly which cells to include, so you don't waste paper printing blank rows or data you don't need.

You might change the print area because you're printing a report that only uses columns A through D, or because you have a data entry sheet where only the top section matters. Once you set a print area, Excel remembers it — the next time you print that sheet, it will use the same boundaries unless you change them again.

Key Takeaways

  • Select the cells you want to print first, then use the Page Layout tab to set that selection as your print area.
  • Excel remembers your print area each time you open the file, so you only need to set it once per sheet.
  • You can add more cells to an existing print area or clear it entirely to go back to printing the whole sheet.
  • Preview your print area in Print Preview before you print, so you can see exactly what will come out on paper.

How to select and set your print area in three steps

Start by clicking on the first cell of the range you want to print. Then hold Shift and click on the last cell of that range — this selects all the cells in between. For example, if you want to print cells A1 through D20, click on A1, hold Shift, and click on D20. You'll see the selected area highlighted in blue.

Once your range is selected, go to the Page Layout tab at the top of the ribbon. Look for the button labeled Print Area — it's usually in the middle-left section of the ribbon. Click the dropdown arrow next to it and select Set Print Area. Excel will now remember this range as your print area.

That's it. The next time you print this sheet (using Ctrl+P or File > Print), Excel will only print the cells you selected. The print area stays in place until you change it or clear it.

Adding more cells to an existing print area

If you've already set a print area and want to add more cells to it, you don't start over — you extend it. Select the new cells you want to add (using the same click-and-Shift-click method), then go back to Page Layout > Print Area. This time, click the dropdown and choose Add to Print Area.

Excel will now print both your original range and the new cells you selected. This is useful if you realize you forgot a column or a section of data after you've already set the print area once.

Clearing the print area to print the whole sheet again

If you want to go back to printing everything on the sheet, you need to clear the print area. Go to the Page Layout tab, click the Print Area dropdown, and select Clear Print Area. Excel will remove the boundaries and the next time you print, it will include all cells with data on that sheet.

Clearing the print area doesn't delete any of your data — it just tells Excel to stop limiting what it prints. You can set a new print area anytime after this.

Using Print Preview to check your print area before printing

Before you actually print, it's smart to see what the page will look like. Go to File at the top left, then click Print. On the right side of the screen, you'll see a preview of your page. This preview shows exactly what will print based on your current print area — if it looks wrong, you can close this window and adjust your selection.

The preview also shows you how many pages your print area will use. If your print area is wider than one page, Excel will split it across multiple pages, and the preview will show you where the page breaks fall. This helps you decide if you need to adjust your print area or change your page orientation from portrait to landscape.

Printing specific sheets when your workbook has multiple sheets

If your Excel file has more than one sheet (you'll see tabs at the bottom), each sheet can have its own print area. When you set a print area on Sheet1, it doesn't affect Sheet2 — they're independent. This means you can set different print areas for different sheets depending on what each one contains.

When you go to print, make sure you're on the sheet you want to print. If you want to print multiple sheets at once, you can select them by holding Ctrl and clicking on each sheet tab, then go to File > Print and choose "Print Entire Workbook" or "Print Selected Sheets" depending on your version of Excel.

Frequently Asked Questions

Can I set a print area that's not a rectangle?

No — the print area must be a rectangular block of cells. If you need to print non-adjacent columns or rows, you'll need to either rearrange your data so the cells you want are next to each other, or print the whole sheet and manually remove the pages you don't need.

Does the print area affect what I see on screen?

No. The print area only controls what prints — it doesn't hide or change anything on your screen. You'll still see all your data normally while you work.

What happens to the print area if I move or delete cells?

If you delete cells that are part of your print area, Excel will adjust the boundaries automatically. If you move cells around, the print area stays tied to the original cell references, so it may no longer include what you intended — you'll want to reset it after major changes.

Can I save different print areas for the same sheet?

Excel only stores one print area per sheet at a time. If you need to print different sections regularly, you can set the print area each time before you print, or create separate sheets for different reports.