Choose from fixed data in a cell

[booiboa]

Hi folks,

I need to do a dropdown list in a specific cell with at least two values/strings to choose from.

For example:
The user can only choose between Yes or No in one cell.

Any suggestions guys?

// Bosse //

 

[saon]

select the cell you want.

select data>validation

select "list" in the dropdown box

write yes;no in the source box.

 

[inarbeth]

On 2002-11-08 04:54, saon wrote:
select the cell you want.

select data>validation

select "list" in the dropdown box

write yes;no in the source box.

Use a comma instead of a semi-colon in some versions of Excel.