Excel Online Set Print Area: What Works and What Doesn’t

How-to basics · Updated November 21, 2026

Excel for the web cannot create or save a worksheet print area the way desktop Excel can. To print just part of a sheet online, select the cells and choose File > Print; to save a repeatable print area in the workbook, open it in desktop Excel and use Page Layout > Print Area > Set Print Area.

Can Excel for the web set a saved print area?

A print area is a range of worksheet cells that Excel is instructed to print instead of the whole sheet. In desktop Excel, you can define that range, save the workbook, and have the setting remain associated with the worksheet. Excel for the web does not provide the command to create or clear that saved print area. This is the key difference behind the common question about setting a print area in Excel Online.

You can still control what gets printed from the browser. Selecting a range and printing it is useful for a one-time handout or a quick copy of a table. It is not the same as creating a print area: the selection is not a persistent page-setup rule, and it does not automatically update as a saved print area if the table later grows.

It helps to separate three things that are often confused:

  • Print area: A saved worksheet setting that defines which cells desktop Excel should print.
  • Current selection: Cells you select for a particular print job, where the browser print workflow offers a selection option.
  • Page layout: Settings such as paper size, orientation, margins, and scaling that affect how printed content fits on paper.

Changing orientation or scaling can make a sheet fit better, but it does not by itself restrict printing to a particular range. Likewise, selecting cells for a single print job does not establish a saved print area.

Print a range without saving a print area

For a one-time printout in Excel for the web, select the cells you need before opening the print screen. A practical workflow is:

  1. Open the workbook in Excel for the web and go to the worksheet you want to print.
  2. Select the range. Drag across the cells, or select the first cell and extend the selection with the keyboard.
  3. Choose File > Print > Print.
  4. Review the print settings and preview. If the interface offers a choice such as Print Selection or Current selection, choose it rather than printing the active sheet.
  5. Check the preview for clipped columns, unexpected blank pages, and page breaks, then continue to the printer or save-to-PDF option offered by your device.

The exact controls can vary with the current Excel for the web interface, browser, and printer. If the preview includes the whole sheet even though you selected cells, return to the worksheet and confirm that the intended range is selected. Reopen File > Print and look for a selection-specific setting. If there is no such option in your interface, use desktop Excel to set the print area, or copy the required cells to a temporary worksheet and print that sheet.

For example, imagine a worksheet with a 12-column sales table, a chart to its right, and notes beneath it. Selecting only the table can keep the chart and notes out of a one-off printout if the print workflow honors the selection. If the table is something colleagues will print every week, a saved print area in desktop Excel is more reliable than asking each person to make the same selection.

Create a permanent print area in desktop Excel

To store a print area in the workbook, open it in the desktop version of Excel for Microsoft 365 on Windows. Select the cells to print, then choose Page Layout > Print Area > Set Print Area. Save the workbook. In Excel for Mac, the equivalent command is also on the Page Layout tab under Print Area; the ribbon layout may look a little different.

To check the result, use File > Print and inspect the preview. Excel should show the defined range rather than treating every used cell on the worksheet as part of the intended printout. If you need to replace the range, select the new cells and use Set Print Area again. To remove the saved restriction and return to printing the worksheet normally, choose Page Layout > Print Area > Clear Print Area.

A print area belongs to a worksheet, not to the entire workbook as one shared range. If several sheets need specific print ranges, configure each sheet separately. You can also define more than one range on a sheet by selecting additional nonadjacent cells while adding to the print area, but separate blocks may print as separate areas or pages. Preview the result carefully: a layout that looks tidy on screen can become awkward when the blocks are printed apart.

Print-area settings are useful when the same report is printed repeatedly, but they do not lock the worksheet or prevent someone from changing the cells. They also do not guarantee that the report will fit on one page. The saved range controls what is included; page setup controls how that content is arranged on paper.

Make the printed pages fit and read well

Once the range is right, use print preview to assess its shape. A wide table may be split across multiple pages even when the print area is correct. In desktop Excel, the Page Layout tools let you adjust paper orientation, paper size, margins, and scaling. The settings available through Excel for the web can be more limited, so check the browser print preview and use the desktop app when you need more control.

  • Try landscape orientation when a table has many columns. It gives the content more horizontal space, though it may leave more unused space vertically.
  • Check paper size and printer settings. A workbook laid out for one paper size may paginate differently if the printer is set to another.
  • Use scaling with care. Fit-to-page options can compress a wide report onto one sheet, but the text may become too small to read. A two-page-wide printout can be more useful than forcing everything onto one page.
  • Review page breaks. A break through a heading or a key group of columns can make the report hard to follow. Adjust the range or page setup rather than assuming the print area itself is wrong.
  • Look at print preview after each change. The worksheet grid on screen is not a dependable guide to page boundaries.

