Creating a List or Drop Down List in Excel to select specific data
Creating a List or Drop-Down List in Excel to Select Specific Data
See more at http://www.doesystem.info/2015/12/lis...
Programs teach how to use the program, teach, advise, and help solve problems related to computers and IT. We teach how to use it, learn, solve problems, create websites, program programming, and other IT-related topics.
Excel, Microsoft Excel, drop-down list, Excel list, Excel tutorial, create a list in Excel, create a drop-down list in Excel, Excel data validation, create an Excel list.
Creating a List in Excel
In this article, we'll look at how to create a list in Excel. Sometimes, we need to create a list for various reasons, such as forcing the entry of specified data, reducing errors or errors during data entry, or simply for speed. Let's take a look at how to create a list in Excel.
An example of the data we'll use to create a list is shown in the image below.
Once we have the data, we want to create a list of departments with only the specified data to choose from.
First, select the section you want to create a list of. Here, I've selected column B to display the entire column. Select the column by selecting it, then go to the Data tab. Under Data Tools, select Data Validation, as shown in the image below.
Once selected, the Data Validation dialog box will appear. In the Allow box, select List. In the Source box, select the data to display in the list. In this example, we'll select the data in =$B$2:$B$8, which is column B, row 2, through column B, row 8, as shown in the image below.
Once selected, click OK. You'll now have a list of all columns available for selection, as shown in the image below.
The results will show a list of data, which will contain duplicates, so be careful. Now you have a list of data. Give it a try!