To change the 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 replace an existing area, set a new one this way; to remove it entirely, choose Page Layout > Print Area > Clear Print Area.
What a print area does
A print area is the part of a worksheet Excel includes when you print that sheet. It lets you keep supporting calculations, notes, or unused template rows on the worksheet without including them on paper or in a PDF. The setting belongs to the worksheet, not to the entire workbook, so different sheets can have different print areas.
Setting a print area does not delete or hide cells outside it. Those cells remain available for editing and calculations; they are simply excluded from printing that worksheet. The print area also does not decide how the selected cells fit on the page. Margins, orientation, paper size, scaling, and page breaks affect the final layout separately.
Excel stores a print area as a worksheet-level setting. If you share the workbook, the saved area can affect how another person prints the sheet too. It is therefore worth checking the print preview before distributing a workbook that has been prepared for printing.
Set or replace the print area step by step
- Open the worksheet you want to print. If the workbook has several sheets, make sure you are on the correct one.
- Select the cells to include. Drag across a rectangular block, or click the first cell and Shift-click the last cell. You can also enter a range such as A1:F35 in the Name Box to select it.
- On the ribbon, choose Page Layout > Print Area > Set Print Area.
- Open File > Print to inspect the preview. Check that the intended cells appear and that the page count and layout make sense.
Setting a new print area replaces the previous print area for that worksheet. For example, if the current area is A1:H60 and you select A1:F35 before choosing Set Print Area, Excel changes the area to the new selection. It does not add the new range to the old one.
If the ribbon is collapsed or the window is narrow, the Page Layout commands may appear in a compact layout. Expand the ribbon or look for the Print Area command on the Page Layout tab. The command is not the same as choosing a range in the print screen: one saves the worksheet’s print setting, while the other can print a selection for a single print job.
Add another range or print nonadjacent cells
You can include more than one range on a worksheet. Select the first range, then hold Ctrl while selecting additional ranges on Windows. Choose Page Layout > Print Area > Set Print Area to define the selected areas together. To add a range to a print area that already exists, select the additional cells and choose Page Layout > Print Area > Add Print Area.
Excel treats separated print areas as distinct areas rather than joining the cells between them. Each area is printed separately, so a nonadjacent selection can produce extra pages or a layout that differs from a single continuous table. For instance, selecting A1:D20 and G1:J20 does not include columns E and F. Check the preview to see how Excel has divided the output.
On a Mac, use Command-click to add nonadjacent selections instead of Ctrl-click. The ribbon command is also on the Page Layout tab; names or placement can vary slightly with the Excel for Mac release. If you are selecting one continuous rectangle, the usual click-and-drag method avoids any ambiguity.
Nonadjacent areas are useful when a worksheet contains two small summary tables separated by working data. They are less suitable when readers need to compare rows across the gap, or when the separate sections should appear side by side on one page. In those cases, consider copying the report-ready cells to a separate sheet and arranging them together.
Clear a print area and start over
To remove the saved print area, go to Page Layout > Print Area > Clear Print Area. Excel will then use the worksheet’s printable content when you print, subject to the other page settings. Clearing the area does not erase cells or formatting.
Clear the setting when you inherit a workbook and cannot explain why most of a sheet is missing from the preview, or when you want Excel to include a newly expanded report. Then select the intended cells and set the area again if you need a specific boundary. If the sheet still prints unexpectedly, also check for hidden rows or columns, filters, manual page breaks, and scaling settings.
To check whether a print area is responsible, use File > Print and inspect the preview. If only a small region appears, clear the print area and preview again. If the result changes, the saved area was affecting the output; if not, investigate the other print settings.
Check page breaks, orientation, and scaling
A correct print area can still look poor on paper if it spans too many pages or shrinks to unreadable text. Before changing the area to solve a layout problem, check the settings that control page layout. On the Page Layout tab, review Orientation, Size, Margins, and the Scale to Fit options. Landscape orientation may suit a wide table, while portrait can work better for a long, narrow list.
To fit a wide report across one page, set Width to 1 page in the Scale to Fit group. You can leave Height set to Automatic so a long report continues onto additional pages. Fitting both width and height to one page can make a large worksheet extremely small; use that option only when the result remains readable.
For more detailed control, choose Page Layout > Page Setup dialog launcher and review the scaling and page settings. Page Break Preview, available from the View tab, shows where Excel divides the worksheet into printed pages. You can adjust page breaks there, but a page break changes pagination rather than the cells included in the print area.
Use File > Print to judge the actual output. The preview reflects paper size, orientation, margins, scaling, and page breaks together. A change that appears sensible in the worksheet grid may still leave a title stranded on one page or a table split in an awkward place.
Repeat headings on every printed page
A print area defines which cells are included, but it does not automatically repeat a header row on later pages. For a multi-page report, choose Page Layout > Print Titles. In the Page Setup dialog, use Rows to repeat at top to specify the heading row, such as $1:$1. You can also set columns to repeat on the left when a wide report spans multiple pages.
Repeating titles is different from adding the same row repeatedly to the print area. The title setting tells Excel to print the chosen heading rows or columns on each relevant page. It is especially useful for long lists: without repeated column headings, readers may not know what the values on later pages represent.
After setting titles, inspect every page in File > Print. A heading row takes up space, so it can affect where body rows break across pages. If Print Titles is unavailable or cannot be edited, check whether you are editing a cell or in a special view, and use the desktop application if the workbook is open in Excel for the web.
Print a selection instead of saving a print area
If you only need a one-time printout of a range, you may not need to change the worksheet’s saved print area. Select the cells, choose File > Print, and use the print settings to print the selection if that option is available in your Excel version. This is useful for a quick handout because it avoids changing the workbook’s ongoing print setup.
A saved print area is better when the same range should be used repeatedly, such as a monthly report or a form. Printing a selection is more temporary and can be convenient when you need a different subset for one occasion. These approaches are not interchangeable in every situation: the saved print area is a worksheet setting, while a print-selection choice applies to the current output task.
In Excel for the web, printing options and the ability to manage page setup are more limited than in the desktop app. If you need to create or reliably edit a saved print area, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac. The web version may retain print settings made in desktop Excel, but do not assume that every desktop page-layout command is available there.
Common problems and how to fix them
- Only part of the report prints: Clear the print area, preview again, and set a new area that includes the missing cells. Also check whether columns or rows are hidden.
- The print area will not expand: Select the added cells and use Add Print Area, or select the full intended range and use Set Print Area to replace the old boundary.
- The result is tiny: Check whether both width and height are set to fit on one page. Set height to Automatic or allow more pages, and inspect the preview.
- Blank pages appear: Look for formatting or stray content far beyond the main report, manual page breaks, and an oversized print area. Clear the area and set a tighter range if appropriate.
- Headings disappear on later pages: Set them through Page Layout > Print Titles rather than expecting the print area to repeat them.
- A teammate sees a different result: Confirm that they are printing the same worksheet and using the same page size, orientation, and scaling. The saved print area travels with the worksheet, but printer settings can differ.
One common misconception is that clearing a print area resets every printing choice. It only removes the defined range. Orientation, margins, scaling, print titles, and manual page breaks are separate settings and may remain in place. If you want a clean diagnostic, change one setting at a time and compare the print preview.
Frequently Asked Questions
How do I change the print area in Excel?
Select the new cell range and choose Page Layout > Print Area > Set Print Area. This replaces the previous saved area on that worksheet.
How do I remove the print area in Excel?
Choose Page Layout > Print Area > Clear Print Area. The worksheet’s content remains unchanged; Excel simply no longer uses that saved boundary.
Can I have multiple print areas on one worksheet?
Yes. Select nonadjacent ranges and set them together, or select an additional range and choose Add Print Area. Preview the result because separate areas can print as separate sections or pages.
Why is Excel printing only part of my worksheet?
A saved print area may exclude the missing cells. Check File > Print, then clear or redefine the area. If that does not fix it, check hidden rows and columns, filters, and page setup.
How do I make the print area fit on one page?
Use the Scale to Fit controls on the Page Layout tab to set the width and, if appropriate, height to one page. Preview the result carefully; fitting a large range onto one page can make its text too small to read.
Does changing the print area change what is visible on the worksheet?
No. A print area affects printed output, not the worksheet’s visible cells. To hide worksheet content, use a different feature, such as hiding rows or columns; that can also affect what prints.
Related
- Can You Hide a Column in Excel From View?
- Location Heat Map in Excel: Create One Step by Step
- Compare Two Excel Sheets for Matches and Differences
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Breaks for Printing: How to Add Them EasilyTo add a page break in Excel for Microsoft 365 on Windows, select the row below where the…
- How to Make Columns in Word After a Title or HeadingTo put text in columns below a full-width title in Microsoft Word, select the body text and choose…
- Merge Cells and Keep Both Values in Excel Without Data LossIn Excel, merging cells keeps only the value in the upper-left cell; any other cell contents in the…
- How to Make Bullet Points in Two Columns in WordTo make bullet points appear in two columns in Microsoft Word, place the list in its own section,…
- 0 in Excel Conditional Formatting: 10 Practical RulesTo highlight zero values in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Google Sheets: Count Cells That Contain Text with COUNTIFTo count cells that contain text in Google Sheets, use =COUNTIF(A2:A100,"*"), replacing A2:A100 with your range. The asterisk…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.