Excel Print Area Shortcut: Set and Clear It Quickly

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select the cells you want to print, then press Alt+P, S, P in sequence to set them as the print area. To remove the print-area setting, press Alt+P, S, C. These are ribbon KeyTip sequences, not keys to hold down together; if a KeyTip differs in your Excel build or language, follow the letters shown on screen.

What the print area shortcut does

A print area tells Excel which cells from a worksheet to include when you print. Setting one does not delete or hide the other cells: it changes what Excel considers printable for that sheet. You can still view, edit, calculate with, and copy cells outside the area as usual.

The Windows sequence uses the ribbon: Alt+P opens Page Layout, S opens the Print Area menu, and P chooses Set Print Area in the standard English interface. The matching clear sequence ends with C. The letters are pressed one after another after Alt activates ribbon KeyTips. If you press a wrong letter, press Esc to dismiss the KeyTips and begin again.

There is no single Ctrl-key shortcut such as Ctrl+P that sets a print area. Ctrl+P opens the print screen; it is for reviewing and printing, not for defining a persistent range. That distinction matters: a print area controls the worksheet’s print scope, whereas the print screen lets you preview output and choose print options.

Set a print area step by step

For a basic print area, first select the cells you want on paper. For example, if a monthly report occupies A1:F28, select A1:F28 and use the shortcut. You can also use the ribbon path Page Layout > Print Area > Set Print Area.

  1. Select the worksheet containing the report. A print area is set for a worksheet, so check that you are on the right sheet.
  2. Select the range to print, such as A1:F28. You can drag across the cells, or click the Name Box to the left of the formula bar, type A1:F28, and press Enter.
  3. Press Alt, then P, then S, then P, releasing each key before the next. Alternatively, use the Page Layout ribbon menu.
  4. Press Ctrl+P to open Print and inspect the preview. Confirm the expected cells appear before sending the job to a printer or PDF.

Setting a new print area normally replaces the current area on that worksheet. If you already defined one and want to include another range as well, use Page Layout > Print Area > Add to Print Area, rather than Set Print Area. Multiple ranges can be nonadjacent, but Excel may place those areas on separate printed pages. Preview them because the result may not resemble a single continuous table.

Clear or change an existing print area

To remove the saved print area, use Alt+P, S, C, or choose Page Layout > Print Area > Clear Print Area. Clearing it does not erase worksheet data or formatting. It removes the range restriction, so Excel can print the rest of the used worksheet according to the other print settings.

To change the range, the simplest approach is usually to select the new cells and choose Set Print Area. For example, if the report grows from A1:F28 to A1:G32, select A1:G32 and set it again. Choose Add to Print Area only when the extra cells should remain a separate additional print region. If you are unsure which ranges are saved, open Print Preview after making the change.

A print area is saved with the workbook. If you share the file, another person opening it in a compatible desktop version of Excel can inherit that print setup. It applies to the worksheet where it was created, not automatically to every sheet in the workbook. Each sheet can have its own print area, or no print area.

Print area versus printing a selection

A print area is useful when you expect to print the same section repeatedly. It remains part of the worksheet’s print setup until you change or clear it. Printing a selection is better for a one-off job when you do not want to change the saved setup.

For a one-time print, select the cells, press Ctrl+P, and use the print settings to choose Print Selection if that option is available for the current selection. Check the preview: this choice prints the selected cells for that print operation rather than establishing a lasting print area. If your goal is to make the same report print correctly next month, set the print area instead.

Neither option guarantees that the content will fit neatly on one page. The selected range still has to be laid out using paper size, orientation, margins, scaling, and page breaks. A wide range might span multiple pages even though its print area is correct.

Fit the print area onto pages

After setting the cells, use Ctrl+P to check the preview. If a report spills onto too many pages, inspect the scaling controls in the Print screen. In the Page Layout tab, the Scale to Fit settings let you adjust width and height; for example, setting width to one page can keep columns together while allowing rows to continue onto additional pages. Scaling a large table to one page in both directions can make its text too small to read, so judge the preview rather than choosing a setting automatically.

For further layout changes, use Page Layout > Orientation to switch between Portrait and Landscape, or Page Layout > Margins to choose a margin preset. You can view or adjust page breaks from View > Page Break Preview. These settings complement the print area; they do not define which cells belong to it.

If the first row contains column headings that should repeat on every printed page, use Page Layout > Print Titles and set rows to repeat at the top. Print Titles and Print Area solve different problems: one repeats headings, while the other limits the worksheet cells included in printing.

Windows, Mac, and Excel for the web

The Alt+P, S, P sequence is for Excel on Windows using the standard English ribbon. KeyTips can vary with Excel updates, ribbon configuration, or interface language. Press Alt and look at the letters displayed over the tabs and commands if the sequence does not match what you see.

On a Mac, do not assume the Windows Alt KeyTip sequence works. Use the Page Layout tab and select Print Area > Set Print Area; the exact ribbon presentation can vary by Mac version. Command+P opens the Mac print dialog, just as Ctrl+P opens Print on Windows, but neither command sets a print area.

Excel for the web does not provide the same full desktop print-area workflow. If you need to define or change a workbook’s print area, open it in the Excel desktop app and use the Page Layout controls. The web version may still let you print or view a workbook, but its print controls should not be treated as a replacement for the desktop print-area setting.

Common problems and how to fix them

  • The shortcut opens the wrong command: KeyTip letters may differ by version or language. Press Esc, activate the ribbon with Alt, and follow the visible KeyTips, or use the Page Layout menu directly.
  • Extra cells print: Check whether the print area includes them, whether another range was added, and whether the preview is showing the intended worksheet. Clear the print area and set the intended range again if needed.
  • Only part of the report appears: Confirm that the range includes all required rows and columns. A print area can be correct but still split across pages; inspect scaling, orientation, and page breaks.
  • The worksheet prints more than expected after clearing: Clear Print Area removes the limit; it does not mean print nothing. Excel can then print the worksheet’s used cells, subject to its other settings.
  • The printout is too small: Avoid forcing both width and height to one page for a large report. Let it span multiple pages, use landscape orientation, or adjust margins so the content remains readable.

Also remember that a print area is not the same as hiding rows or columns. Hidden content is controlled separately, and changing a print area does not conceal sensitive data from someone who can open the workbook. If you need to protect information, use appropriate workbook permissions or remove the data rather than relying on print settings.

Frequently Asked Questions

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

In Excel for Microsoft 365 on Windows with the standard English ribbon, select the cells and press Alt, P, S, P in sequence. The ribbon route is Page Layout > Print Area > Set Print Area.

How do I clear the print area in Excel?

Use Alt, P, S, C on the standard English Windows ribbon, or choose Page Layout > Print Area > Clear Print Area. This removes the print-range restriction without deleting cells.

Does Ctrl+P set the print area?

No. Ctrl+P opens the Print screen on Windows so you can preview and print. To define a print area, select the cells and use the Page Layout Print Area command.

Can I set more than one print area on a worksheet?

Yes. Select another range and use Add to Print Area. Separate areas can print as separate regions or pages, so inspect Print Preview to confirm the layout is useful.

Does the print area apply to the whole workbook?

No. A print area is associated with a particular worksheet. Set or clear it separately on each sheet whose printed range you want to control.

Why does Excel still print my report on several pages?

The print area sets which cells are included, not how they fit on paper. Use Print Preview, scaling, orientation, margins, or page breaks to adjust the page layout.

Related

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.