← Previous Post
Next Post →

Colour in worksheet- how to change the colour of gridlines in excel.

Sid December 15, 2011 312
Colour in worksheet- how to change the colour of gridlines in excel.

Like everything else in Excel 2007, you can customize the color of gridlines in the workbook of excel 2007. By default the color of gridlines are assigned to “Automatic” color. To change the color of gridlines follow the following steps:

Instructions:

  1. Select the sheet from the excel workbook whose gridlines color you want to change. 
  2. Click on Microsoft Office Button   and then Click on excel options.    
  3. Click on “Advanced” and scroll down to “Display options for this workbook”                                                                                     
  4. Put a check mark on Show Gridlines if not already there. In the Gridline color box click on the color you want and click on Ok.

Note:  To change the color of gridlines of your excel 2007 workbook again to default, click on Automatic in gridline color box.

[Article View] : 2048

TAGS » , ,
POSTED IN » Microsoft

312 Comments »

  1. abhishek January 31, 2012 at 12:39 PM -

    excellent sid,

  2. automatic captcha solver July 28, 2012 at 8:42 PM -

    When I originally left a comment I seem to have clicked the -Notify me when new comments are
    added- checkbox and from now on whenever a comment is
    added I get 4 emails with the exact same comment. Is there
    a way you are able to remove me from that service? Cheers!

  3. Tunesien Ferien July 29, 2012 at 4:10 PM -

    Das könnte mir weiterhelfen. Habe aber auch
    lange danach gesucht.

  4. Miles August 14, 2012 at 10:59 AM -

    I love to visit your webblog, the themes have been nice.
    ,