View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Hardik Shah Hardik Shah is offline
external usenet poster
 
Posts: 12
Default set default header, footer, fonts for new sheet

Can you please help for new workbook also?

Thanking you in advance for the same.

Regards, Hardik

"Shane Devenshire" wrote:

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