Excel guide · 5 min read
How to print gridlines in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Location | System qty | Counted | Initials |
| 2 | Paper towels 12pk | Aisle 1 | 40 | ||
| 3 | Hand soap 5L | Aisle 1 | 18 | ||
| 4 | Bin liners 100 | Aisle 2 | 25 | ||
| 5 | Nitrile gloves M | Aisle 2 | 60 | ||
| 6 | Glass cleaner 1L | Aisle 3 | 14 | ||
| 7 | Mop heads | Aisle 3 | 9 | ||
| 8 | Toilet rolls 36pk | Store room | 22 | ||
| 9 | Floor cleaner 5L | Store room | 7 |
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.
- 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.
- Go to Page Layout and find Sheet Options.
- Under Gridlines, tick Print. (View is the on-screen setting next to it.)
- 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.
- Select A1:E19 (or type the range into the Name Box and press Enter).
- Go to Page Layout > Print Area > Set Print Area.
- Press Ctrl+P. The ten blank rows now print as an empty grid.
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.
- Select A1:E19.
- Home > Borders (the arrow next to the borders button) > All Borders.
- 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.
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
- How to add borders in Excel
- How to add a watermark in Excel
- Excel gridlines not showing (or missing in some cells): how to get them back
- Excel print area not working: why it prints the wrong cells and how to fix it
- Excel print titles not working: how to repeat the header row on every page
- Excel AutoSum selecting the wrong range
Updated