Instructions on how to create drop down lists or drop-down lists in Excel

You do the data entry on the warehouse or in a working unit, the data entry will take time when you have to type the same content over and over again. The following article guides in detail how to create a drop down list or a Drop-down List in Excel.

For example, want to inventory the number of textbooks of Cam Tay Secondary School. Usually you enter the entire content. But when you have a list when importing textbooks, including titles and authors, you only need to create a drop-down list for the title and author columns to minimize the input process:

- Create Drop-down List for column title and author

Instructions on how to create drop down lists or drop-down lists in Excel Picture 1

- The data to create the Drop-down List is taken from the Book_document sheet with the corresponding column:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 2

To create a Drop-down List for a textbook column, follow these steps:

Step 1: Select the data area you want to create Drop-down List -> on the Data tab -> Data Validation -> Data Validation .

Instructions on how to create drop down lists or drop-down lists in Excel Picture 3

Step 2: The Data Validation dialog box appears in the Allow price list option:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 4

Step 3: After selecting the type of list, scroll down to Source, click the arrow to select the data set in the Drop-down List:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 5

Step 4: Click the down arrow and move down the Book_document sheet to get the data to create Drop-down List:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 6

Step 5: Select the data area placed in the Drop-down List, for example, here take the data in the Name column :

Instructions on how to create drop down lists or drop-down lists in Excel Picture 7

Step 6: After making your selection click OK:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 8

The result when you click a cell in the title column -> Drop-down List 1 drop down list for you to choose, instead of entering the content you just need to click on a value in the Drop-down List:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 9

In the same way, you create a Drop-down List for the Author column:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 10

In case the content you want to create in the Short Drop-down List , you can enter the content directly in Source:

Instructions on how to create drop down lists or drop-down lists in Excel Picture 11

Attention:

In some cases, it is impossible to use the Data Validation feature due to one of the following reasons:

- Drop-down List cannot be created from a sheet linked to Office SharePoint tools.

- Your Excel file has a security mode such as setting a password .

The above is a detailed guide on how to create drop down lists or drop-down lists in Excel. Good luck!