creating dropdown menus within a cell

how do i make it so a user can just click on a cell and it will have a dropdown menu for the user?

i want to be able to use only keyboard though for faster data entry. using mouse only will be way too slow as they have to click, then find the item, then click. i prefer if the dropdown menu was just there for reference for whatever option is available, but if they hit "s" for example, all options beginning with "s" will be available.

Krayziez; does this work for you?

hi, thanks for the reply, but this isn't quite what i was trying to get. it's those dropdown menus that you see all the time. it should only consist of one cell where you select from the dropdown menu on that one cell only. it doesn't affect any other cell.

also, i forgot to mention that B1's choice may be affected by A1's choice. Example:
if A1 i can choose: jeans, t-shirts, shorts

then B1, would be able to choose from these: tappered leg, baggy IF A1 has "jeans" chosen.

likewise if A1 has t-shirt as chosen then B1 would have the choices of half button, short sleeve, long sleeve, etc.

etc...

this seems like what i'm looking for thanks!!! i'll let you know if i have any specific questions. this forum rox!

ok. i ran into a problem. i need to be able to have more than one =indirect reference. for example. "PetiteSize" under shorts (sheetname "shorts") can be for:
P0
P1
P2
P3
P4

but i also have "PetiteSize" for shirts (sheetname "shirts") and will be used for:
P3
P4
P5
P6
P7
P8

Now the dumb thing about this is that I can't reference it to another sheetname which is pretty frustrating. I'd be able to seperate everything by sheetname, but I can't so how do I have the dropdown menu be available only for P0 to P4 only when I'm doing shorts and P3 to P8 only for shirts? They use the same "PetiteSize" and I have to have that exact name or it wont work.

ok i resolved it with a vlookup table to repalce each one.

i had a question though, is there a way of lengthening the dropdown so it can show more? currently it only shows about 10, then u have to scroll down, and the mouse wheel doesnt even work with this, u actually have to click on the right scrollbar and scroll down. if i'm doing 1500 of these a day, i'll go crazy.

i think there was a setting on windows itself that allowed for every dropdown menu to be at full length rather than short.

well i think i got it, but i just used a vlookup to replace "misses" with "misses01".. so i have 16 groups that could use "misses" as the size and all of them could have different sizes for "misses". so i just replaced it with "misses01" for the first group, then i'll do "misses02" for the 2nd group etc. you'll see it on C2 on "G 01" sheetnam

o, also is there a way to make that list without having to go through all those steps of referencing this and that cell?

I just want to have a way of creating that list without selecting any other cells. Reason is, it gets messy having to put in information on some cells and then having to name that cell range, then referencing it.

i'd rather just have a way of clicking on "validate" then entering the information on the pop-up without having to reference any other outside source/cells. it makes the worksheet messy.