How to Print an Excel Spreadsheet on One Page, Readably

Spreadsheets are the documents most likely to print badly at home: one stray column ends up alone on page two, the header row vanishes after the first page, and the totals land on a sheet of their own. Learning how to print an Excel spreadsheet on one page fixes most of this in a minute, as long as you also keep the result readable. Excel has a dedicated scaling option for it, plus a few settings that make the difference between a neat printout and a page of tiny numbers.

The quick way: Fit Sheet on One Page

For a small sheet that only just spills over, the fastest route is in the print screen:

1. Press Ctrl+P (or choose File, Print).
2. Under Settings, open the scaling list, which normally reads No Scaling.
3. Choose Fit Sheet on One Page.
4. Check the preview and print.

The same list also offers Fit All Columns on One Page and Fit All Rows on One Page, which are often the better choice (see below).

The precise way: Page Setup, Fit to

Microsoft’s instructions give you full control over how many pages the sheet becomes:

1. Open the Page Layout tab and select the small launcher arrow in the Page Setup group.
2. In the Page Setup dialog, select the Page tab.
3. Under Scaling, choose Fit to.
4. Set it to 1 page wide by 1 tall to put everything on one page.
5. Select OK.

Excel then shrinks the data to fit the number of pages you set. Microsoft points out that you can use other numbers too, for example 1 page wide by 2 tall for a sheet that would be unreadable on a single page.

Excel for the web does not offer this option. Microsoft’s advice is to select Open in Excel to open the workbook in the desktop app and set the scaling there.

Keep it readable: fit the columns, not the rows

Squeezing a 300-row list onto one sheet produces text nobody can read. The common, better solution is to fit the width only:

• In the Fit to boxes, set 1 page wide and leave the tall box empty, or
• choose Fit All Columns on One Page in the print screen.

Every column stays on the page, and the rows simply continue onto as many pages as they need. Add a repeated header row (below) and each page is easy to read on its own.

A rough check: if the preview text looks smaller than the footnotes in a book, it will be hard to read on paper. Try one of the fixes in the next section before printing.

Five ways to make the sheet fit without shrinking it

1. Set a print area. Select the cells you actually need, then choose Page Layout, Print Area, Set Print Area. Microsoft explains that a print area prints instead of the whole sheet, and that you can have more than one; each prints on its own page. Page Break Preview on the View tab shows them.
2. Turn the page. Switch Orientation to Landscape on the Page Layout tab. Wide sheets often fit at full size this way.
3. Narrow the margins. Choose Margins, Narrow on the Page Layout tab. Most home printers cannot print right to the edge, so do not go to zero.
4. Tidy the columns. Hide helper columns you do not need on paper, wrap long headings and reduce over-wide columns.
5. Move page breaks. In Page Break Preview you can drag the dashed automatic breaks so that sections such as months or categories start on a new page.

Print gridlines and repeated headings

Two settings make a printed sheet far easier to follow:

Gridlines. By default Excel prints no gridlines, which makes rows hard to track across the page. On the Page Layout tab, in the Sheet Options group, tick Print under Gridlines. Microsoft notes that the boxes are greyed out when a chart or image is selected, and that gridlines print only around cells with data unless your print area includes the empty cells. Cell borders are the alternative if you want lines in specific places only.

Print titles. When a list runs over several pages, repeat the header row on every page: select Print Titles on the Page Layout tab, then on the Sheet tab enter the row in Rows to repeat at top, for example $1:$1. The Columns to repeat at left box does the same for a label column. Microsoft notes the command is dimmed while you are editing a cell or when a chart is selected.

Choosing paper and print settings

• Paper size. Make sure Excel’s paper size matches the paper in the printer; A4 and Letter differ enough to push a column onto a second page. Our guide to fit to page vs actual size explains the differences.
• Black and white. Coloured cell fills use colour ink even if you only need the numbers. Choosing black and white or greyscale in the printer settings saves colour ink; see how to print with only black ink.
• Draft quality. For a working copy, draft or economy quality is enough and uses less ink.
• Two sheets on one. For a quick check copy, printing multiple pages on one sheet works with spreadsheets too, but the numbers get small quickly.

Save the sheet as a PDF to share

If someone else will print the sheet, send a PDF so your scaling and page breaks travel with it. In Excel, choose File, Save As, pick PDF as the file type and choose Standard quality for printing. Microsoft warns that links inside a workbook can be lost in the PDF, so check them. Our guide to how to print to PDF covers the other ways to make one.

Quick troubleshooting

Problem	Likely cause	Fix
One column on page two	Sheet slightly too wide	Fit All Columns on One Page or landscape
Text tiny on one page	Too much data for one sheet	Fit width only, set a print area
Blank pages printed	Stray formatting far down the sheet	Set a print area around the real data
Headers only on page one	No print titles set	Rows to repeat at top
No lines between cells	Gridlines off by default	Tick Print under Gridlines

If the printer itself cuts off the edge of the page or prints the sheet too small no matter what Excel shows, the problem is in the printer settings rather than the sheet; check the scaling in the printer’s own preferences and make sure it is at 100%.