| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
set default header, footer, fonts for new sheet
Dear Friends,
Please help me to set default font, header, footer, etc when i open new worksheet in Excel 2007 Regards, Hardik |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set default header, footer, fonts for new sheet
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set default header, footer, fonts for new sheet
Do the same thing, but name the template workbook book.xltx.
Hardik Shah wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header fonts | Excel Discussion (Misc queries) | |||
| can you set a default header and footer for ALL worksheets? | Setting up and Configuration of Excel | |||
| How can you format a date in the header/footer of Excel sheet | Excel Discussion (Misc queries) | |||
| Excel - should be a defined Header footer section within the sheet | Excel Discussion (Misc queries) | |||
| How to save a custom header/footer on ea. sheet of a workbook? | Excel Worksheet Functions | |||
Linear Mode
