Data Validation

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Data Validation

How to use data validation for dropdown lists
http://www.versitas.com/blog/2011/03/21/excel-tips/
  • Total Hits: 21725

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 198 votes

  • Category: MS Excel/Functions

  • Submitted on: 2013-03-20 22:06:44

  • Submitted By: Donna Johnson

  • Set as Favorite

Description:

If you are creating spreadsheets where others will be entering data, you may want to make the data entry as automated and error proof as possible. One of the ways to do this is to set up data validation on appropriate cells/columns. For example, instead of having someone type in the department where someone works, I create a list for of all of the departments so that I can make sure that they have the correct, updated department names.

To do this, select the cells that you would like to add the data validation. Next, click on the Data tab and then the “Data Validation” button. A dialog box will open. On the Settings tab, under Allow, choose List. Then, under Source, either select the cells with the department names or type them in yourself (with commas separating each department name). If you would like to add an input message or error alert message, there are separate tabs in this same dialog box. After you click OK, you will have an in-cell drop down list available.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 32.32%  64
 Two starsTwo star  Vote LeftVote MiddleVote Right 9.09%  18
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 10.1%  20
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 9.09%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 39.39%  78

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements