Drop Down List Box. On the data tab under tools click data validation or validate. The data validation dialog box displays.
Create a drop down list. Check the show input message. This is similar to your standard combobox on your operating system.
An excel drop down list or dropdown menu can make it easier for the average microsoft excel user to enter data on a worksheet or workbook.
Select the cells that you want to restrict data entry in. This is similar to your standard combobox on your operating system. On the first sheet select cell b1. Frame tk variable and a dictionary with choices.
