Adjust Print Area in Excel: Set, Change, and Clear It

To adjust a print area in Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. To change an existing area, set a new one or add another range; to remove it, choose Page Layout > Print Area > Clear Print Area.

What an Excel print area does

A print area is the part of a worksheet Excel includes when you print that sheet. It is useful when a worksheet contains reference notes, calculations, or extra columns that should remain in the file but not appear on paper. Setting a print area does not delete, hide, or protect cells. It changes the worksheet’s print output, not what you see or edit in the grid.

Print areas belong to individual worksheets. A workbook can therefore have a different print area on each sheet, and a sheet without one generally prints its used content according to its print settings. Excel saves a defined print area with the workbook, so it is available again when the file is reopened.

A print area is not the same thing as a print selection. The print area is a saved worksheet setting. A selection is the range you choose for a particular print job. If you only need a one-time printout of a few cells, printing the selection may be more convenient than changing a saved setting.

Set a print area for the first time

First select the cells you want included. For example, if a monthly report occupies A1:F28 and notes in columns H:J should not print, select A1:F28. Then use the ribbon command to set the area. Check the result in Print Preview before sending it to a printer.

Select the worksheet tab that contains the information.
Drag across the cells to include, or click a cell and use the keyboard to extend the selection. To select a specific range, click the Name Box to the left of the formula bar, type a reference such as A1:F28, and press Enter.
Choose Page Layout > Print Area > Set Print Area.
Choose File > Print to inspect the preview, page count, orientation, and margins.

When a print area is set, Excel outlines it on the worksheet in page-break view and uses it when printing the sheet. The exact on-screen indication can vary with the view and version, so Print Preview is the most useful check. If the preview still shows unwanted cells, confirm that you are printing the intended sheet and that you did not choose a print-selection option that overrides the saved area.

Change, expand, or add to an existing area

To replace an existing print area with a different block, select the new range and choose Page Layout > Print Area > Set Print Area again. This sets the selected cells as the area for that worksheet rather than simply enlarging the old boundary. For instance, selecting A1:G32 after previously setting A1:F28 includes the extra column and rows in the new area.

To keep the current area and include another range, select the additional cells and choose Page Layout > Print Area > Add Print Area. This is useful for printing two separated sections from one sheet, such as a summary at the top and an assumptions table farther down. Nonadjacent areas may print as separate blocks or pages; inspect the preview because the final layout depends on page size, scaling, and page breaks. Adding an area does not make the spaces between the ranges part of the print area.

If you want one continuous printed table, it is often clearer to select the full rectangular range and set it as one area. That includes any blank rows or columns inside the rectangle. If a range is no longer needed, resetting the print area to the range you want is usually simpler than trying to alter its boundary cell by cell.

Clear a print area without changing worksheet data

To remove a saved print area from the current sheet, choose Page Layout > Print Area > Clear Print Area. Excel then returns to printing the sheet according to its other print settings. Clearing the area does not erase cells, formatting, formulas, or manual page breaks. It also does not clear print areas on other worksheets, so repeat the command on each sheet that needs to be reset.

Clearing is helpful when a workbook prints only a small section even though you expect the whole report. It is also a sensible first step when you inherit a workbook and cannot tell why some rows or columns are missing from the output. After clearing, open Print Preview to see what Excel now considers printable, then set a new area if needed.

Fit the print area onto pages

A correctly defined print area can still produce an awkward printout. The range might span several pages horizontally, split a table at an inconvenient row, or shrink until its text is difficult to read. Adjust scaling after setting the area, and verify the result in preview rather than assuming that one setting will suit every worksheet.

Fit the width: On the Page Layout tab, find the Scale to Fit group and set Width to 1 page. Leaving Height as Automatic lets a long report continue onto additional pages while keeping its columns together.
Fit the whole range on one page: Set both Width and Height to 1 page. This can make a large table very small, so check whether the text remains readable.
Use a wider page: Choose Page Layout > Orientation > Landscape for a report with many columns. Use Portrait when the page is taller than it is wide.
Change paper size or margins: Use Page Layout > Size or Page Layout > Margins when the printer and document requirements allow it.

