• Go Ask Debbie

Change Gridline Colors in Excel

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.


Recent Posts

See All