set default header, footer, fonts for new sheet


H

Hardik Shah

Dear Friends,

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

Regards,

Hardik
 
Ad

Advertisements

S

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.
 
H

Hardik Shah

Can you please help for new workbook also?

Thanking you in advance for the same.

Regards, Hardik
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top