Wednesday, April 23, 2008

How do I change the colour of Excel's grid lines?


Above you see Excel sheets with pink gridlines and green gridlines. How do you do that? Watch the screencast below or scroll down for text instructions.




To change the colour of your gridlines, click on the Office Orb and select Excel Options from the bottom right corner of the menu.


With Options now open, locate the Advanced option as shown on the left-hand side of the menu.


Scroll down the page until you come to Display Options. Here you will find a Gridlines colour picker. You can choose to apply the colour to any sheet in your workbook .... you can even have a different colour on each page.



Click OK and you are done. That's all that there is to it.

To change it back to the default, repeat the steps Excel Options > Advanced> Gridline Colour and this time select "automatic" on the colour picker.

3 Comments:

Anonymous said...

Great I love it! It’s a pity that I didn’t come across the site earlier. So far I've always inform me about excel functions on the following site http://www.excel-aid.com/excel-gridlines-printing-gridlines-column-and-row-headers.html

Antony Christ said...
This comment has been removed by the author.
Antony Christ said...


It was nice to read your blog. Are you in need of professional assignment helpers? Well! You have reached the right place at My Case Study Help.Com where you receive a one-stop solution.We offer one of the finest MBA Project Management Case Study Assignment Help for students' benefits. We have more than 5000 professional Case Study Writer experts to support students in doing their university projects. We provide assured quality and credibility. That's why a majority of students trust our Assignment Help.