Hide or show gridlines on a worksheet in Excel 2016 for Windows

Gridlines are the faint lines that appear between cells on the worksheet.

By default, gridlines are displayed, but you can also choose to hide them.

Worksheet in which gridlines are showing

Hide or show gridlines on a worksheet

  1. Select the worksheet or worksheets where you want to hide or show the gridlines.

    Note: Gridlines are always applied to the entire worksheet; they can't be applied only to specific cells or ranges. If you want to apply lines selectively around specific cells or ranges of cells, you can use borders instead of, or in addition to, gridlines.

  2. With the worksheet or worksheets selected, in the Show group on the View tab, do one of the following:

    • To hide gridlines, clear the Gridlines check box.

    • To show gridlines, select the Gridlines check box.

    Options in the Show group on the View tab

Top of Page

Things to keep in mind about gridlines

When working with gridlines, remember these points:

  • By default, gridlines are displayed in worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet by clicking Gridline color under Display options for this worksheet (File tab, Options, Advanced category).

  • People working in Excel often confuse gridlines with borders. Borders can be customized in many ways that gridlines cannot.

  • If you apply a fill color to cells on your worksheet, you won't be able to see or print the cell gridlines for those cells. To see or print those gridlines, remove the fill color by selecting the cells, clicking the arrow next to Fill Color Button image (Home tab, Font group), and then clicking No Fill.

    Note:  You must remove the fill completely. If you change the fill color to white, the gridlines remain hidden. To keep the fill color and still see lines that separate the cells, you can use borders instead of gridlines.

  • Gridlines, whether displayed or not, do not print by default. If you want gridlines to appear on the printed page, select the Print check box under Gridlines (Page Layout tab, Sheet Options group).

Top of Page

See Also

Insert or remove cell borders on a worksheet

Select one or multiple worksheets

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×