How To Setup Print Area In Excel – Excel Print Area Selection Guide

by

Defining a print area in Excel tells the software exactly which cells to send to paper. If you have ever printed a spreadsheet only to get dozens of extra blank pages, you know why learning how to setup print area in excel is a game-changer. This guide walks you through every method, from basic selection to advanced dynamic ranges.

Printing only what you need saves time, paper, and frustration. Whether you are a beginner or a seasoned user, these steps will help you control exactly what appears on each page.

Why Setting A Print Area Matters

Excel spreadsheets often contain data that goes far beyond what you want on paper. Without a defined print area, Excel prints everything — including empty cells, hidden rows, and off-screen columns. This leads to wasted paper and confusing outputs.

By setting a print area, you tell Excel to ignore everything outside your selected range. This is especially useful for reports, invoices, dashboards, and any document where precision matters.

Common Scenarios Where Print Areas Help

  • Printing only a summary table from a large dataset
  • Creating a one-page report from a multi-sheet workbook
  • Sharing specific data with colleagues without extra clutter
  • Printing charts alongside their source data

How To Setup Print Area In Excel

This is the core method you will use most often. Follow these steps to define a print area in Excel for any version from 2010 to Microsoft 365.

  1. Open your Excel workbook and select the cells you want to print. Click and drag to highlight the exact range. Hold Ctrl to select multiple non-adjacent areas.
  2. Go to the Page Layout tab on the ribbon. This tab contains all printing-related controls.
  3. In the Page Setup group, click Print Area. A dropdown menu appears.
  4. Choose Set Print Area from the dropdown. Excel draws a dashed border around your selection.
  5. Press Ctrl + P to preview the result. Only your selected cells appear in the print preview.

That is the basic method. But there are more ways to fine-tune your print area, and we cover them below.

Using The Page Setup Dialog Box

Sometimes you need more control. The Page Setup dialog box lets you set the print area, adjust margins, and choose scaling options all in one place.

  1. Select the range you want to print.
  2. Go to Page Layout > Page Setup (click the small arrow in the bottom-right corner of the group).
  3. In the dialog box, click the Sheet tab.
  4. In the Print area field, you will see the range you selected. You can type a range manually, like A1:G25.
  5. Click OK to apply.

This method is useful when you need to set multiple print areas or use named ranges.

Setting Multiple Print Areas On One Sheet

You can print several separate ranges from the same sheet. Excel prints each range on its own page. This is perfect for printing different sections of a dashboard or report.

  1. Select the first range you want to print.
  2. Hold Ctrl and select the second range. Continue until you have all desired areas.
  3. Go to Page Layout > Print Area > Set Print Area.
  4. Excel treats each selected range as a separate print area. They appear on separate pages in the print preview.

Note that non-contiguous ranges print on separate pages. If you want them on the same page, you need to copy them to a new sheet or use a different approach.

Clearing A Print Area

If you no longer need a defined print area, clearing it is simple. This restores Excel’s default behavior of printing the entire sheet.

  1. Go to Page Layout > Print Area.
  2. Select Clear Print Area from the dropdown.
  3. Excel removes all print area definitions for the active sheet.

You can also clear the print area by going into the Page Setup dialog and deleting the range from the Print area field.

Using Named Ranges For Print Areas

Named ranges make your print areas dynamic and easier to manage. If your data changes frequently, a named range automatically adjusts when you update it.

  1. Select the range you want to print.
  2. Go to the Formulas tab and click Define Name.
  3. Enter a name like “PrintRange” and click OK.
  4. Go to Page Layout > Print Area > Set Print Area.
  5. In the Print area field, type the name you created (e.g., PrintRange).

Now, whenever you update the named range, the print area updates automatically. This is a huge time-saver for reports that change weekly.

Dynamic Print Areas With Formulas

For advanced users, you can create a dynamic print area using the OFFSET or INDEX functions. This makes the print area expand or contract based on your data.

For example, to print a table that grows as you add rows, use this formula in the Name Manager:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))

This formula counts non-empty cells in column A and row 1 to define the range. Assign this to a named range, then use that name in the Print area field.

Adjusting Page Breaks With Print Areas

Setting a print area does not automatically control where pages break. You can manually adjust page breaks to ensure your data fits neatly.

  1. Go to View > Page Break Preview. Excel shows blue dashed lines for automatic breaks and solid blue lines for manual breaks.
  2. Drag the blue lines to where you want pages to break.
  3. To insert a manual page break, right-click a row or column and choose Insert Page Break.

