How to Print Gridlines in Excel 2013 and Later

To print gridlines in Excel, click the Page Layout tab, check the Print box under Gridlines in the Sheet Options group, and then print with File > Print (or Ctrl+P). Excel leaves gridlines off printouts by default, so you need to turn this on for each worksheet you want printed with lines.

These steps apply to Excel for Microsoft 365, Excel 2024, and Excel 2021 on Windows, and match Excel 2013 through 2019. Excel for Mac uses the same checkbox, and Microsoft documents it in Print gridlines in a worksheet. Not sure what you have? Check which version of Excel you’re using.

Gridlines vs. Borders

Gridlines are the faint gray lines that separate cells on screen. They’re a sheet-wide setting, and they print only when you turn on the Print option.

Borders are lines you add to specific cells with the Borders button on the Home tab. Borders always print, and you can choose their color and thickness.

A fill color hides gridlines on screen, so if you fill cells with color in Excel, add borders to keep the lines visible.

Use gridlines when you want a quick lined printout of a whole sheet. Use borders when you want lines around only some cells, darker lines, or lines that print from any version of Excel, including the browser version. For a sheet that runs to many pages, combine gridlines with the layout fixes in how to print a large Excel spreadsheet.

How to Print Gridlines in Excel on Windows

  1. Open the workbook and click the tab of the worksheet you want to print.
  2. Click the Page Layout tab in the ribbon.
  3. In the Sheet Options group, find Gridlines and check the Print box. The View box above it only controls what you see on screen.
Excel Page Layout tab with the Gridlines Print box checked
Check Print under Gridlines.
  1. Press Ctrl+P, or click File > Print. The preview on the right shows light lines around each cell in your data. Ctrl+F2 opens the same preview.
Excel print preview showing gridlines around cells
The preview shows the gridlines that will print.
  1. Choose your printer and click Print.

The setting is saved with the worksheet, so it stays on the next time you print that sheet, and it travels with the file if you send it to someone else. Clear the Print box to go back to printing without gridlines.

If the Sheet Options checkboxes are grayed out, a chart, picture, or other object is probably selected. Click any cell and try again.

Turn On Gridlines From the Page Setup Dialog

The Page Setup dialog box has its own Gridlines checkbox that does the same thing as the ribbon option. It’s handy when you’re already in the print screen, because you don’t have to leave it.

  1. Click File > Print.
  2. Click the Page Setup link at the bottom of the Settings list.
  3. Open the Sheet tab.
  4. Under Print, check Gridlines, and then click OK. The preview updates to show the lines.
Excel Page Setup dialog with Sheet selected and the Gridlines box checked under Print
Excel Page Setup dialog. On the Sheet tab, check Gridlines under Print. (Recreated interface)

You can also open the same dialog from the small arrow (the dialog box launcher) in the bottom-right corner of the Page Setup or Sheet Options group on the Page Layout tab. The Sheet tab also holds Row and column headings, Draft quality and the rows to repeat on each page, so it’s a good place to set up a printout in one go.

Print Gridlines on Several Sheets at Once

The Print setting applies to one sheet at a time, but you can set it for several sheets together.

  1. Hold Ctrl and click each sheet tab you want to print. To select every sheet, right-click a tab and choose Select All Sheets. [Group] appears in the title bar.
  2. On the Page Layout tab, check Print under Gridlines.
  3. Click File > Print, choose Print Entire Workbook or Print Active Sheets under Settings, and click Print.
  4. Right-click a selected tab and choose Ungroup Sheets. While sheets are grouped, anything you type or format changes every sheet in the group.

How to Print Gridlines in Excel for Mac

Microsoft’s Mac instructions for printing cell gridlines use the same checkbox.

  1. Click the worksheet you want to print.
  2. Click the Page Layout tab.
  3. Under Gridlines, check Print.
  4. Choose File > Print (or press Command+P), check the preview, and click Print.

The Mac version has the same Draft quality setting in File > Print > Page Setup > Sheet, so check it if the lines don’t appear.

How to Print a Blank Grid

Excel prints gridlines only around cells that contain data. An empty sheet prints a blank page even with the Print box checked. To print an empty grid for a sign-up sheet, checklist, or form, use one of these options.

Set a print area. Select the empty range you want, such as A1:F40, then click Page Layout > Print Area > Set Print Area. With gridline printing on, every cell in that range prints with lines. To print the whole sheet again later, choose Page Layout > Print Area > Clear Print Area.

