How can i set default headers and footers?

M

Mr P Lamphee

I am trying to to set to default the headers and footers on all excel sheets
to try and save time having to set them up everytime i start a new sheet.
How can i do this?
 
J

Jim Rech

Create a workbook that has everything you want to have in each future new
workbook. Then save it as "BOOK" to your XLSTART folder, changing the file
type to Template (Excel will assign the XLT extension).

To have each new inserted worksheet customized create a single sheet
workbook and save it as above but with the name SHEET.

--
Jim Rech
Excel MVP
|I am trying to to set to default the headers and footers on all excel
sheets
| to try and save time having to set them up everytime i start a new sheet.
| How can i do this?
 
G

Gary Rowe

You can select all the sheets in the workbook and then set the header/footer
for all the sheets at the same time. If your left most sheet in your
selection of sheets has the header/footer set then you can simply click on
page setup and hit enter and your new sheet will inherit the same settings.
 
P

Paul B

You could set a sheet up like you want and save it as a template and use it
each time.

Or to set up excel so when you open it the headers will be set up, set the
workbook as you want it ( headers, footers, margins, number of sheets, cell
formats, gridlines to print, etc). Now Save As, and change the file type to
"Excel Template (.xlt)" not (.xls).



Locate your XLStart folder, typically somewhere like "C:\Program
Files\Microsoft Office\Office\XLStart\", and save the file as book. Excel
will add the .xlt for you



Every time you open a new workbook from now on (you may have to restart
Excel first) this template will be used. To revert back to the original,
just delete this file.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
 
Top