Can I set gridlines in excel as a default setting? How?

J

JES

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?
 
D

Dave Peterson

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.
 
J

JES

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
 
D

Dave Peterson

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.
 
J

JES

Hi Dave,

Thanks for the suggestions but unfortunately your explanation was like
having a conversation with the teacher from Charlie Brown! Sorry, I'm just
not that technical!!

Thanks anyway
 
D

Dave Peterson

Open excel.
Hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)
type this and hit enter:
?application.startuppath
Make a note of the drive/folder that comes back.

Now back to excel and create those workbooks exactly the way you want them. But
save each as a template (book.xlt and sheet.xlt) in that folder.

It's not too bad to do.
Hi Dave,

Thanks for the suggestions but unfortunately your explanation was like
having a conversation with the teacher from Charlie Brown! Sorry, I'm just
not that technical!!

Thanks anyway
Click to expand...
 
Top