How to make this Excel combo box as the atached?

[zhengmin1]

In the attached file, when a cell (any cells lower than A2) is clicked
a "combo box"(?) pops out to let people to select a item form the list
What is function name, how to make it? Please be ware the A1, A2 don'
have the feature.
th

Attachment filename: box.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51145

 

[Frank Kabel]

Hi
have a look at 'Data - Validation'. See
http://www.contextures.com/xlDataVal01.html
for more details