Excel - how to make cells "pop up" once an item is chosen from a drop-down list?

Question

Anyone know how to make a new drop down list appear when choosing an item from the first drop-down box? Can't find any of this, have been looking for hours....

I mean that once clicking on an item in a drop down menu, that then a new cell will appear with another option, I would like it to be a check box.

Answer 1

http://www.contextures.com/xlDataVal02.html

Answer 2

only pick the total column you opt for the dropdown to operate in. use files validation and choose record, form in container =(YourListName) To make a dropdown record tremendous only pick a large form of cells to outline call to. you could upload files for thus long as you've loose cells in the variety defined.

Answer 3

dear friend
i don't know what do you mean but select all celles that you want to be in your drop down list and then click on drop down list
all of them will be in drop down.
you can do it with any cell that you want just select all of them.
do you mean double drop down list one drop.. in another???
tell me what did you do..

Answer 4

Do you mean 'add' or 'delete' cells, or What? What do you mean pop up?

http://www.uis.edu/ctl/training/detailedtips/exceldropdown.htm

here you go....