Learn How to Change Colour of Excel Gridlines
Have you ever wondered if you could change the colour of the Gridlines in Excel worksheets?
By default, the gridlines displayed in the worksheets are light grey. Users can easily change the gridlines to a different colour by following below steps:
Open the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and Excel 2013 click the File tab of the ribbon and then click Options.
Click Advanced on the left side of the dialog box.
Scroll through the options until you see the Display Options for this Worksheet section.
Make sure the Show Gridlines check box is checked.
Using the Gridline Color drop-down list, choose the color you want to use. (In this example, I have selected Blue for illustration purposes)
Click OK.
Check sample results below.
Hope you find this tutorial helpful!
