How to Print an Excel Spreadsheet That Actually Fits: Gridlines, Headers and Page Setup

Quick answer: three settings fix almost every Excel printing problem. To get the lines, go to Page Layout > Sheet Options > Gridlines and tick Print — the gridlines you see on screen are not printed by default. To stop columns spilling onto a second sheet, use Page Layout > Scale to Fit and set Width: 1 page while leaving Height: Automatic. To repeat your column headers on every page, use Page Layout > Print Titles > Rows to repeat at top. Do those three and a spreadsheet that used to print across nine confusing pages prints as a document someone can read.

Excel is a spreadsheet that happens to print, not a word processor, and it shows. The default behaviour — no lines, no headers after page one, columns wrapping onto orphan sheets — catches everyone. This guide covers the settings that matter, in the order you should apply them.

1. Print the gridlines

The most common complaint about printed spreadsheets is that the lines vanish. That is by design: the faint grey grid on screen is a display aid, and Excel does not print it unless you ask.

1. Go to the Page Layout tab.
2. In the Sheet Options group, find Gridlines.
3. Tick the Print checkbox (the View checkbox next to it only affects the screen).

Microsoft's reference is Print gridlines in a worksheet. One thing that trips people up: gridlines only print for cells inside the used range. Empty cells beyond your data get no lines, which is why a table sometimes prints with lines that stop abruptly.

Borders versus gridlines

If you want control over which lines appear — thicker lines under headers, no vertical lines, a box around a total — use borders instead. Select the range, then Home > Borders. Borders print regardless of the gridlines setting, and they look considerably more professional on anything you are handing to someone else. For internal working copies, gridlines are quicker.

2. Set a print area so you print only what you mean to

Excel prints the whole used range by default, which on a working sheet often includes stray notes, a scratch calculation in column AF, and a row of test data you forgot about.

1. Select the range you actually want.
2. Page Layout > Print Area > Set Print Area.

The area is saved with the file, so it applies every time. To change it later, Page Layout > Print Area > Clear Print Area and set a new one. For a one-off, skip the print area entirely: select the range, then File > Print and choose Print Selection in the first dropdown.

3. Make it fit — the Scale to Fit trap

Here is the setting most people get wrong. In the Page Layout tab, the Scale to Fit group has Width, Height and Scale. The instinct is to set both Width and Height to 1 page. Do not — on a long list that squashes two hundred rows onto a single sheet at unreadable size.

What you almost always want:

• Width: 1 page — no columns spill onto an orphan sheet
• Height: Automatic — the rows flow naturally onto as many pages as they need

If the result is still too small to read, the spreadsheet is too wide for portrait. Switch to Page Layout > Orientation > Landscape, or narrow the columns, or move to a larger paper size. Our guide to letter vs legal vs A4 vs tabloid is worth a look if you print wide financial sheets regularly — legal at 8.5 × 14 in is often the difference between a readable report and a squint.

Watch the scale percentage

When you use Scale to Fit, Excel shows the resulting percentage in the Scale box. Below roughly 60% most fonts stop being comfortably readable. If Excel has dropped to 45% to make things fit, that is a signal to change the layout rather than accept the output.

4. Repeat header rows on every page

A multi-page table where only page one has column headings is nearly useless. Excel handles this properly, but the setting is not where you would expect it:

1. Page Layout > Print Titles.
2. In Rows to repeat at top, click the selector and click your header row — it fills in as $1:$1, or $1:$2 for a two-row header.
3. For very wide sheets, do the same in Columns to repeat at left so row labels stay visible on every page.
4. Click OK, then check it in Print Preview.

Microsoft documents this at Repeat specific rows or columns on every printed page. Note that the Print Titles button is greyed out while you are editing a cell, and while multiple sheets are selected — a genuinely confusing bit of Excel behaviour that has cost a lot of people ten minutes.

5. Use Page Break Preview before you print anything long

This is the most underused tool in Excel printing. Go to View > Page Break Preview and the sheet shows blue lines where every page break will fall, with page numbers watermarked behind the data.

