How to Set Print Area in Excel: Complete Step-by-Step Guide

Setting a print area in Excel is the difference between a clean, professional report and ten pages of scattered cells you never meant to print. Anyone who has ever hit Print on a spreadsheet only to watch the printer spit out half a row on page seven knows the feeling. The good news? Excel gives you full control over exactly what lands on paper, and learning how to set print area in Excel takes about two minutes once you know where to click.

The Print Area feature lets you pick a specific range of cells and tell Excel: this is the only part I care about. Everything else gets ignored when you print. You can save that selection so it sticks every time you reopen the file, add to it later, clear it when you change your mind, or set different print areas for different sheets in the same workbook. It is one of those Excel features that looks small but quietly saves hours over a career.

This guide walks through every method, every shortcut, every quirk. Whether you are on Windows, Mac, or Excel for the web, by the end of this article you will know exactly how to set print area in Excel and how to fix it when something goes wrong.

What Is a Print Area in Excel?

A print area is a saved range of cells that Excel uses as the boundary for printing. Instead of printing the entire sheet, including empty columns out at column AZ and stray notes hiding in row 500, Excel only sends the cells inside your defined area to the printer. The setting lives with the worksheet itself, so once you set it and save the file, it stays put.

Excel stores the print area as a named range called Print_Area. You can see this in the Name Manager (Formulas tab) once a print area exists. Each worksheet can have its own print area, and a single sheet can include multiple non-adjacent ranges in one print area, which is handy when you want page one to show the summary and page two to show the data table without printing the formulas in between.

Why bother setting a print area?

Three reasons. First, control: you decide what gets printed and what stays digital. Second, consistency: the same range prints every time, even if a colleague opens the file. Third, professionalism: reports look intentional rather than accidental. For anyone preparing a budget, a dashboard, or a class roster, a clean print area is the small touch that signals attention to detail.

How to Set Print Area in Excel: Step by Step

Here is the standard method that works in Excel 2016, 2019, 2021, Microsoft 365, and Excel for Mac. The clicks are nearly identical across versions.

Step 1: Open the worksheet

Open the Excel file and click into the sheet that contains the data you want to print. Print areas are sheet-specific, so be sure you are on the right tab before selecting anything.

Step 2: Select the cells

Click and drag to highlight the range you want printed. You can select a single rectangle (most common) or hold Ctrl on Windows / Cmd on Mac and select multiple separate ranges. Each separate range will print on its own page when you set it as a multi-range print area.

Step 3: Open the Page Layout tab

At the top of Excel, click Page Layout. This is the tab that holds all the print and page setup controls, including margins, orientation, and the Print Area button you need.

Step 4: Click Print Area, then Set Print Area

In the Page Setup group, you will see a button labeled Print Area with a small printer icon. Click it. A short dropdown appears with two options: Set Print Area and Clear Print Area. Choose Set Print Area. A faint dashed border now surrounds your selection. That dashed line is Excel telling you the area is locked in.

Step 5: Save the workbook

Press Ctrl + S (Windows) or Cmd + S (Mac). This is the step people skip, then wonder why the setting vanishes the next morning. Print areas only persist if the file is saved.

Step 6: Preview before printing

Hit Ctrl + P (Windows) or Cmd + P (Mac) to open the print preview. You should see only the cells you selected, scaled to fit the page based on your current print settings. If it looks off, close preview, adjust orientation or scaling on the Page Layout tab, and preview again.

Keyboard Shortcuts for Setting Print Area

If you are setting print areas often, the mouse route gets old fast. Excel has hidden shortcuts that cut the process to two seconds.

Windows shortcut

Select your range, then press Alt. A row of letters appears on each ribbon tab. Press P for Page Layout, then R for Print Area, then S for Set. The full sequence is Alt + P, R, S. Press the keys in order, not at the same time, and they need to be pressed individually.

Mac shortcut

Mac Excel does not include a built-in keyboard shortcut for setting the print area. Workaround: open the File menu, then Print Area, then Set Print Area. Alternatively, assign a custom shortcut through System Preferences if you use this feature daily.

Custom shortcut on Windows

You can also add Set Print Area to the Quick Access Toolbar (QAT). Right-click the Set Print Area command in the ribbon, choose Add to Quick Access Toolbar, then press Alt + 1 (or whatever position it lands in on the QAT) to fire it instantly. This bypasses the three-key sequence entirely.

How to Set Multiple Print Areas on One Sheet

Excel allows multiple non-adjacent ranges in a single print area. Each range prints on its own page, which is useful when you want to print the summary section and a specific data table together while skipping everything in between.

Method 1: Select then set

Click the first range. Hold Ctrl (Windows) or Cmd (Mac) and click-drag to select the second range. Keep holding to add more. Once all ranges are highlighted, go to Page Layout > Print Area > Set Print Area. Excel stores all selected ranges as one multi-range print area.

Method 2: Add to existing print area

If you already have a print area set and want to add another range without losing the first one, select the new range, go to Page Layout > Print Area, and choose Add to Print Area. The option only appears in the dropdown when a print area already exists. This is the safest way to extend without accidentally overwriting your original selection.

What happens when you print

Each non-adjacent range prints on a separate page by default. If you want them combined onto one page, adjust scaling settings under Page Layout > Scale to Fit, or use Page Setup to force Fit to 1 page wide by 1 tall. Multiple ranges respect column widths and row heights, so layout will look identical to the on-screen view.

How to Clear or Change a Print Area

Plans change. Maybe you set a print area for last quarter's report and now you need the full sheet to print. Clearing or modifying is just as fast as setting one.

Clear the print area

