Drop-down list

“Data validation” allows us to make a list of different items. These items can be letters, words and numbers. In other words, all items in this list are totally depending on you.

An example:

I’m creating a drop-down list of the students in my class, a rather small class, because there are only six students

 

First I select a blank cell or “Range” of cells to have the drop-down list.

In this example, I select cell C4 (1) and click the “Data Validation” button in the “Ribbon”.
In the dialog box that appears, I choose “List” (2) from the drop-down menu of the “Allow” box.
Then I click in the “Source” button and choose cells with the help of the “Folding” (3) button.

I then select the “Range” (4) where my list is. Cell A4 to A9.
And click on the “Open” (5) button.

Next I click the OK button in the dialog box .

In the “Worksheet”, I click the downward pointing arrow next to cell C4 which unfolds a list of the various items (4).

 

To be able to use this list in another “Worksheet”, we need to name the “Range”.

In this example, I named the “Range” as “Students”.

In the next “Worksheet”, the cell(s) should have this drop-down list .

Click the “Data Validation” button in the “Ribbon”.

Select “List” in the “Allow” box.

Type ‘= students’ in the “Source”

And click OK.

All these cells now have a drop-down list with our “students”.

 

Search for cells with “Data validation”.

If you do not remember which cells have validation rules, click the “Search and Select” button in the “Home” tab of the “Ribbon”.

Select the “Data Validation” from the drop-down menu.

“Excel” will show you every cell in your “Worksheet” that has “Data validation” in a nice table.

 

Removal of conditions

To remove “Data validation” terms, first select the “Range” in which the “Data validation” was applied.

Click the “Data Validation” button in the “Ribbon”.

In the dialog that appears, click the “Delete All” button links at the bottom of the dialog.

And click OK.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats