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

The input in Excel will take time when you have to type the same content over and over again. This article details how to create a drop down list or a drop-down list 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

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

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

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

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 .

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

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

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

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:

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

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

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

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

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

Step 6: After making your selection click OK:

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

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:

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

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

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

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

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

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!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile