Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create template fields? | Excel Discussion (Misc queries) | |||
How to create a histogram that updates when I filter the input ran | Excel Worksheet Functions | |||
how do i input customer information and results of meeting | Excel Worksheet Functions | |||
How do i create a template | Excel Discussion (Misc queries) | |||
How do I create a template in Excel? | New Users to Excel |