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 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 »