How To Print Gridlines In Excel
+ How To Add And Edit Them Too!

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

You probably don’t think about Excel’s gridlines very often?

They’re there, they separate cells, and that’s it.

But sometimes you want to make some tweaks 🙂

Like adding gridlines to your print of a document. Or changing the color.

No matter what you’re trying to do with your gridlines, here’s how you do it!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

Printing gridlines

Even though Excel’s gridlines are displayed by default on your screen, they default to “off” when it comes to printing.

And that can be annoying.

To print gridlines in Excel, open the Page Layout tab of the Ribbon.

In the Sheet Options section, under Gridlines, add a check next to Print:

print-gridlines

Now, when you print your document, you’ll see gridlines on the paper.

To make sure your gridlines are going to print, head to File > Print and check out the print preview:

print-preview

If you see gridlines in the preview, you’ve successfully turned them on for printing!

Kasper Langmann, Co-founder of Spreadsheeto

Displaying and hiding gridlines

Excel’s workbooks have gridlines turned on by default. But if you want, you can turn them off.

To do that, open the View tab in the Ribbon.

In the Show section of the tab, remove the checkmark next to Gridlines:

show-gridlines

Once you’ve unchecked that box, the gridlines will disappear:

no-gridlines

Looks a little strange, doesn’t it?

Kasper Langmann, Co-founder of Spreadsheeto

To activate gridlines, add a checkmark to that same box.

(Note: you can also activate or deactivate gridlines from the Page Layout tab; just select or deselect Show in the Gridlines section.)

Changing the color of gridlines

Normally, gridlines are a medium-grey color. But you can customize that if you like.

Go to File > Options > Advanced, then scroll down until you find the Display options for this worksheet section:

display-options-worksheet

At the bottom of this section, you can choose a new color for your gridlines:

gridline-color

Select a new color, and your gridlines will no longer be that boring grey!

Kasper Langmann, Co-founder of Spreadsheeto

Gridlines disappeared? Start here

If your gridlines have disappeared and you can’t figure out how to get them back, there are a few things that might help.

First, make sure that your gridlines are turned on. You can check this in the Page Layout or View tabs. If you’re not sure where, check out the sections above.

Next, make sure your cells don’t have a fill color. If they’re filled white, the gridlines will be colored over. Choose No Fill instead.

no-fill

Next, make sure your borders aren’t white. Select all the cells that don’t have border, then right-click and select Format Cells > Border.

If the color is set to white, change it back to Automatic.

automatic-border

Finally, go to File > Options > Advanced and make sure your gridlines haven’t been colored white (this is also detailed above).

One of these tactics should work to get your gridlines back if they’ve disappeared.

Kasper Langmann, Co-founder of Spreadsheeto

Tweak your gridlines with ease

Excel is all about presenting information as efficiently and effectively as possible. And gridlines are a part of that, too.

Now that you can display, hide, print, and tint your gridlines, you never have to settle for sub-par displays again!

Interested in learning even more about printing your spreadsheets?

Check out this (huge) guide!