![]() |
Creating templates from existing forms
How do I take a perfect spreadsheet and make it a template. I have created a
spredsheet that has all of the data I need in my template, so I don't want to recreate the wheel. |
Hi
choose file / save as under files of type choose template ... it should automatically go to the correct folder to access it choose file / new - if you're using ver 97/2000 you should see your template if you're using ver 2002/2003 you will probably have to click on "On my computer" - under "new from template" on the task pane (i think the wording is slightly different for 2002 & 2003 ) Cheers JulieD "Marinasun" wrote in message ... How do I take a perfect spreadsheet and make it a template. I have created a spredsheet that has all of the data I need in my template, so I don't want to recreate the wheel. |
Hello
File, Save As, File Type = Template (*.xlt) HTH Cordially Pascal "Marinasun" a écrit dans le message de news: ... How do I take a perfect spreadsheet and make it a template. I have created a spredsheet that has all of the data I need in my template, so I don't want to recreate the wheel. |
Filesave as*.xlt
Regards, Peo Sjoblom "Marinasun" wrote: How do I take a perfect spreadsheet and make it a template. I have created a spredsheet that has all of the data I need in my template, so I don't want to recreate the wheel. |
One more option.
Mark it readonly in windows explorer. Then just open it and save it as a new name whenever you need a new workbook. (You don't actually need to mark it readonly, but it might be a tad safer that way.) Marinasun wrote: How do I take a perfect spreadsheet and make it a template. I have created a spredsheet that has all of the data I need in my template, so I don't want to recreate the wheel. -- Dave Peterson |
All times are GMT +1. The time now is 10:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com