+ Reply to Thread
Results 1 to 3 of 3

create template with certain fields to input information only

Hybrid View

  1. #1
    Annette
    Guest

    create template with certain fields to input information only

    I am looking to create a template inwhich we can tab to each field to enter
    in the information and have the rest of the document read only. This is
    actually a mortgage prequalification worksheet that I am trying to create and
    I only want the fields that need information to be open an available.

  2. #2
    Miguel Zapico
    Guest

    RE: create template with certain fields to input information only

    You can protect the worksheet, and unlock only the cells that you want the
    users to fill (this will allow the Tab navigation automatically).
    To unlock a cell, select the cell and go to Format->Cell->Protection, and
    clear the box Locked. Do this before protecting the worksheet.

    Hope this helps,
    Miguel.

    "Annette" wrote:

    > I am looking to create a template inwhich we can tab to each field to enter
    > in the information and have the rest of the document read only. This is
    > actually a mortgage prequalification worksheet that I am trying to create and
    > I only want the fields that need information to be open an available.


  3. #3
    aidan.heritage@virgin.net
    Guest

    Re: create template with certain fields to input information only

    on each cell you want to be able to input items, use the format cells
    option and set the protection to UNLOCKED. Once all cells are done,
    use the tools menu to protect the worksheet - job done.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1