Microsoft Excel lets you customize the way your worksheets look to improve their appearance. Changing the color of Gridlines is just another way to make Excel data more attractive and less boring.
Open Microsoft Excel and go into Excel Options. In Office 2007 click the Office button >> Excel Options >> Advanced.
In Excel 2010 click the File Tab >> Options >> Advanced.
Scroll down in Advanced Options menu to Display Options for this Worksheet. Check the Show Gridlines option (if not checked) and select the color you want. Click Ok when done.
That’s it. Here is an example of an Excel chart where I changed the Gridlines to the color orange.
In my Excel 2010 “Excel options” do not exist
“Options” menu can be accessed from the file menu, advanced options are listed once you access “Excel Options” from the file menu. “Display” options will be visible once you scroll down on advanced options.