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
- The data to create the Drop-down List is taken from the Book_document sheet with the corresponding column:
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 .
Step 2: The Data Validation dialog box appears in the Allow price list option:
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:
Step 4: Click the down arrow and move down the Book_document sheet to get the data to create Drop-down List:
Step 5: Select the data area placed in the Drop-down List, for example, here take the data in the Name column :
Step 6: After making your selection click OK:
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:
In the same way, you create a Drop-down List for the Author column:
In case the content you want to create in the Short Drop-down List , you can enter the content directly in Source:
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!
You should read it
- How to create drop down lists on Google Sheets
- How to Create a Drop Down List in Excel
- How to create a filter in an Excel cell
- Create Drop cap big letters in Word
- How to create drop down list to select in excel
- How to create Drop Cap in Word
- How to create bullet list in Excel
- How to use Mail Drop on iPhone to send large files
May be interested
- How to merge multiple messages on 1 page from an Excel table in Word 2016the following article shows you how to merge multiple messages on a single page from an excel table in word 2016 to help you create invitations, certificates ... quickly and accurately.
- How to merge messages that contain images in Word 2016teach you how to merge letters containing pictures in word 2016 to help you create student, student, staff cards ... quickly and accurately.
- How to convert Inches to centimeters in Word 2016the default measurement unit in inch is inch, however in vietnam the standard unit is centimeters, so that it is easy to use operations such as aligning margins, you should change the units from inches to centimeters. the following article will guide you in detail how to convert inches to cm in word 2016.
- Fix lower case i automatically converted to capital I in Wordwhen typing lowercase i automatically word switches to letter i (uppercase) although the letter i is not at the beginning of the sentence. the following article shows you how to fix the letter i automatically converted into the letter i in word.
- How to customize the look and feel in Office 2016office 2016 supports many new features for users. you can edit, change the interface, language, tools ... the following article guides you in detail how to customize the interface in office 2016.
- Free applications that replace Microsoft Officemicrosoft office is an indispensable tool for office work.if you have any questions about the expensive licensing costs of office, please refer to some free office tools that can replace office. introduced below.