How can I create a cell that has selectable drop down menu so I can link it another worksheet?
E Ed Kim Sep 30, 2004 #1 How can I create a cell that has selectable drop down menu so I can link it another worksheet?
D Debra Dalgleish Sep 30, 2004 #2 You can use Data>Validation to create a dropdown list in a cell. There are instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html
You can use Data>Validation to create a dropdown list in a cell. There are instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html
