No Ticket Needed

Appearance

3 min fix 9 min read Recently reviewedBeginner

By , IT support technician

Quick Answer

Press Ctrl + P, open the last dropdown in the settings column — it reads No Scaling — and choose Fit Sheet on One Page. The page counter under the preview changes to 1 of 1.

How to Print an Excel Spreadsheet on One Page ​

Applies to: Microsoft 365 (Excel for Windows, Excel for Mac, Excel for the web); Excel 2019 and later
Article Type: How-To
Last Updated: 2026-07-29

Summary ​

Excel prints whatever fits on the paper and pushes the rest onto extra pages, which is how a twelve-column report turns into six sheets with two lonely columns on the last one. This article shows you how to fit a sheet onto one page, how to decide when one page is the wrong answer, and how to make the extra pages readable when you need them.

Prerequisites ​

  • Excel on Windows, Mac, or the web.
  • A printer installed, or the built-in Microsoft Print to PDF printer that ships with Windows 11 and Windows 10.
  • No admin rights required.

Instructions ​

1. See What Will Print in Page Layout View ​

The ordinary grid gives you no clue where the paper ends. Change the view before you change any settings.

  1. Open the View tab on the ribbon.
  2. In the Workbook Views group at the far left, click Page Layout.
  3. The sheet redraws as sheets of paper with white gaps between them, rulers appear along the top and left edges, and a Click to add header box appears above row 1.
  4. Scroll right. The first column that lands past a paper edge is the one causing your overflow.
  5. Click Normal in the same group to return. Dashed lines now mark the page breaks on the ordinary grid.

Tip: Three small view buttons sit in the bottom-right corner of the Excel window, to the left of the zoom slider. From left to right they are Normal, Page Layout and Page Break Preview.

Note: Excel for the web has no Page Layout view, no Page Break Preview and no Print Titles. Its print screen offers the same scaling choices covered in Step 2. For everything else, open the View tab and click Open in Desktop App.

2. Fit the Sheet on One Page from the Print Screen ​

This is the one-click answer, and it lives in the print settings rather than on the ribbon.

  1. Press Ctrl + P to open the print screen. Settings run down a column on the left, and the preview fills the right side.
  2. Scroll to the bottom of the settings column. The last dropdown reads No Scaling.
  3. Click it and choose one of the three options:
    • Fit Sheet on One Page — shrinks everything until the whole sheet lands on a single page.
    • Fit All Columns on One Page — keeps the full width on one page and lets rows continue onto later pages. This is the right choice for a long list.
    • Fit All Rows on One Page — keeps every row on one page and lets columns run sideways onto later pages.
  4. Watch the page counter underneath the preview. It changes from 1 of 6 to 1 of 1.
  5. Click Print.

Note: Scaling is stored per worksheet, not per workbook. Set it again on each sheet you plan to print.

Verification: To see how far Excel has shrunk the sheet, reopen the same dropdown, click Custom Scaling Options..., and read the Adjust to box on the Page tab of the Page Setup dialog. It shows the percentage Excel chose. Anything under roughly 65% is uncomfortable to read at arm's length.

3. Print Only What You Need with a Print Area ​

Fitting everything on one page is often the wrong goal. Most working sheets carry helper columns, notes and totals that nobody needs on paper.

  1. Select the range you want printed. Click the first cell, then hold Shift and click the last cell of the range.
  2. Open the Page Layout tab.
  3. In the Page Setup group at the far left, click Print Area, then Set Print Area.
  4. A thin dashed border appears around the range. Everything outside it is ignored when you print.
  5. Press Ctrl + P to confirm — the preview now shows the selected range only.

To change it later, click Page Layout > Print Area > Clear Print Area and set a new one. To print a second, separate block of cells, select it and choose Add to Print Area; each block prints on its own page.

Tip: Hiding columns is faster for a one-off. Select the column letters you do not need on paper, right-click, and choose Hide. Hidden columns never print. To bring them back, select the columns either side of the gap, right-click, and choose Unhide.

4. Switch to Landscape and Shrink the Margins ​

