T
Tony
Does anyone know if you can set a default header, footer, and if you can set
the gridlines to a specific color? Thanks in advance.
the gridlines to a specific color? Thanks in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Tony -
search in the help file for templates.
What you will need to do is create a new file, empty except for the things
you want to have 'standard' or default in your files. Once set up the way
you want it, save it as a template. If you save it according to the help
file instructions, you'll have the option to base new workbooks on your
template when you choose File>New
search in the help file for templates.
What you will need to do is create a new file, empty except for the things
you want to have 'standard' or default in your files. Once set up the way
you want it, save it as a template. If you save it according to the help
file instructions, you'll have the option to base new workbooks on your
template when you choose File>New
T
Tony
Do you if there is a way to automatically have this template come up
everytime excel is opened by default? Thanks
everytime excel is opened by default? Thanks
G
Gord Dibben
Tony
Be careful what you ask for......you may get it<g>
If you want that workbook to automatically open when you start Excel, save it
as a workbook, not a Template.
Store it in your XLSTART folder and it will open when you start Excel.
Note: if you open Excel by double-clicking on another *.xls file, you will get
both files opening.
Gord Dibben Excel MVP
Be careful what you ask for......you may get it<g>
If you want that workbook to automatically open when you start Excel, save it
as a workbook, not a Template.
Store it in your XLSTART folder and it will open when you start Excel.
Note: if you open Excel by double-clicking on another *.xls file, you will get
both files opening.
Gord Dibben Excel MVP
T
Tony
That worked great thanks for the help!
Gord Dibben said:Tony
Be careful what you ask for......you may get it<g>
If you want that workbook to automatically open when you start Excel, save it
as a workbook, not a Template.
Store it in your XLSTART folder and it will open when you start Excel.
Note: if you open Excel by double-clicking on another *.xls file, you will get
both files opening.
Gord Dibben Excel MVP