Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: template

  1. #1
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi!

    I have a worksheet that has formulas and data
    already in it. I want to make a template out of it, so that the formulas stay and the
    data is cleared out. I will then use this
    template at the beginning of each fiscal year to create a clean worksheet.

    Can you help me with this? Or tell me where to get info on this?

    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, Ok Open up the worksheet and go to file click on save as and on the on the save as drop down menu under the enter file name on it select template specify the directory you want it in and volia your done if anyother help please ask sorry if this sounds a bit incoherent

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can save it as a template. File, Save as, and when the save window pops up, change the save file to "template".

    To open it go to File, New, and open your template.

    I hope this is what you were looking for.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Design as required and then save as XXXX.xlt thats the excel extention for template

    now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

    HTH
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Design as required and then save as XXXX.xlt thats the excel extention for template

    now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

    HTH
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Design as required and then save as XXXX.xlt thats the excel extention for template

    now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

    HTH
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Design as required and then save as XXXX.xlt thats the excel extention for template

    now re save as theExcelSheet.xls and work on this sheet all formula wil be blank and active in xls as reqd per your design of the xlt.

    HTH
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    I saved it as a template. But when I look at it it stills has the values that were there originally. The problem is if I clear out the cells the formula is cleared out too.

    What do I do?

    Thanks, HunterN

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't clear the cells containing the formulas. Clear the cells the formula reads.......

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    You need to make a blank template that carries in the formulas req but no data
    and work from there,

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •