Excel question

[nickj]

Hi,

Does anyone know how to format a cell so that when clicked on it gives a list where people can only select one of the items in the list.

Cheers

[thor]

I think it's data->validation, then you can say that the contents of the cell can only be that of a set values that you link to. There should be an option for a drop down menu.

[nickj]

Cheers Thor

I've been trying to do that for over an hour now!!!

[thor]

No worries!