Welcome to Community Sign in | Join | Help

Data Validation

I received a phone call from a Marketing Team wanting to know how to create a drop down list within a cell.  Data Validation is the perfect way to accomplish this.

From the Data menu, select Validation.  A screen similar to the following should appear:

Under the Allow: selection, choose List.  In the Source: drop down, type in the items you wish to have appear in the cell, separated by a comma.  It's that simple.

Published Thursday, April 24, 2008 5:43 AM by galimi

Comment Notification

Subscribe to this post's comments using RSS

Comments

No Comments

What do you think?

(required) 
(required) 
(required) 
Enter the numbers you see into the
field below.
(required)