These two settings recover a useful amount of width, and unlike scaling they cost you nothing in readability.

  1. On the Page Layout tab, click Orientation in the Page Setup group, then Landscape. The page turns on its side, giving you about a third more printable width.
  2. Click Margins in the same group and choose Narrow, which cuts the left and right margins to 0.25 inch from the standard 0.7 inch.
  3. For finer control, click Margins > Custom Margins.... The Page Setup dialog opens on the Margins tab.
  4. Under Center on page at the bottom of that tab, tick Horizontally so a narrow table sits in the middle of the sheet rather than hugging the left edge.
  5. Click OK.

Verification: Press Ctrl + P and check the page counter under the preview. If orientation and margins alone brought you to 1 of 1, leave the scaling dropdown on No Scaling and keep your text at full size.

5. Repeat the Header Row on Every Page with Print Titles ​

When one page genuinely is not enough, this is the setting that makes pages 2 and 3 usable.

  1. Press Esc first. Print Titles is greyed out while a cell is in edit mode, and while more than one sheet tab is selected.
  2. On the Page Layout tab, click Print Titles in the Page Setup group. The Page Setup dialog opens on the Sheet tab.
  3. Click inside the Rows to repeat at top box.
  4. Click the row header — the number 1 at the far left of your header row. The box fills in with $1:$1. For a two-row header, drag down across row headers 1 and 2 to get $1:$2.
  5. To repeat a label column as well, click inside Columns to repeat at left and click the column letter, which gives $A:$A.
  6. Click Print Preview at the bottom of the dialog and page forward. Your header row now sits at the top of page 2.
  7. Click OK.

Note: This is the print equivalent of freezing panes on screen, and the two are set separately — freezing row 1 does not repeat it on paper. See How to Freeze Panes and Split Views in Excel for the on-screen version.

6. Move the Page Breaks in Page Break Preview ​

Scaling decides how much fits. Page breaks decide where the cut falls, and a cut between sections reads far better than one through the middle of a table.

  1. On the View tab, click Page Break Preview in the Workbook Views group.
  2. The sheet redraws with a large page number watermark on each page, a solid blue border around the print area, and blue lines at every break — dashed where Excel chose the break, solid where someone set it.
  3. Drag a break line to where the split belongs. The line turns solid, marking it as yours.
  4. To force a break at a specific row, click the header of the row that should start the new page, then click Page Layout > Breaks > Insert Page Break.
  5. To start again, click Page Layout > Breaks > Reset All Page Breaks.
  6. Click Normal on the View tab when you have finished.

Note: Dragging a dashed line outward to squeeze more onto a page does not move the break. Excel shrinks the sheet to make the extra content fit and writes the new percentage into Adjust to on the Page tab of Page Setup. Check that number if a print comes out smaller than you expected.

Troubleshooting ​

WARNING

Fit Sheet on One Page shrinks a sheet as far as 10% of normal size without asking, which produces a single page of print nobody can read. Before sending a wide report to the printer, open File > Print, click Custom Scaling Options..., and read the Adjust to percentage. Below roughly 65%, choose Fit All Columns on One Page and repeat the header row instead — two readable pages beat one unreadable page.

Symptom / ErrorPotential CauseSolution
Print comes out far too smallFit Sheet on One Page scaled it downSwitch to Fit All Columns on One Page (Step 2), or trim the sheet with a print area (Step 3).
Two or three columns print alone on the last pageSheet is wider than the paperApply Landscape and Narrow margins (Step 4) before you reach for scaling.
Blank pages print after the dataStray content or formatting far down the sheetSet a print area (Step 3), or select the empty rows below your data, right-click, choose Delete, and save.
Header row appears on page 1 onlyPrint Titles not setSet Rows to repeat at top to $1:$1 (Step 5). Freezing panes does not affect printing.
Print Titles is greyed outCell in edit mode, or sheets groupedPress Esc, then right-click a sheet tab and choose Ungroup Sheets.
Gridlines do not appear on paperGridlines are screen-only by defaultOn the Page Layout tab, in the Sheet Options group, tick Print under Gridlines.