Do the Excel grildine color not match the look-and-feel of your application, or are you just bored of the classic gray colors? Even though you can use border coloring to change those colors, there is an even better way to do this without applying a formatting to all cells. In this article, we are going to show you to make Excel change gridline color to your liking in Excel 2016, 2013, 2010, and 2007.
Steps
You can find the Gridline color setting in advanced options of Excel. Let's see how you can access the setting.
- Open the Options window from File > Options.
- Activate the Advanced tab.
- Scroll down to the Display options for this worksheet section.
- Select the worksheet you want to apply the new grid color. The Gridline color setting is at the end of this section.
- Select the color you want, and click OK to apply the new color.
Things to consider
That's all! However, we should take a look at a few considerations when using this feature.
The first one is the Show Gridlines option. Obviously, you cannot see the coloring if you hide the gridlines. This option should be checked to be able to see the gridlines.
The second one is that you need to a worksheet. The Gridline color setting affects only selected sheet(s). Thus, you need to check the target sheet(s) first.
Finally, please note that there are certain limitations to the colors you can select. Excel essentially gives you 55 colors to choose from, including those that come with the Automatic type, which is the default gridline color.
Tips
You can also include the gridlines in your printed documents. For more information on how to do this please see: How to print gridlines in Excel. The color of the grid will apply the printed document automatically.