Drop Down Formula In Excel. Go to formula then name manager. Formula in cell c12.
The second excel drop down list will display the representatives in that region. Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again. Any formula that returns a list of values can be used to create a drop down list in excel.
If you can t click data validation the worksheet might be protected or shared.
If you can t click data validation the worksheet might be protected or shared. Formula in cell c12. You can add the drop down list to multiple excel cells. Select the range of data input cells step 2 instead of a single excel cell.
