Excel Print Area Shortcut: Set, Add, and Clear It

In Excel for Microsoft 365 on Windows, select the cells you want to print, then press Alt, P, R, S in sequence to set them as the print area. It is a series of ribbon KeyTips, not a single key combination; to clear the print area, use Alt, P, R, C.

The Windows shortcut and what each key does

Excel does not assign a dedicated one-step shortcut such as Ctrl+P to set a print area. Instead, its ribbon KeyTips let you reach the command from the keyboard. With the English-language ribbon, press and release each key in this order: Alt, P, R, S. Do not hold all four keys down together. First select the cells, because Excel uses the current selection when you choose Set Print Area.

Select the range to include, such as A1:F28.
Press and release Alt. Excel displays KeyTips over ribbon tabs and commands.
Press P to open the Page Layout tab’s KeyTips.
Press R to open the Print Area menu.
Press S to choose Set Print Area.

KeyTips can differ if the ribbon language or customization differs from the standard English setup. If the letters shown on your screen do not match, follow the displayed KeyTips instead of relying on the sequence. The command is also available through the ribbon: Page Layout > Print Area > Set Print Area.

What a print area does

A print area is a saved instruction that limits which cells on a worksheet Excel includes when printing. If you set A1:F28 as the print area, Excel prints that range rather than automatically including other used cells elsewhere on the sheet. The cells outside it remain in the worksheet; setting a print area neither deletes data nor hides it on screen.

Print areas are worksheet-specific. A workbook can therefore have one print area on a summary sheet and another on a detail sheet. The setting is stored with the workbook, so it normally remains in place when you save and reopen the file. This is different from choosing a range just for one print job: a saved print area continues to affect later printing until you change or clear it.

For example, imagine a worksheet with a monthly report in A1:F28 and notes in H1:J12. Setting A1:F28 as the print area keeps the notes out of the printed report without moving or deleting them. If the report grows next month, however, you will need to update the print area or the added rows may not print.

Set a print area from the ribbon

The ribbon route is useful if you prefer to see the command or if KeyTips are unfamiliar. Select the cells first, then choose Page Layout > Print Area > Set Print Area. Excel outlines the chosen range on the worksheet. You can then open print preview to check what will appear on paper or in a PDF.

Take care to select the entire intended block, including headings, footnotes, and any repeated labels you want readers to see. A range that starts at row 2 will not include a title in row 1. Likewise, selecting a block that is too wide can make Excel shrink the content to fit the page, potentially making text difficult to read.

You can set a print area that is only part of a worksheet, but do not confuse it with selecting cells and copying them. The print-area command changes the worksheet’s print settings; it does not create a new sheet or alter the cell contents. If you later select another range and choose Set Print Area, the new selection replaces the existing print area.

Add to, replace, or clear an existing area

To include more cells while retaining an existing print area, use Page Layout > Print Area > Add to Print Area where that command is available. This is different from Set Print Area, which uses the current selection as the new print area. When adding a separate block, Excel can print the areas as separate page regions; check the resulting page layout because disconnected blocks may not fit together as one continuous table.

To discard the saved setting, use Page Layout > Print Area > Clear Print Area. The Windows KeyTip sequence is Alt, P, R, C. Clearing the print area does not erase any worksheet content. It returns the sheet to its normal printing behavior, which generally includes the used cells that Excel identifies for that sheet.

If you are unsure whether a range is already defined, select a cell on the worksheet and open the Print Area menu. You can also inspect the result in print preview. When working with multiple sheets, confirm that you are on the intended sheet before setting or clearing an area: print areas belong to individual worksheets, and applying a command to one sheet does not automatically update every sheet in the workbook.

Check the result in print preview

Setting a print area decides which cells are eligible to print; it does not guarantee a particular page count or readable scaling. After setting it, press Ctrl+P on Windows to open print preview. Check both the content and the page breaks. If the preview shows an unexpected blank page, a split table, or tiny text, adjust the print layout before printing.

Confirm that the first and last intended rows and columns appear.
Look for cut-off headings, totals, or notes at the edge of the page.
Check whether the range spans more pages than expected.
Verify the selected printer, paper size, orientation, and margins.

Print preview is especially important when a range is wider than a portrait page. Changing the orientation to landscape or choosing a suitable paper size may improve the result. These settings are separate from the print area: they change how the chosen cells are arranged on the page, not which cells are included.

