How to Change the Color of the Gridlines in Excel

00_lead_image_change_gridlines_color

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.

01_clicking_file_tab

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

02_clicking_options

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

03_clicking_advanced

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.

04_selecting_gridline_color

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

05_gridlines_in_pink

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.