The articles listed in this category is about drop-down lists [Data Validation]. If you are looking for combo boxes then check out this category.
A drop-down list in Excel lets you specify valid values a user can enter in a cell, it makes it easier for the user to type a value since the list shows the valid values and clicking on them automatically enters the value in the cell.
Don't forget to check out the articles in this category, there are links in the sidebar or if you are on mobile then click on the hamburger icon. There are also links at the very bottom of this page.
Simply use a cell reference to the cell containing the drop-down list, that way you can use the selected value in a formula or macro. The image above shows a drop-down list in cell B2.
If this is not working then you probably have a combo box on your worksheet.
Tip! Use a named reference if you often use the value in formulas etc. Simply select the cell containing the drop-down list and then click in the name box and enter the name. Then use that name in your formula, it will even show up in the formula bar.
Can I copy the drop-down list to an entire column? You can, however, I don't recommend it. There are more than a million rows in a worksheet, it may slow down your workbook and create a larger workbook file than necessary.
Copy - Paste
The image above shows you how to copy and paste a drop-down list.
Select the cell containing the drop-down list you want to copy.
Press CTRL + c which is the short cut keys to copy a cell.
Select the cell range you want to copy the drop-down list to.
Right-click on the selected cell range and click on Paste or press CTRL + v to paste the copied cell to the selected cell range.
Select - Drag
Click and hold on the black dot located at the bottom right corner of the cell containing the drop-down list you want to copy.