Specified fields

P

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
 
M

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
 
B

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...
 
Top