Dropdown menus

Spencer25

Board Regular
Joined
May 3, 2006
Messages
76
Hi, can anyone tell me how to start a dropdown menu so that people wishing to enter into a cell only have a choice from a list provided. Thanks.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Use data --> validation.

For more info, try searching Excel help for "Designate valid cell entries"
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,455
Members
410,612
Latest member
MrACED
Top