Creating a list in a cell

  • Thread starter Thread starter Vicent Giner
  • Start date Start date
V

Vicent Giner

Hello.

This is my first message to this group.

I just want to create a cell whose content is restricted to the items
or values in a list. The list would be static, and it wouldn't be a
problem to fill the list by hand, as it is not expected to contain
much many items.

The user then could go to the cell and simply select one of the values
in the list, by means of a drop down control or similar.

Is there any standard option in Excel to do that? I tried something
called "lists", but it doesn't work as I would like.

Thank you very much in advance!!
 
Hi Vincent

Select the desired cell, then goto Data > Validation > Allow : select
"List" > Source : Enter the items seperated by comma > OK

You can also enter the items in an unused column in the sheet and then
in source you should enter the range containing the list.

Hopes it helps.

Regards,
Per
 
Hello.

This is my first message to this group.

I just want to create a cell whose content is restricted to the items
or values in a list. The list would be static, and it wouldn't be a
problem to fill the list by hand, as it is not expected to contain
much many items.

The user then could go to the cell and simply select one of the values
in the list, by means of a drop down control or similar.

Is there any standard option in Excel to do that? I tried something
called "lists", but it doesn't work as I would like.

Thank you very much in advance!!
Click to expand...

Hello Vicente!!
Press F1 in excel when you get the excel help copy this "Create a drop-
down list from a range of cells" and paste it, this will take you step
by step how to do what are you looking for:
Pantera!!
 
Hi Vicent

Have a look at Data... Validation... and select List from the Allow options.

HTH
Best rgds
Chris Lav
 
Back
Top