How to Change the Color of the Gridlines in Excel


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.

Lori Kaufman is a writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.