How To Make List in Excel

How To Make List in Excel

A list in Excel can help you enter data without mistakes and very quickly. A dropdown list in excel can be made in 2 ways and in this excel tutorial i have covered both the ways. Download Practice Files from

Create a drop-down list

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list.

  1. Select the cells that you want to contain the lists.

  2. On the ribbon, click DATA > Data Validation.

  3. In the dialog, set Allow to List.

  4. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

* Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel-

Learn Basic Excel Skills For Beginners-

Learn the Basic of Excel for Beginners -

10 Most Used Excel Formula-

Learn Vlookup Formula For Beginners in Excel-

5 Excel Questions Asked in Job Interviews-

Create Speedometer Chart In Excel-

Create Pareto Chart In Excel-

How to Create Dashboard in Excel-

Excel Interview Questions & Answers-

Related Videos