Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use Excel for form letter (2003)

    I would like to use Excel to produce a form letter instead of Word. I have not done this before so I'd like to find out how to create "fields" in excel that will allow the user to type in things like name, address etc. What is the best way to do this?

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Use Excel for form letter (2003)

    In Excel, you can specify in which cells a user can enter information. By default, all cells in a worksheet are locked, but this only becomes effective if you protect the worksheet. To create a form on a worksheet, you must take two steps:
    1. <LI>Select some or all of the cells that the user should be able to edit.
      Then select Format | Cells...
      Activate the Protection tab.
      Clear the check box labeled "Locked".
      Click OK.
      Repeat for other cells if necessary.
      <LI>Select Tools | Protection | Protect Sheet...
      Clear the check box labeled "Select locked cells".
      If you want to enable the user to do other things, such as formatting (unlocked) cells, tick the corresponding check boxes.
      If you wish, you can specify a password needed for unprotecting the worksheet.
      Finally, click OK.
    You may want to give the cells that can be edited by the user a different format than the rest, so that they stand out visually.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use Excel for form letter (2003)

    Thank you Hans. I'll give that a whirl.

Posting Permissions

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