I have a lot of preferences for viewing and printing with Excel. I got tired
of manually setting these all the time so I made a bunch of macros and
linked these to custom menus and/or toolbar buttons. For example, a button
to toggle the row/column heading and gridlines on or off, set my preferred
options for printing (footer, header, margins, etc).

You can do the same. Then when you want to print, just click the appropriate
button to have the grid lines printed. It'll be a good way to learn how to
write and use macros.



"Joe Fisher" wrote in message
...
Is there a way to make the default spreadsheet open with the "print
gridlines" box checked?
I've tried going to File-Page Setup-Sheet-Print gridlines, then doing
Save As, saving it as a template. But it doesn't "stick"

I usually use Excel making lists, etc. Often at school especially I want
to print the SS out. I invariably will forget to print the gridlines, so I
waste a sheet of paper (or more) by the time I remember. I'd like to make
this the default.


--
Joe Fisher
Teacher, K-8
Marion, MT