You can drag those blue lines to move the breaks. Drag a break to the right and Excel shrinks the scale to fit; drag it left and it grows. It is a far more direct way to control a printout than guessing at scale percentages. To force a break at a specific row, select the row below where you want it and choose Page Layout > Breaks > Insert Page Break.

6. Row and column headings, page numbers, and the other extras

What you want	Where it lives
The A, B, C and 1, 2, 3 headings printed	Page Layout > Sheet Options > Headings > Print
Page numbers, filename, date on each sheet	Insert > Header & Footer, or Page Setup > Header/Footer
Centre the table on the page	Page Setup > Margins > Center on page: Horizontally
Narrower margins to gain a column	Page Layout > Margins > Narrow
Print formulas instead of results	Formulas > Show Formulas, then print
Print comments or notes	Page Setup > Sheet > Comments and notes
Print in black and white regardless of fills	Page Setup > Sheet > Black and white
Print every sheet in the file	File > Print > Print Entire Workbook

That Show Formulas option deserves a mention — printing a sheet with formulas visible, alongside a normal copy showing values, is the fastest way to document or hand over a model. Excel widens the columns automatically when you toggle it, so set your print area afterwards.

Excel on Mac and Excel for the web

On Mac, the same options exist but some live in File > Page Setup and the Sheet tab rather than on the ribbon. Print Titles is under Page Setup > Sheet > Print titles. Everything else maps across.

On Excel for the web, the print options are reduced. You get orientation, paper size, scaling and margins, but not print titles or gridline control. If you need those, open the file in the desktop app. Microsoft's general reference for the whole area is Print a worksheet or workbook.

Printing big spreadsheets without emptying a cartridge

Spreadsheets look cheap to print and often are not, because of what people put in them. Conditional formatting that fills whole columns with colour, banded table styles with a shaded row every other line, and charts with solid backgrounds all consume a surprising amount of ink across a fifty-page report.

• Tick Black and white in Page Setup > Sheet. It ignores cell fills and font colours entirely and prints clean text — a much better result than simply selecting grayscale at the printer, which converts every fill into a grey block.
• Turn off banded rows for the printed version. Gridlines do the same job for free.
• Use draft or economy quality for internal working copies.
• Print double-sided. Long reports halve instantly — see duplex printing on Windows, Mac and Chromebook.
• Print to PDF first, always, on anything over five pages. It is free and it catches the orphan-column problem before it costs you paper.

If you print long reports routinely, it is worth knowing your actual cost per page — our ink cost calculator works it out, and for heavy black-text output a mono laser is often dramatically cheaper than an inkjet, which is the case our guide to monochrome printers makes.

Troubleshooting

Problem	Cause	Fix
No lines on the printout	Gridlines print option is off	Page Layout > Sheet Options > Gridlines > Print
One or two columns land on their own page	Sheet is wider than the paper	Scale to Fit: Width 1 page, Height Automatic — or switch to landscape
Headers only appear on page one	Print Titles not set	Page Layout > Print Titles > Rows to repeat at top
Dozens of blank pages print	Stray content or formatting far down or across the sheet inflates the used range	Set a print area, or select the empty rows and columns and delete them, then save
Print Titles is greyed out	You are editing a cell, or several sheets are selected	Press Escape, right-click a sheet tab and choose Ungroup Sheets
Text is unreadably small	Scale dropped very low to make it fit	Landscape, narrower columns, or a larger paper size
Colours look muddy in print	Cell fills converted to grey	Page Setup > Sheet > Black and white
Prints faint or streaked	Printer, not Excel	See faded and streaky prints
Nothing prints at all	Printer, driver or queue	See the not-printing checklist

A five-step routine for any spreadsheet

1. Select the range and set the print area.
2. Turn on gridlines, or apply borders if it is going to someone else.
3. Scale to Fit: Width 1 page, Height Automatic. Go landscape if the scale drops below about 60%.
4. Print Titles: repeat the header row.
5. Page Break Preview, then print to PDF and check it before touching paper.

It takes under a minute once it is habit, and it saves the reprint. For the paper side of the job, our paper weight and brightness guide covers what to use for reports that get handed around, and when you need a refill the Find Ink by Printer page matches your model to the right cartridge — or browse HP toner and Brother toner if your reporting runs on a laser.