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.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Hardik Shah" wrote:

Dear Friends,

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

Regards,

Hardik