You may not have thought about the color of the gridlines in Excel before, but if you’re bored with the default gray color or you want to use a color that’s easier on your eyes, you can change the color of the gridlines.

To select a different color for the gridlines on a worksheet in the current workbook, click the “File” tab.

On the backstage screen, click “Options” in the list of items on the left.

On the “Excel Options” dialog box, click “Advanced” in the list of items on the left.

In the “Display options for this worksheet” section, click the button next to “Gridline color” and select a color from the palette that displays. Make sure the “Show gridlines” check box is selected.

NOTE: The gridline color can be different for each worksheet in the current workbook. The currently selected worksheet is the default choice in the drop-down list to the right of the section title. If you want to change the gridline color for a different worksheet, select that worksheet from the drop-down list.

The gridlines on your worksheet now display in the chosen color.

To return to the original, default gray color for the gridlines, go back into the options and select “Automatic” on the “Gridline color” palette.

Profile Photo for Lori Kaufman Lori Kaufman
Lori Kaufman is a technology expert with 25 years of experience. She's been a senior technical writer, worked as a programmer, and has even run her own multi-location business.
Read Full Bio »