MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Gridlines turned off permanently? I hate that.

Posted by Donny on August 02, 2001 10:01 AM

Being a creature of habit, I am used to working with my gridlines turned on. I recently received an excel file with no visible gridlines. I immediately went to Tools-Options-View, but the show gridlines box is checked. So I then checked the fill and it is set on no fill. No page breaks, colors or lines are used and I have turned all of these options on and off again. The worksheet and/or workbook is not protected. I saved as and that didn't help. I created a new workbook and copied the info into it and I have gridlines, but I don't want to have to copy every sheet over due to time and the loss of other formatting.

How did they do this? ... and more importantly ....
How would I turn them on again?

Thanks Donny

Posted by Cory on August 02, 2001 10:06 AM

Maybe they used conditional formatting. Select Format --> Conditional Formatting and if there's anything in there, then it may be what's keeping the grid lines to appear...

Just a guess...


Posted by Donny on August 02, 2001 11:21 AM

Good guess, but that's not it. Thanks for the reply though. I appreciate it.

Posted by Barrie Davidson on August 02, 2001 11:27 AM

Donny, what is the gridline colour set to (just under the gridlines checkbox in Tools|Options)? It should be set to Automatic (or whatever colour you desire).

Hopefully this is the problem.