Specified fields

[Patsy Rogge]

Hi

Can you predefine options to fill in a cell. For example I only want people
to able to choose.

01 - Annual Leave
02 - Sick Leave
03 - Study Leave

Due to the fact it needs to be imported into another programs it needs to be
spelt exactly like that, so I would like to specify them up front.

Can anyone help
--
Patsy Rogge

[Dave Peterson]

You may want to try Data|Validation.

Debra Dalgleish has some notes to help you get started:
http://www.contextures.com/xlDataVal01.html

Patsy Rogge wrote:
>
> Hi
>
> Can you predefine options to fill in a cell. For example I only want people
> to able to choose.
>
> 01 - Annual Leave
> 02 - Sick Leave
> 03 - Study Leave
>
> Due to the fact it needs to be imported into another programs it needs to be
> spelt exactly like that, so I would like to specify them up front.
>
> Can anyone help
> --
> Patsy Rogge

--

Dave Peterson

[mudraker]

Patsy

Heres one way

Use Data Valadation

Somewhere in your sheet create a list of allowable items
Select column or row or cells whos entry's are to be valadated against the list
From Data Menu > Valadation > Settings Tab > Allow = List, Source = cells you entered your list into.

If you select column A to be valadated then whenever a cell in column A is selected then the user will be presented with a drop down box listing the allowable items. Selecting an item from the drop down box ipopulates the selected cell

[broro183]

Hi Patsy,
This can be done using Data Validation:
[alt + d + l], choose the Settings tab, select list, & enter
Annual Leave, Sick Leave, Study Leave
into the Source field.

btw, it is often wise to protect your sheet after applying data validation b/c if users paste over the cell the validation is wiped.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...