1276251155734027
Loading...

Excel Tutorials | How to Make a Drop-Down List in Excel | #ExcelTutorials

#ExcelTutorials A drop-drop down list in Excel helps us to spare some time instead of creating separate tables. In this series of our Excel Tutorials, we are going to explain you how to make a drop-down list in excel in five easy steps.

Excel Tutorials | Drop-down list in Excel
Excel Tutorials | Drop-down list in Excel

1. First of all, we should choose whether we need a drop-down list in Excel and what we need it for. In our example, we are going to use the drop-down list in Excel to show different credit opportunities.


Here, we have a choice between different sums. It would be useful to give the client an opportunity to see how the interest would change, for example. Then, we choose the cell where we want to have our drop-down list in Excel.

2. Next, we choose Data > Data Validation in the MS Excel ribbon.

Excel Tutorials | Drop-down list in Excel | MS Excel

3. In the new context menu Data Validation, we choose Allow: > List under Validation criteria.

Excel Tutorials | Drop-down list in Excel | #ExcelTutorials

4. Under Source: we choose the values that we are going to present in our drop-down list in Excel. 

Excel Tutorials | Drop-down list in Excel

5. Now, we can choose between different values and finalise the procedure by clicking OK in the Data Validation context menu and returning to our drop-down list in Excel.

Excel Tutorials | Drop-down list in Excel




MS Excel 3177709056376484986

Post a Comment

Home item

More links from #glfintech:

#glfintech Newsletter

#glfintech Recommends

#glfintech on Twitter

Statistics


Partner and Clients

Warmboutique

Webstore selling textile goods

Adblock is enabled

Hi! We have detected that you are using adblock on your web browser and take this chance to ask you to pause it just for this site. Time is money and we invest lots of time in the content that we work really hard on, and advertising is the only source of income for this particular project.
Thanks.

No harming software. We promise!