For a recurring report, consider whether repeating a header row on each printed page would help. This is a separate page-setup feature in desktop Excel, not a print-area setting. A print area can specify the data to include while repeating rows make multi-page output easier to understand. If your workbook is intended for browser-only use, exporting or opening it in desktop Excel may be necessary for page-layout controls that are not available online.

What if the workbook already has a print area?

A workbook created or edited in desktop Excel may already contain a print area when you open it online. The web app may retain workbook settings it does not let you create or edit. When printing, use the preview to confirm what will actually appear; do not assume that the visible worksheet selection or the sheet’s used range tells you what the saved print settings will produce.

If the existing area is wrong, the dependable fix is to open the workbook in desktop Excel, go to the affected sheet, and clear or reset the print area. If you cannot use the desktop app, you can try printing a selected range or make a separate copy of the needed cells on a temporary sheet. Those workarounds may be adequate for an immediate print job, but they do not repair the original saved print-area setting.

When coworkers share a workbook, tell them whether you changed the saved print setup or only printed a selection. That distinction prevents confusion when someone else opens the sheet and sees a different print preview. If you save a changed workbook, verify that the intended print area remains in place by reopening the file in desktop Excel and checking its preview.

Common printing problems and fixes

The whole sheet prints instead of the selected cells. The selection may not have been made before entering the print workflow, or the web interface may not offer selection-only printing. Return to the sheet, select the range again, and look for a selection option in the print settings. If it is unavailable, use desktop Excel or a temporary sheet containing only the material you need.

Extra blank pages appear. Blank pages can result from page breaks, formatting or content far beyond the visible table, or the print scaling and paper settings. Review the print preview, check the extent of the content, and adjust the print area in desktop Excel when the saved range includes unwanted cells. A large used range does not necessarily mean that every cell contains visible data.

Columns are cut off. The range may be wider than the printable page, or the printer may use different margins or paper settings from those expected. Try landscape orientation, a suitable paper size, or a modest scaling adjustment. Avoid shrinking text until it is unreadable just to force a one-page result.

The online preview and printed page do not match. Browser, printer-driver, and paper settings can affect the final output. Check both the Excel preview and the print dialog that appears after it, especially its paper size, orientation, and scale options. If precise pagination matters, use desktop Excel’s print preview and save a PDF for a stable visual check before sending the job to a printer.

Alternatives when you must stay in the browser

If installing or opening desktop Excel is not an option, choose a workaround based on whether the task is temporary or recurring. For a single printout, select the needed cells and use the selection option if your web print workflow provides it. For a small, self-contained report, copy the relevant data to a new worksheet, remove unrelated content, and print that sheet. Keep in mind that this creates a copy: later edits to the original table will not automatically update the copied report.

Another option is to download or open the workbook in the desktop app if your Microsoft 365 account and device provide that capability. There, you can set the print area, adjust page setup, and save the settings in the workbook. If the file will be distributed to people who only have browser access, include clear instructions or provide a PDF when a fixed page layout matters. A PDF preserves the prepared pages for viewing and printing, although it is no longer an editable worksheet in the same way as the Excel file.

Choose the workaround according to the job: selected cells are quick for a one-time print, a saved print area suits a recurring workbook report, and a PDF is useful when recipients need to see a consistent finished page. These options solve different problems; none makes the Excel for the web print-area command appear.

Frequently Asked Questions

Where is Set Print Area in Excel Online?
Excel for the web does not include the desktop Excel command for creating a saved print area. Open the workbook in desktop Excel and use Page Layout > Print Area > Set Print Area.

Can I print only selected cells in Excel for the web?
Select the range before choosing File > Print > Print, then choose a selection-only option if it appears. If your print screen does not offer one, use desktop Excel or copy the range to a separate sheet.

Does a print area save with the workbook?
Yes. A print area set in desktop Excel is a worksheet setting saved with the workbook. It is different from selecting cells temporarily for a single print job.

How do I remove a print area?
In desktop Excel, open the relevant sheet and choose Page Layout > Print Area > Clear Print Area. Excel for the web does not provide that saved-setting command.

Why does my print area still use several pages?
A print area limits which cells are included; it does not guarantee a one-page result. Page size, orientation, margins, scaling, and the dimensions of the range determine how many printed pages are needed.

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.