How do I make Print Gridlines the default?

D

D&D

It is annoying to have to go into PageSetup and click on that option every
time I want to print a sheet.
 
K

Kenji

Thanks to Joerd, there is a way. You overwrite or create a default XLT
file. Here's his text

----
You maybe need administrative rights, dependent on how your IT dept. setup
excel. What you get when you press the New button, is the workbook called
Book.xlt :
(quote XL HELP)
The Book.xlt template that you create when you want to change the default
format of new blank workbooks. Microsoft Excel uses the template to create
the blank workbook that opens when you start Microsoft Excel, or when you
click the New button on the Standard toolbar, or when you select the
Workbook template in the New dialog box (File menu). Unless you create the
Book.xlt template, Microsoft Excel bases the new blank workbook on built-in
program settings. You must store the Book.xlt template in the Xlstart folder
or in the alternate startup folder.

The Xlstart folder is in Root\OS\Profiles\User_name\Application
Data\Microsoft\Excel, where Root is a server location or a folder on a drive
from which all other folders branch (for example, C:\), OS is the operating
system folder (for example, Windows or Winnt), and User_name is your user
name. Or the XLstart folder is in Root\Program Files\Microsoft
Office\Office.
----

Good luck!

Kenjiro Yagi
http://www.spoofee.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top