Cellwise Start free

Excel guide · 5 min read

How to print gridlines in Excel

Quick answerGo to Page Layout and, in the Sheet Options group, tick Print under Gridlines. Then check File > Print (Ctrl+P): the preview shows the lines. Gridlines are off on paper by default, the setting is per sheet, and they only print around cells that contain data unless you set a print area that includes the empty cells.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDE
1ItemLocationSystem qtyCountedInitials
2Paper towels 12pkAisle 140
3Hand soap 5LAisle 118
4Bin liners 100Aisle 225
5Nitrile gloves MAisle 260
6Glass cleaner 1LAisle 314
7Mop headsAisle 39
8Toilet rolls 36pkStore room22
9Floor cleaner 5LStore room7

Download this sheet as an Excel practice file (.xlsx)

Turn on printed gridlines

The sample is a stock count sheet: items and system quantities typed in, with empty Counted and Initials columns for someone to fill in by hand. Without gridlines, the printout is a list of words floating on white paper and nobody can tell which line they're writing on. On screen everything looks fine, because screen gridlines and printed gridlines are two separate settings.

  1. Click the sheet you want to print. To set several sheets at once, Ctrl+click their tabs (the title bar shows Group), and ungroup afterwards.
  2. Go to Page Layout and find Sheet Options.
  3. Under Gridlines, tick Print. (View is the on-screen setting next to it.)
  4. Press Ctrl+P and check the preview before you print.

The Print box is greyed out

Microsoft's note: if the boxes in Sheet Options look dimmed, you probably have a chart, picture or other object selected. Click any ordinary cell and they come back. The same tick box is also in Page Layout > Page Setup dialog launcher > Sheet tab > Print > Gridlines, if you prefer the dialog.

Gridlines for empty rows and columns

Excel prints gridlines only around the data on the sheet. In the sample the Counted and Initials columns are empty, but their headers in row 1 make them part of the data, so they get lines. Empty rows below the last item don't. That's a problem on a count sheet, where people find items that aren't on the list and need blank rows to write them in.

The fix is a print area that includes the empty rows. Decide how many spare rows you want, and work out the range from the number of filled rows.

  1. Select A1:E19 (or type the range into the Name Box and press Enter).
  2. Go to Page Layout > Print Area > Set Print Area.
  3. Press Ctrl+P. The ten blank rows now print as an empty grid.
="$A$1:$E$"&(COUNTA(A1:A30)+10)

Result: $A$1:$E$19

$A$1:$E$19: the header, 8 items and 10 empty rows. Set this as the print area and all of it prints with gridlines.

What if the print area seems to be ignored?

A print area set earlier, Ignore Print Area in the Print screen, or a scaling option can all get in the way. Work through Excel print area not working.

Gridlines still don't print

If the box is ticked and the preview still shows no lines, go through these in order:

  • Draft quality is on. Microsoft names this first: File > Print > Page Setup > Sheet tab, and clear Draft quality. Draft printing leaves out gridlines and most graphics.
  • You ticked View instead of Print, or ticked Print on a different sheet. Each sheet keeps its own setting.
  • The cells have a white fill. A fill covers gridlines on paper as well as on screen; select the cells and choose Home > Fill Color > No Fill.
  • The lines are too faint for your printer. Light grey can disappear on some printers, especially with Black and white or toner-saving settings. Borders print darker and are under your control.
  • It's a printer driver problem. If the preview shows lines but the paper doesn't, Microsoft suggests updating the printer driver from the manufacturer's website.

Excel for the web, PDFs, and when to use borders instead

Microsoft says printing gridlines isn't supported in Excel for the web. There, select the range and use Home > Borders > All Borders, which prints everywhere. A PDF made with File > Save As or Export follows the same print settings as paper, so tick Print under Gridlines before you save the PDF.

Borders are the better choice when the printout is a form someone fills in or a document you send outside the team: they look the same on every printer, in every PDF and for every reader, and you can make the writing columns thicker or darker than the rest. Gridlines are the quick option for a working printout.

  1. Select A1:E19.
  2. Home > Borders (the arrow next to the borders button) > All Borders.
  3. Optional: untick Page Layout > Gridlines > Print, so you don't get faint gridlines and borders on top of each other.

Print the row numbers and column letters too

If you want the A, B, C letters and 1, 2, 3 row numbers on the printout, so you can say "check row 7" on a call, tick Print under Headings in the same Sheet Options group. Headings and gridlines are separate, and you can print either or both. If the headings are missing from your screen as well, see row and column headings missing.

=SUM(C2:C9)

Result: 195

195: the total system quantity on the count sheet, a useful check figure to write at the bottom of the printout.

Common mistakes

Ticking View instead of Print

View is the screen setting. Tick Print under Gridlines in Page Layout > Sheet Options.

Expecting blank rows to print as a grid

Gridlines print only around data. Set a print area that includes the empty rows, or add borders.

Leaving Draft quality on

Page Setup > Sheet tab > clear Draft quality, or the gridlines are left out.

Relying on gridlines in Excel for the web

Printing gridlines isn't supported there. Use Home > Borders > All Borders.

FAQ

Why are my gridlines not printing in Excel?

Print under Gridlines isn't ticked for that sheet, Draft quality is on, the cells have a white fill, or the lines are too faint for the printer. Check each, then look at the preview with Ctrl+P.

How do I print gridlines on empty cells?

Set a print area that includes the empty cells with Page Layout > Print Area > Set Print Area, then tick Print under Gridlines. Or put borders around them.

How do I print an Excel sheet with lines?

Tick Page Layout > Sheet Options > Gridlines > Print for light grey lines, or select the range and apply Home > Borders > All Borders for darker lines that always print.

Do gridlines show in a PDF from Excel?

Only if Print is ticked under Gridlines, because the PDF uses the same print settings. Borders always show.

Can I make printed gridlines darker?

Gridlines are always thin. You can pick a darker Gridline color in File > Options > Advanced > Display options for this worksheet, but for lines that reliably print dark, apply thin black borders instead.

Functions used

Related guides

Updated