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

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