- When you utilise a drop-down list to limit the entries users can make in a cell, data entry is faster and more accurate. When a cell is selected, the down-arrow of the drop-down list displays, and the user can click it to make a selection.
- Make a drop-down menu.
- Drop-down lists can help you make a worksheet more efficient. Someone who is using your worksheet clicks an arrow, then a list entry.
- Choose the cells in which you want the lists to appear.
- Select DATA > Data Validation from the ribbon.
- Set Allow to List in the dialogue.
- Click on Source, type the text or numbers you want in your drop-down list (separated by commas for a comma-delimited list), and then click OK.
Read More: What is ribbon, and where does it appear in excel?
