SEARCH

How-To Geek

Change The Gridlines Color in Excel 2007

Like everything in Excel, you can customize the way your worksheet looks by changing the color of the gridlines to something festive.

Click the Office Button and Choose Excel Options. 

4 

Choose Advanced in the Excel Options Menu.

 5

Scroll down to Display options for this worksheet, check Show gridlines, and choose a new color.  If you do not want gridlines at all just uncheck the Show gridlines box. 

6 

In this example I choose red.  This tip comes in handy if your looking for a better way to emphasis the grid layout.

7

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 06/24/07

Comments (6)

  1. kimily

    Thanks for this article´╝ü

    I have learn how to show or unshow the gridlines, this is so important for me .

  2. Ashley

    THANK YOU SO MUCH!!! I have been wondering how to do this since I got it in 2007! I always HATED that the blue gridlines weren’t very visible!!! Again, Thank You for posting this!!!

  3. Janice

    How do you get all future spreadsheets to open with the new color change.

  4. Mike

    How can I restore gridlines from cells that I had content deleted?

  5. Andy

    Heeeeelp! After changing a “table” back to a normal range I can not see my grid lines. I have tried back ground color and amending the line color through the advanced button in excel 2007 but I still can not retrieve the grid lines. My original data table is 200 line long and I do not wish to re-write it . Can you help me How to Geek

  6. Mark

    loaded 2007 into new computer OS Win7 Pro and checked “show grids” and made grids black in “advanced settings”…still no grid lines!! HELP!! under a time crunch!!

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!