You could record a macro that changes this setting and just run it whenever you
want.

For new workbooks and new worksheets added to existing workbooks, you can create
a book.xlt and sheet.xlt in your XLStart folder.

Set up everything you want and when you click on the New icon, your new workbook
will inherit all the settings from Book.xlt.



JES wrote:

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


--

Dave Peterson