There is a trade-off between fitting content and keeping it legible. If one-page scaling makes a report too small, consider printing it across multiple pages, reducing unnecessary columns, or adjusting margins. Forcing both dimensions to one page is not automatically the best choice for a large spreadsheet.

Control page breaks and repeated headings

Print areas define what can print, while page breaks determine where that content divides between pages. To inspect or adjust breaks, choose View > Page Break Preview. You can drag a break line to change a division, or use Page Layout > Breaks to insert, remove, or reset page breaks. A manual break can help keep a section together, but it may interact with scaling, so check the preview after changing either setting.

If a table runs across multiple printed pages, repeating its header row is often more useful than squeezing everything onto one page. Choose Page Layout > Print Titles, then use the Rows to repeat at top field on the Sheet tab of the Page Setup dialog. For example, enter $1:$1 to repeat row 1 on each printed page. You can also specify columns to repeat at the left. Print titles are a separate setting from the print area: one controls repeated labels, while the other controls which worksheet cells are included.

Print the saved area or just a selection

When you choose File > Print, review the print-settings menu as well as the preview. The normal worksheet-printing option uses the sheet’s print settings, including its defined print area. If you choose Print Selection, Excel prints the cells selected for that job instead; that is useful for a quick, temporary output but does not replace the saved print area.

For a workbook with several sheets, check whether the print setting is for the active sheet, selected sheets, or the entire workbook. A print area on one sheet does not automatically set areas on the others. Selecting several sheet tabs can also make changes apply to multiple grouped sheets, so check the selected tabs before editing page settings. Click an ungrouped sheet tab when you want to work on just one worksheet.

Common problems and practical checks

Excel prints extra cells: Check whether the print area was cleared or reset, and make sure the unwanted cells are not inside the selected rectangle. Also confirm that the print job is not set to print the selection or the entire workbook.
Some expected cells are missing: Check for a print area that stops too early, hidden rows or columns, and the selected print range. Reset the area to include the missing cells, then review the preview.
The output is split across too many pages: Look at orientation, paper size, margins, scaling, and page breaks. Setting the width to one page can keep columns together without compressing the report vertically.
The text is tiny: Avoid fitting both width and height to one page for a large range. Let the height span multiple pages or narrow the print area to content that belongs together.
A change appears on several sheets: Check whether worksheet tabs are grouped. Ungroup them before setting or clearing a print area on a single sheet.

A useful final check is to compare the selected range with the preview page by page. Look for cut-off headings, blank pages, missing totals, and columns that are too narrow. Print Preview shows how Excel will lay out the job, but printer-specific margins and paper options can still affect the physical result.

Excel for Mac and Excel for the web

In Excel for Mac, the print-area commands are also on the Page Layout tab, though the ribbon arrangement can differ slightly by release. Look for Print Area and its set, add, and clear commands, then review the output through the print dialog. Mac keyboard shortcuts differ from Windows in many Excel tasks; the steps above use ribbon commands rather than relying on a Windows-only shortcut.

Excel for the web has a more limited page-layout feature set than the desktop application. For reliable management of a workbook’s saved print area, open it in the desktop version of Excel and use the Page Layout commands. In the web version, use its available print workflow and preview for a one-time print job, but do not assume every desktop print-area setting can be created or edited there.

Frequently Asked Questions

How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Use File > Print to check the preview before printing.

How do I change the print area in Excel?
Select the replacement range and choose Page Layout > Print Area > Set Print Area. To add a separate block without replacing the existing one, select it and choose Add Print Area.

How do I remove a print area?
On the worksheet you want to change, choose Page Layout > Print Area > Clear Print Area. Repeat on other sheets if they have their own saved areas.

Why does Excel print only part of my worksheet?
A saved print area may limit the output. Check the preview and either set a larger area or choose Clear Print Area. Also check whether the print job is set to print only a selection.

Can I print two separate ranges on one worksheet?
Yes. Select the second range and choose Page Layout > Print Area > Add Print Area. Because separate blocks may print separately, inspect the preview to confirm the page layout is suitable.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.