Tuesday, March 15, 2011

Change Gridlines Color

By default Microsoft Excel have black colored grid lines. If we want to change the color of gridlines we may need to change them. Microsoft Office has improved Excel since 2003 and has changed added many features in 2007 and 2010 versions

Steps to add color to grid lines in Excel 2007: 

1) Click on Excel Icon on the top left of the window and click on Excel Options.


2) Choose Advanced option in the list of commands displayed over the left.


3) Go to the field that is named as Display options for this worksheet and click on drop down arrow of Gridline color.



4) Selecting a color from this will give us gridlines in the color we chose.


Here the color of the lines have been changed to burgundy. This is the way we can change the color of the grid lines in Excel 2007. It works in the same way even in the Office excel 2010 except for first step where we have File back stage option and options under it.

0 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More