Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a work book
How do I go about creating a work book in XL from a template? I need to keep
invoices & day books but dont want to re-do a different spread sheet each time, I guess there must be an automatic way to acheive this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a work book
Open a new workbook.
Format and set it up the way you like, including number of sheets, formulas, Titles and all other stuff you want to see. When you get it as you like ready for data input FileSave AsFile TypeExcelTemplate(*.XLT) Nmae it whatever you wish. Like yourname To use this Template, hit FileNew...TemplateOn my Computer. Select your Template and it will open as yourname1.xls The workbook is based upon the Template and the Template does not get altered in any way. When you have entered all data, save the workbook as yourname1 or any name you desire. Gord Dibben MS Excel MVP On Tue, 20 Jun 2006 15:03:02 -0700, Celtman wrote: How do I go about creating a work book in XL from a template? I need to keep invoices & day books but dont want to re-do a different spread sheet each time, I guess there must be an automatic way to acheive this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink that are relavant to a work book not a computer | Excel Worksheet Functions | |||
my excel work book is NOT read onlyt says it is when saving to CD | Excel Discussion (Misc queries) | |||
it says "disk is full" when I try to save my excel work book | Excel Discussion (Misc queries) | |||
I was messing arround with the VBA and now I get the macro warning when I open the work book but when... | New Users to Excel | |||
Creating a new chart- why Set NewChart = Charts.Add doesn't work? | Charts and Charting in Excel |