How to Make Gridlines Darker in Excel 2016

Desktop Excel lets you change the gridline color for a worksheet. Open File > Options > Advanced, scroll to the display options for the current worksheet, and choose a darker Gridline color.

Change the worksheet gridline color

  1. Open the workbook in desktop Excel.
  2. Select File > Options.
  3. Choose Advanced.
  4. Scroll to Display options for this worksheet.
  5. Confirm that Show gridlines is enabled.
  6. Open Gridline color and choose a darker color.
  7. Select OK.

The setting applies to the selected worksheet, so another sheet in the same workbook can use a different gridline color.

Gridlines are not borders

Gridlines are visual guides around worksheet cells. If you need strong lines that print reliably or need different line weights around selected cells, apply cell borders instead.

Printing gridlines

Changing the on-screen gridline color is separate from choosing whether worksheet gridlines print. Use the Page Layout sheet options when you want gridlines included on paper or in a print-oriented output.

Although the original article refers to Excel 2016, the same general option remains available in current desktop Excel versions.

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy