This is a happy little feature that was added in Excel 2007. Now you have the ability to change gridline colors in Excel 2007.
To do so, follow these steps:
Click on the "Office" button and click on the "Excel Options" button.
Select the "Advanced" tab from the left menu and scroll to the "Display Options for this Worksheet" area. The gridline color option is located in the second section of "Display Options."
Click on the drop down to select a color. Choose any color you want.
Click on the "OK" button to save the changes and exit the "Excel Options" window.
The gridline colors are now as you selected.
HINT: This may be helpful for situations where you have changed the background color to something light blue; thus, making the gridlines non-viewable.
Here's the caveat: only the selected worksheet is changed. To change each sheet, you must select each sheet name from the drop down by the "Display Options" header and then change its corresponding color.
NOTE: Each new worksheet will display the gridline colors as the default light blue color. You are not changing the default by selecting this option.
It's that simple to change gridline colors in Excel 2007.
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
Since 1998, Google has been giving us Google Doodles. The first Google Doodle was in honor of the Burning Man Festival . It wa...