Page breaks work hand-in-hand with print areas. If your print area spans multiple pages, adjusting breaks helps control the layout.

Scaling To Fit Within A Print Area

Sometimes your print area is too wide or too tall for one page. Use scaling options to shrink it without changing the data.

  1. Go to Page Layout > Scale to Fit group.
  2. Set Width to 1 page and Height to 1 page.
  3. Excel automatically scales the print area to fit one page.

You can also set a custom percentage in the Scale box. Be careful not to make text too small to read.

Printing Only Selected Cells Without Setting A Print Area

If you need a quick print without defining a permanent print area, use the selection print option.

  1. Select the cells you want to print.
  2. Press Ctrl + P to open print preview.
  3. Under Settings, click the dropdown that says Print Active Sheets.
  4. Choose Print Selection.
  5. Click Print.

This method does not save the print area. It is ideal for one-off prints.

Using Print Titles With Print Areas

When your print area spans multiple pages, you may want row and column headers to repeat on each page. Print titles handle this.

  1. Go to Page Layout > Print Titles.
  2. In the Sheet tab, under Print titles, set Rows to repeat at top and Columns to repeat at left.
  3. Click OK.

Print titles work within the defined print area. They ensure your headers appear on every printed page.

Saving A Print Area With The Workbook

Print areas are saved with the workbook. When you close and reopen the file, the print area remains. This is helpful for templates and recurring reports.

However, if you share the workbook, others can change or clear the print area. To protect it, you can lock the sheet or use a macro to reapply the print area on open.

Print Area Not Working? Common Fixes

Sometimes the print area does not behave as expected. Here are common issues and solutions:

  • Print area includes hidden rows or columns — Unhide them or adjust the selection.
  • Print preview shows extra pages — Check for merged cells or objects outside the range.
  • Print area resets after saving — Ensure you saved the workbook after setting the area.
  • Multiple print areas print on same page — Excel prints non-contiguous ranges on separate pages by default.

Using VBA To Set A Print Area

For repetitive tasks, VBA macros can automate print area setup. This is advanced but powerful.

Here is a simple macro to set a print area from cell A1 to the last used cell:

Sub SetPrintArea()
Dim LastRow As Long
Dim LastCol As Long
LastRow = Cells(Rows.Count, 1).End(xlUp).Row
LastCol = Cells(1, Columns.Count).End(xlToLeft).Column
ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(LastRow, LastCol)).Address
End Sub

Run this macro to automatically define the print area based on your data.

Print Area For Multiple Sheets

If you want the same print area on every sheet, you need to set it individually or use a macro. Excel does not apply print areas across sheets automatically.

To set the same print area on all sheets manually:

  1. Select the first sheet.
  2. Hold Ctrl and click the tabs of other sheets to group them.
  3. Set the print area as usual.
  4. Right-click a sheet tab and choose Ungroup Sheets.

This applies the print area to all selected sheets at once.

Best Practices For Print Areas

Follow these tips to get the most out of print areas:

  • Always preview before printing to catch errors.
  • Use named ranges for dynamic data.
  • Combine print areas with page breaks for complex layouts.
  • Clear old print areas before setting new ones to avoid conflicts.
  • Save your workbook after setting print areas.

Print Area Vs. Print Selection

Print area is saved with the workbook. Print selection is a one-time action. Use print area for recurring reports and print selection for ad-hoc prints.

Both methods work, but print area is more reliable for consistent outputs.

Frequently Asked Questions

How do I set a print area in Excel for multiple sheets?

Group the sheets by holding Ctrl and clicking their tabs, then set the print area. Ungroup after setting. This applies the same area to all selected sheets.

Can I set a print area that automatically expands with new data?

Yes, use a named range with a dynamic formula like OFFSET or INDEX. Assign that name to the print area in Page Setup.

Why does my print area include blank rows?

Your selection may include empty cells. Double-check the range you selected. Also, check for hidden rows or columns within the range.

How do I remove a print area in Excel?

Go to Page Layout > Print Area > Clear Print Area. Alternatively, delete the range from the Print area field in Page Setup.

What is the shortcut to set a print area in Excel?

There is no default shortcut, but you can create one by adding the Set Print Area command to the Quick Access Toolbar. Right-click the ribbon and choose Customize Quick Access Toolbar.

Now you have every method to control what prints from Excel. Start with the basic steps and experiment with dynamic ranges as you grow more comfortable. Your printed spreadsheets will look professional and contain exactly the data your audience needs.