How Excel creates a Drop-down list

Working in Excel altogether, sometimes you need to create a drop-down list, but how do you create it?? Here's an example of Excel2010 to show you how to add a drop-down list:

The first step, open Excel to select the data, as shown below

The second step, the selection of data validation, the following figure

The third step, the selection sequence, the following figure

Step Fourth, enter the Drop-down menu options you want, separated by commas, as shown below

Fifth step, OK, preview the effect, the following figure

The source of the Drop-down list, you can also select a range of cells in which to enter the Drop-down content in advance.

Microsoft Excel is one of the components of Microsoft Office software Microsoft Office and is a spreadsheet software written and run by Microsoft for Windows and Apple Macintosh operating system computers. Excel is an important part of Microsoft Office suite software, it can carry out various data processing, statistic analysis and assistant decision-making operation, widely applied in many fields such as management, statistic finance, finance and so on.