If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Gridlines in Excel Printouts
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. |
Thread Tools | |
Display Modes | |
|
|