Tagged Questions
1
vote
2answers
90 views
Creating a list based on a column
I need to create a dropdown list in sheet A based on the values in sheet B in column A. I clicked on the A column in B sheet and named it as Models. Then I clicked on the cell in sheet A where I ...
9
votes
1answer
1k views
Setting a default value for a dynamic cascading validation list in Excel 2010
I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem.
I would like to set up my ...
1
vote
1answer
302 views
Floating dropdown in Excel
Is it possible to click in a cell, a drop down appears, then whichever choice is made from the dropdown store that value. I made the dropdown and can place it on a cell but I have a lot of cell that ...
0
votes
1answer
612 views
How to select a value from drop down in a cell of MS Excel with keyboard?
Is there any way to select the value from drop down in excel by using only keyboard
