View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JES
 
Posts: n/a
Default Can I set gridlines in excel as a default setting? How?

Thanks, I already have the gridlines showing on screen but what I actually
meant to ask was how do I set it up to automatically print the gridlines for
my worksheets?

Any idea?

Thanks

"Dave Peterson" wrote:

Existing worksheets, too?

I don't think so. But you could make your life somewhat easier by adding an
icon to your favorite toolbar that toggles the gridlines.

Tools|Customize|Commands tab|Forms Toolbar
Look for Toggle Grid near the bottom
Drag it to a nice location.

Then just click that button to toggle the gridlines the way you want.

ps. I usually turn off the gridlines. I'd rather use borders. I have more
control over what they look like.

JES wrote:

I understand how to set the gridlines for each individual worksheet but is it
possible to change the default settings so that all worksheets have gridlines
automatically?
If so, how?


--

Dave Peterson