Click anywhere in the worksheet. Go to Page Layout > Print Area > Clear Print Area. The dashed line vanishes. Save the file. Next time you print, Excel will use its default behavior, which prints everything from cell A1 down to the last cell containing data.

Change to a different range

Select the new range you want to print. Go to Page Layout > Print Area > Set Print Area. The old print area is replaced with the new one. There is no confirmation dialog, so double-check the selection before clicking Set.

Edit via Name Manager

For more precise control, open the Formulas tab and click Name Manager. You will see a named range called Print_Area. Click it, then click Edit. The Refers to field shows the exact cell reference. Edit it directly, for example change =Sheet1!$A$1:$D$20 to =Sheet1!$A$1:$E$50. Click OK. The print area updates immediately.

Reset across all sheets

To clear print areas on every sheet in the workbook at once, right-click any sheet tab, choose Select All Sheets, then go to Page Layout > Print Area > Clear Print Area. Remember to ungroup the sheets afterwards by clicking on any single tab, or your next edits will apply to every sheet.

Print Area and Page Breaks: How They Interact

Setting a print area tells Excel what to print. Page breaks tell Excel where to split that content across pages. Both work together, and confusion between the two is the most common reason printed output looks wrong.

Automatic page breaks

Excel inserts page breaks automatically based on the paper size, orientation, and margins. If your print area is wider than one page, Excel breaks the print across columns. If taller than one page, it breaks across rows. These automatic breaks show as faint dashed lines in Page Break Preview view.

Manual page breaks

If automatic breaks land in awkward spots, like halfway through a row of totals, insert manual breaks. Click the row below where you want the break, go to Page Layout > Breaks > Insert Page Break. Manual breaks show as solid lines. They override the automatic ones.

Page Break Preview view

Switch to View > Page Break Preview to see exactly how your print area splits across pages. The view shows blue boundaries you can drag to adjust where Excel divides the output. This is the fastest way to spot ugly breaks and fix them before printing.

Fit to one page

If your print area is slightly too wide or too tall to fit, instead of fighting page breaks use Page Layout > Scale to Fit. Set Width to 1 page and Height to automatic to force everything to one column-width. Or set both to 1 page to cram everything onto a single sheet, though text gets smaller as a result.

Repeating Headers on Every Printed Page

When a print area spans multiple pages, the column headers in row 1 only appear on page one by default. Page two starts with data rows and no labels, which is confusing for anyone reading the printout.

Fix it under Page Layout > Print Titles. In the dialog that opens, click in the Rows to repeat at top field, then click row 1 (or whichever row holds your headers) in the worksheet. Excel fills in the reference automatically. Click OK and save. Every printed page now starts with your headers, which makes long reports actually readable.

The same trick works for columns. Use Columns to repeat at left to lock the leftmost column (often a row label or category) onto every page. Especially useful for wide tables that span four or five pages horizontally.

Troubleshooting Common Print Area Problems

Print area set, file saved, but the printout still looks wrong. Here are the issues that come up most often and how to fix them.

Problem: Print area resets every time I open the file

Cause: the file is being saved as .xlsx but a macro or external process is rebuilding the sheet. Or, more commonly, the file was never actually saved. Re-set the area, press Ctrl + S, and close the file. Reopen to confirm.

Problem: Empty pages print after my data

Cause: Excel thinks the used range extends beyond your print area. This happens when cells outside the print area were once formatted (color, borders) and then deleted. Excel still treats them as used. Fix: select the empty rows below your data, right-click, and choose Delete, then save and try again. Or set a tighter print area to be explicit.

Problem: New rows do not appear in printout

Cause: print area is fixed and does not include the new rows. Fix: select the wider range and run Set Print Area again, which overwrites the old definition. Alternatively, edit the Print_Area named range in Name Manager.

Problem: Print area is grayed out

Cause: you are in cell-edit mode (the formula bar is active), or the workbook is protected. Press Esc to exit edit mode. For protected workbooks, unlock under Review > Unprotect Sheet first.

Problem: Printout is too small or too large

This is a scaling issue, not a print area issue. Go to Page Layout > Scale to Fit and adjust width and height. Or use the Page Setup dialog to set a custom scaling percentage. Print area defines what prints, scaling defines how big it appears on the page.

Problem: Print area covers right cells but cuts off columns

Cause: orientation. Wide ranges fit better on landscape than portrait. Switch under Page Layout > Orientation > Landscape. Also check column widths, since hidden or narrow columns inside the print area may still be there but invisible.

Print Area Best Practices

A few habits separate clean prints from chaotic ones. First, set the print area before you fill in data, not after, since it makes you think about output layout up front. Second, always preview before printing, even if you have set the area a hundred times, because scaling and orientation defaults can drift. Third, use Page Break Preview as your default view when designing reports, so you can see exactly where breaks land before you commit.

If you regularly produce the same report, save the workbook as a template with the print area, headers, and scaling already configured. Open the template, fill in the new month's data, and print. The setup pays off after the second use.

Final Thoughts on Setting Print Areas in Excel

Print areas look like a tiny feature, but they shape how every printed Excel document looks. Spend two minutes setting one before you print, save the workbook, and you save yourself the embarrassment of stray columns, half-cut rows, and ten pages when you meant three.

The basic flow stays the same across versions: select, Page Layout, Print Area, Set Print Area, save. The keyboard shortcut Alt + P, R, S on Windows turns the whole thing into a one-second action. Multi-range areas, repeating headers, and Page Break Preview turn rough output into reports that look intentional.

Whether you are printing a school grade report, a quarterly P&L, an inventory list, or a meeting agenda, the print area is the difference between guessing and knowing what will come out of the printer. Set it once, save the file, and trust the result. The next person who opens that workbook, including future you, will print exactly what was meant to print.