pull down selections for cells

[Cloud Chaser]

I am running Excel 2000 and I need to create a pulldown selection for certain cells in my worksheet. I have seen these before, but do not know the actual function name or where to find it in the menu. I want to be able to click onto a cell and have a down arrow appear which would then give me a list of choices from which I could choose from to populate that cell. For example: if I want my cell to indicate "position orientation" the pulldown selection may have "center oriented", or "front offset", or "rear offset" as the selections to choose from. So when I click onto the cell, a down arrow would appear, which I would click on and these three selections would appear from which I could choose. Anyone know the name of that function and where I can find it.

Thanks

[Bigbrit]

Try using Google, this was the first hit.

Google search criteria:= Excel dropdown menu

http://www.excel-vba.com/excel-drop-down-lists.htm

http://www.google.com/search?hl=en&q=excel...G=Google+Search

Hope this helps.

Google is a wonderful resource, try it ??

[spacesurfer]

It's actually not a "function" like the "if" and "sum" functions.

What you're looking for is Data Validation. It's in the Data menu under Validation.

It's not straightforward how to do it in Excel but what you have to do is type the content of the pull down in different cells. For example, if you want five items in drop down, such as item 1, item 2, item 3, item 4, and item 5, then type that is cells, say F1, F2, F3, F4, and F5.

then click on the cell were you want the pull down menu, say cell C2. Then go to data validation. then click on "LIST" under allow. Then choose the range, e.g. F1 to F5.