why do gridlines disappear w/ excel 2007

[willowbranch]

PLEASE help me if you can!! I have never experienced this before I started using the new excel 2007.

Whenever I have a cell with a color for the background, & then I decide to get rid of the text & the color, my gridline goes away! I look at the top of my spreadsheet & notice that my gridline box is indeed clicked for "print" & "view".

What am I missing?????????? HOW do I get my gridline back?????

Thanks so much!!!!!

 

[schielrn]

How are you going about getting rid of the cell color? If you make the cell background white, it will get rid of the grid lines. You would want to make it no fill. I'm not sure what you are doing, but I just thought I'd ask this first?

 

[xenou]

do gridlines themselves have color too...which might be a hard one to see in this case...? Not sure...

Edit: Answering my own question, there is an option in XL03 to set the gridline color, so there must be one in XL07 too...

 

[willowbranch]

THANK YOU, Schielrn!!!!!!!!!!!!!!! That is what I was doing wrong! I NEVER thought to do the "no fill"! WOW, I feel sooo stupid!!! I spent over an hour trying to figure it out & I was just frustrated cuz I couldn't figure it out!

THANK you for taking your time to help me out!! This site is just incredible! NO, I should say, "Schielrn, you are incredible!!!!!

Thanks bunches!

Willowbranches

 

[schielrn]

do gridlines themselves have color too...which might be a hard one to see in this case...? Not sure...

Edit: Answering my own question, there is an option in XL03 to set the gridline color, so there must be one in XL07 too...

You can change the gridline colors in 2007 as well.