Print area versus scaling and page breaks

These three print controls solve different problems. A print area chooses the cells to print. Scaling controls how those cells are resized to fit a page or a specified number of pages. Page breaks determine where the content divides between printed pages. Changing one does not necessarily fix the others.

For example, if A1:F28 is correctly selected but the six columns are too wide, set the page orientation to landscape or adjust scaling rather than expanding the print area. In Excel’s Page Layout tab, the Scale to Fit controls can be used to fit a worksheet to a desired width or number of pages. Be cautious with fitting an entire long report onto one page: Excel may shrink it so much that the text becomes unreadable.

If a page break cuts through a logical section, review the page breaks in Page Break Preview or adjust the layout settings. The print area can remain unchanged while you improve where the pages divide. Preview again after any adjustment, since printer and paper settings can affect the final pagination.

Mac and Excel for the web

The Windows sequence Alt, P, R, S is for Excel on Windows and should not be treated as a Mac shortcut. In Excel for Mac, select the cells and use the Page Layout ribbon’s Print Area > Set Print Area command. Ribbon labels and layout can vary slightly by release, so use the visible command if the menu is arranged differently. For printing on a Mac, the common print-dialog shortcut is Command+P; it does not set a print area.

Excel for the web does not provide the same desktop command for saving a persistent print area. For a one-time print, select the relevant cells and use File > Print, then choose the current selection in the print settings if that option is shown. This affects that print job rather than creating the same saved worksheet print-area setting as Excel desktop. If you need a reusable print area, open the workbook in the Windows or Mac desktop application and set it there.

Common problems and how to fix them

The shortcut seems to do nothing. Make sure you press and release the keys one at a time, beginning with Alt, and look for the KeyTips that appear. If the sequence does not match your ribbon language or customized layout, use the displayed KeyTips or click the Print Area command on the Page Layout tab.

Some rows or columns are missing. The saved range may be smaller than the current report. Select the expanded range and choose Set Print Area to replace it, or use Add to Print Area if you intend to retain the existing range. Then check preview before printing.

Old cells still print after changing the range. Confirm that the change was made on the correct worksheet and that the print settings are not set to print the entire workbook or a different selection. Clear the old area and set the intended range again if needed. Also check preview to see which sheet and pages Excel is preparing.

The range prints on too many pages or becomes unreadable. The print area only sets the boundary. Check paper size, orientation, margins, scaling, and page breaks. Avoid forcing a large worksheet onto one page if that makes the type too small for comfortable reading.

A blank page appears. Inspect the print area and page breaks, and check for stray content or formatting far beyond the visible table. Excel may treat distant used cells as part of the sheet’s printable extent when no appropriately narrow print area is set. A correct print area, followed by a preview check, often helps identify what is creating the extra page.

When a print area is useful

Use a saved print area when the same portion of a worksheet is printed repeatedly, such as a dashboard, a standard invoice layout, or a report whose supporting calculations sit elsewhere on the sheet. It keeps the intended output consistent across print sessions and avoids repeatedly selecting the range. It is also useful when a worksheet contains reference tables or working notes that should stay available to spreadsheet users but not appear in the regular printout.

For one-off printing, a temporary selection may be simpler than changing a saved setting. If the sheet’s print area must be different for different audiences, consider separate report worksheets or save a copy with the alternate print setup. That avoids a later user assuming that the existing saved range includes all relevant data.

Frequently Asked Questions

Is there a single keyboard shortcut to set the Excel print area?
No dedicated single-key combination is assigned to the command in Excel for Windows. Use the sequential KeyTips Alt, P, R, S after selecting the cells.

What is the shortcut to clear the print area in Excel?
On the standard English Windows ribbon, press Alt, P, R, C in sequence. You can also choose Page Layout > Print Area > Clear Print Area.

Does Ctrl+P set the print area?
No. Ctrl+P opens print preview and printing options in Excel for Windows. It does not define or change the worksheet’s saved print area.

Will a print area change what is visible in the worksheet?
No. It affects what Excel prints, not what cells appear on screen or what data is stored in the worksheet.

Can I set a print area in Excel for the web?
The web version does not offer the same persistent desktop print-area command. You can print a selected range for an individual job when the current-selection option is available, or open the workbook in desktop Excel to save a print area.

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.