If the grid needs exact cell sizes, show the ruler in Excel and set column widths in inches.

Add borders. Select the range, click the arrow next to the Borders button on the Home tab, and choose All Borders. Borders print darker than gridlines and don’t depend on the gridline setting. For line styles and thicker borders, read about adding cell borders in Excel.

Some guides suggest typing a space in the last cell you want lined so Excel treats that cell as used. A print area does the same job without hidden content in your sheet, so it’s the better choice.

If you’re reusing an old filled-in form, delete the data but keep the formatting first, then print.

Formulas on an empty form often show 0, so you may want to hide zero values in Excel before you print it.

Save a PDF With Gridlines

A PDF follows the same print settings as paper. Turn on Print under Gridlines first, then click File > Save As (or Save a Copy), choose PDF as the file type, and save. Open the PDF to confirm the lines are there. On a Mac, press Command+P and choose Save as PDF from the PDF menu.

Printing Gridlines in Excel for the Web

Printing gridlines is not supported in Excel for the web, according to Microsoft’s main gridline article, so use borders there instead. A shorter Microsoft page lists Excel for the web under the same Page Layout steps, so if your browser version shows a Print box under Gridlines on the Page Layout tab, check it and confirm the lines in the print preview. Otherwise, add borders:

  1. Select the cells you want lined.
  2. On the Home tab, click the arrow next to Borders and choose All Borders.
  3. Click File > Print, check the preview, and click Print.

Use Excel’s own File > Print rather than your browser’s print command, which prints the web page around the sheet. If you have the desktop app, you can also click Editing > Open in Desktop App and use the Page Layout steps above.

If Gridlines Won’t Print

  • The Print box is on a different sheet. The setting is per worksheet. Check the Page Layout tab while the sheet you’re printing is active.
  • Draft quality is on. Draft mode skips gridlines and most graphics. Click File > Print > Page Setup, open the Sheet tab, clear Draft quality, and click OK. In Windows Excel, Alt, then P, S, P opens the same dialog.
  • Part of the sheet has no lines. Gridlines stop at the last cell with data. Set a print area that includes the empty cells, or add borders.
  • Filled cells look different. If some cells have a fill color and the preview doesn’t show lines where you want them, add borders to those cells, or set the fill to No Fill.
  • The lines are too faint. Gridlines print in light gray, and some printers barely show them. Use All Borders instead, and pick a darker line color or thicker style from Borders > Line Color or Line Style if needed.
  • Printer problems. If the preview shows gridlines but the paper doesn’t, install the latest printer driver from the manufacturer’s website.
Excel Page Setup Sheet tab with Draft quality cleared
Clear Draft quality if gridlines are missing from the printout.

Why Excel Prints Lines When Gridlines Are Off

If lines print even though the Print box is cleared, they’re cell borders. To remove them, select the cells (or press Ctrl+A to select the whole sheet), click the arrow next to Borders on the Home tab, and choose No Border.

The dashed lines you may see on screen after printing are page breaks. They show where pages split and don’t print. To clear them, read about returning worksheets to Normal view.

Excel Gridline Printing Questions

Can I print gridlines without them showing on screen?

Yes. The View and Print boxes under Gridlines are separate. Clear View and check Print to hide the lines while you work and still print them.

Can I print row numbers and column letters too?

Yes. On the Page Layout tab, check Print under Headings in the same Sheet Options group. The printout shows the 1, 2, 3 row numbers and A, B, C column letters.

How do I fit a sheet with gridlines on one page?

Gridlines follow your page layout settings. Fitting a spreadsheet on one page shrinks it, and repeating rows on every printed page keeps your headers visible on multi-page printouts.

Can I print gridlines in a darker color?

Excel lets you change the on-screen gridline color in File > Options > Advanced, under Display options for this worksheet, with Gridline color. Microsoft’s article on that setting covers the screen only and doesn’t say how it prints, so check the print preview. For lines that are reliably dark or thick on paper, use borders.

Can every sheet in a workbook print gridlines at once?

Group the sheets as shown above. If you use macros, you can also press Alt+F11, open the Immediate window with Ctrl+G, paste For Each ws In ActiveWorkbook.Worksheets: ws.PageSetup.PrintGridlines = True: Next, and press Enter. Change True to False to turn it off again.

Is there a shortcut to Page Setup?

Press Alt, then P, S, P in Windows Excel to open the Page Setup dialog. Its Sheet tab has its own Gridlines checkbox that does the same thing as the ribbon option.