K
kevs
Anyway to have the gridlines box checked permanently, so I don't have to do
it every time I go to print? Thanks!
OS 10.3.4
Office 2004
it every time I go to print? Thanks!
OS 10.3.4
Office 2004
J
JE McGimpsey
kevs said:
Sure - create a new workbook. Check the gridlines checkbox and save the
file as a template named Workbook in your XLStart folder.
K
kevs
It worked, but I already have workbook in start up folder (without the .xls
by the way), so I opened it and checked gridlines and hit command S.
But then instead of just saving it, I had to overwrite the "old" file and
navigate to it etc. It worked out, but was cumbersome. Why didn't excel
just let me save workbook with my new change?
OS 10.3.4
Office 2004
J
JE McGimpsey
kevs said:
When you opened the template, didn't it create a copy of the file (e.g.,
a file named Workbook1, not Workbook)? That requires overwriting the
original.
K
kevs
Actually, no it does not create a new file, just says workbook in title bar.
OS 10.3.4
Office 2004
J
JE McGimpsey
kevs said:
Hmm... then I'm not sure why you had to overwrite it.
B
Bernard Rey
kevs wrote :
If it's a template, as it should, it's not ".xls" it should be without, but
".xlt", which is the usual extension for the templates.
Because it creates a new workbook, that's what templates are designed for.
If you save it as a "standard" workbook in the "Startup" folder, it'll open
when launching (but would be saved and keep every changing you'd make if you
click the "Save" option (or "Command-S"). And not when creating a new. From
your description, I'm afraid this is what you did.
If you want your gridlined workbook to be the default workbook, thus having
a copy of it each time you create a new workbook, it has to be "Saved as..."
a template with the name "Workbook" (without the ".xlt" extension) in the
startup folder. Just as it is described in the Helpfile (search for
"customizing workbook template" for instance)...
If it's a template, as it should, it's not ".xls" it should be without, but
".xlt", which is the usual extension for the templates.
Because it creates a new workbook, that's what templates are designed for.
If you save it as a "standard" workbook in the "Startup" folder, it'll open
when launching (but would be saved and keep every changing you'd make if you
click the "Save" option (or "Command-S"). And not when creating a new. From
your description, I'm afraid this is what you did.
If you want your gridlined workbook to be the default workbook, thus having
a copy of it each time you create a new workbook, it has to be "Saved as..."
a template with the name "Workbook" (without the ".xlt" extension) in the
startup folder. Just as it is described in the Helpfile (search for
"customizing workbook template" for instance)...