Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / September 2003

Tip: Looking for answers? Try searching our database.

Make printing gridlines the default?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Graham - 04 Sep 2003 03:16 GMT
Excel 2002. I always want to print gridlines but each
time I have to go to Page Setup or Print Preview then
Sheet in order to check the Print gridlines option. Can I
enable printing gridlines as the default mode for all
worksheets? The screen view has the gridlines enabled.
Thanks, Graham
Paul Cundle - 04 Sep 2003 16:10 GMT
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 C,
Signature


> Excel 2002. I always want to print gridlines but each
> time I have to go to Page Setup or Print Preview then
> Sheet in order to check the Print gridlines option. Can I
> enable printing gridlines as the default mode for all
> worksheets? The screen view has the gridlines enabled.
> Thanks, Graham

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.