Gridlines in Excel Printouts

With Excel 2000, if you want grid lines to print on every
printout of every worksheet do you have to specify that as
a default? And if so, how do you specify gridlines as
defaults?


Thx.

From a post by: Paul Cundle
Set up a workbook as you want it (number of sheets, cell formats etc) and
turn on gridlines in Page Setup.
Now Save As, and change the file type to "Excel Template (.xlt)" not (.xls).
Locate your XLStart folder, typically somewhere like "c:\documents and
settings\username\application data\microsoft\excel\xlstart\" and save the
file as "book.xlt"

Every time you open a new workbook from now on (you may have to restart
Excel first) this template will be used - including the gridline settings.
To revert back to the original, just delete this file.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"LPS" wrote in message
...
With Excel 2000, if you want grid lines to print on every
printout of every worksheet do you have to specify that as
a default? And if so, how do you specify gridlines as
defaults?


Thx.