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...
Cory
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.
Donny
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.
Regards,
Barrie
