set default header, footer, fonts for new sheet

[Hardik Shah]

Dear Friends,

Please help me to set default font, header, footer, etc when i open new
worksheet in Excel 2007

Regards,

Hardik

 

[Shane Devenshire]

Hi,

1. If you really want this for new sheets and not new workbooks, then Open a
blank file and make all the change you want the new files to have. Delete
all the sheets Except Sheet1.
2. Do Office Button, Save As and name the file Sheet
3. Change the Save as Type to Excel Template (*.xltx)
4. Save the file in the \XLStart folder

This folder is usually in C:\Program Files\Microsoft Office\Office12
but you may need to search for it.
Now anytime you insert a new sheet in your workbook this will be used.

 

[Hardik Shah]

Can you please help for new workbook also?

Thanking you in advance for the same.

Regards, Hardik

 

[Dave Peterson]

Do the same thing, but name the template workbook book.xltx.