Can the visible gridlines on a sheet be removed?

T

Toby Erkson

Is there a way to remove all or just a section of the grid on a spread sheet? Not for printing, I know how to do that. I have several charts on a sheet but I
want the grid lines on the sheet to be non-visible so it looks like a blank sheet.
Toby Erkson
Oregon, USA
 
D

Don Guillett

highlight the area>format>patterns>fill color white

--
Don Guillett
SalesAid Software
[email protected]
Is there a way to remove all or just a section of the grid on a spread
sheet? Not for printing, I know how to do that. I have several charts on a
sheet but I
 
T

Toby Erkson

Holy cow do I feel stupid...that worked perfectly :)
Thanks,
Toby Erkson
Oregon, USA
 
D

Dave Peterson

Maybe you could just turn them off.

Tools|options|view tab|uncheck gridlines.

If you need boxes around cells, you may want to look at adding borders to your
ranges. You'll have more control over how it looks.
 
B

Bernard Liengme

How about Tools|options->View and uncheck the View Gridlines box?
Best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


Is there a way to remove all or just a section of the grid on a spread
sheet? Not for printing, I know how to do that. I have several charts on a
sheet but I
 
T

Toby Erkson

Thanks guys for that tip. Turns out the manager wanted some of them blanked out and not all.
Toby Erkson
Oregon, USA
 
Top