Creating a drop down menu

I want to add a drop down menu to my sheet so I can select different ranges in a column.

I have attached the sheet. I would like a drop down on the odds column, so I can check the performance of different odds ranges.

Many thanks

if you click on Row 5 so its highlighted and then
data>
Filter>
AutoFilter>

that will put a drop down on alll the columns and you can select items from that drop down

If you choose custom - then you can set up ranges as well

if thats not what you need - can you be specific and provide an example of what you would like to select from drop down and appear on the sheet

Originally Posted by etaf

if you click on Row 5 so its highlighted and then
data>
Filter>
AutoFilter>

that will put a drop down on alll the columns and you can select items from that drop down

If you choose custom - then you can set up ranges as well

if thats not what you need - can you be specific and provide an example of what you would like to select from drop down and appear on the sheet

That's exactly what I needed, thanks

:up: glad it woked out ok