I go to tools, option and view tab but when i get to the view tab there is no drop down bar for me to change the colour even if the spreadsheet is high-lighted. Is this the right way to change the gridline colour in the first place and how do i do it?How to change the colour of gridlines on microsoft excel 2003?That is indeed the right way to change the default style of your gridlines. I've tried to get mine (excel 2000) to grey out but with no success. Is it possible that someone has put in VBA code that disables that part of the menu? Or perhaps in the 2003 version the sheet must be unprotected?
Try using %26gt; Detect and repair, accessed through the Help menu. It might reset your menus for you.
Of course, you can change the appearance of table borders by going to %26gt; format %26gt; cells %26gt; borders, but that won't change the background gridlines.How to change the colour of gridlines on microsoft excel 2003?try format - cells - boarders - lower right corner is color option. How to change the colour of gridlines on microsoft excel 2003?Go to Tools %26gt; Options %26gt; View. In the lower left corner there should be a checkbox for Gridlines. Below that should be a dropdown menu to change the color of the gridlines for the whole sheet.
This is the correct way to change the gridlines.
Are those options missing from your Tools Options?
