Excel Drop-down list Making tutorial

How does Excel create a drop-down list? Here PC6 Small series Excel2010 as an example, to show you how to add a drop-down list:

Open Excel to select data, as shown in Figure 1

Figure 1

Select data validation, as shown in Figure 2

Figure 2

Select a sequence, as shown in Figure 3

Figure 3

Enter the Drop-down menu options you want, separated by commas, as shown in Figure 4

Figure 4

OK, preview the effect, as shown in Figure 5

Figure 5

(The source of the Drop-down list, as well as the selection of the range of cells for which you entered the Drop-down content in advance)

Classification:

• Excel Tutorials