Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Different Formats for Multiple Sheets within a Workbook
Hi
I would like to set up a template where formatting for Sheet1, Sheet2, and Sheet3 of the Workbook are standardized, but each Sheet's format differs from the others. Can this be done? Thanks. |
#2
|
|||
|
|||
Save the formatted file as a template (.xlt). To open the template use the
File menu. (File,New and select the sheet from the Spreadsheet solutions tab). SAve the file as a normal spreadsheet when you have entered data and use the template when you want to create a similar file. Regards Peter "ns" wrote: Hi I would like to set up a template where formatting for Sheet1, Sheet2, and Sheet3 of the Workbook are standardized, but each Sheet's format differs from the others. Can this be done? Thanks. |
#3
|
|||
|
|||
ns
Method to ensure that every New workbook is based on your Template if that is your desire......... Create the workbook as you wish then save as a Template. Store this Template as BOOK.XLT in your XLSTART folder. Now in ToolsCustomizeCommandsFile you will find two "New" buttons. One is New...(note the ellipsis). This will bring up the Taskpane and its options for "Blank workbook" or "Templates" which forces you to scroll to your Template and click on that. The other is New with no ellipsis. This one will insert a new workbook based on your Template from the XLSTART folder. Gord Dibben Excel MVP On Sat, 21 May 2005 16:58:01 -0700, "PeterAtherton" wrote: Save the formatted file as a template (.xlt). To open the template use the File menu. (File,New and select the sheet from the Spreadsheet solutions tab). SAve the file as a normal spreadsheet when you have entered data and use the template when you want to create a similar file. Regards Peter "ns" wrote: Hi I would like to set up a template where formatting for Sheet1, Sheet2, and Sheet3 of the Workbook are standardized, but each Sheet's format differs from the others. Can this be done? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Link 2 Sheets with different formats | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Copy with link between sheets - all the formats dissapear?!? | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) |