Show or hide gridlines on a worksheet in Excel 2016 for Mac

Gridlines are the faint lines that appear around cells. They are used to distinguish cells on a worksheet. When working with gridlines, consider the following:

  • By default, gridlines are displayed on worksheets using a color that is assigned by Excel. If you want, you can change the color of the gridlines for a particular worksheet.

  • People often confuse borders and gridlines in Excel. Gridlines cannot be customized in the same way that borders can.

  • If you apply a fill color to cells on a worksheet, you won't be able to see or print the cell gridlines for those cells. To see or print the gridlines for these cells, you must remove the fill color. Keep in mind that you must remove the fill entirely. If you simply change the fill color to white, the gridlines will remain hidden. To retain the fill color and still see lines that serve to separate cells, you can use borders instead of gridlines.

  • Gridlines are always applied to the entire worksheet or workbook and can't be applied to specific cells or ranges. If you want to selectively apply lines around specific cells or ranges of cells, you should use borders instead of, or in addition to, gridlines.

Show gridlines
  1. Select the worksheet.

  2. Click the Page Layout tab.

  3. Under Gridlines, select the View check box.

Hide gridlines
  1. Select the worksheet.

  2. Click the Page Layout tab.

  3. Under Gridlines, clear the View check box.

See Also

Print cell gridlines

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×