How to Change Gridlines Color In Excel [Tutorial]

By default, gridlines are displayed in worksheets using the color that is assigned to Automatic. To change the color of gridlines, you can use the following procedure.

Issues addressed in this tutorial:
gridlines color excel
how to keep gridlines in excel when fill color
excel gridlines disappear when color added
excel show gridlines over fill color
excel show gridlines with background color
how to print gridlines in excel with color fill
change color of gridlines in excel chart
excel fill color covers gridlines
what color are excel gridlines

You can change the color of the default gridlines in Excel from the File tab, by selecting Options, Advanced. In the Display options for this worksheet section, click the Gridline color drop-down box and select a color from the color palette, as shown. (Make sure the Show gridlines check box is selected.)

This tutorial will apply for Microsoft Excel 2021, 2019, 2013, and 2010 for both Windows (such as Dell, HP, Lenovo, Samsung, Toshiba, Acer, Asus) and macOS (MacBook Air, MacBook Pro, MacBook Mini) devices.

свернуть