Drop Down Formula In Excel. Select a cell where you want to create the drop down list cell c2 in this example. Click on name manager and select new.
For example suppose you have the data set as shown below. Unlock specific areas of a protected workbook or stop sharing the worksheet and then try step 3 again. The steps to do this are.
Select the range of data input cells step 2 instead of a single excel cell.
To create the region. For example suppose you have the data set as shown below. Select the cell in the worksheet where you want the drop down list. Type a team name into cell g2 e g.
