Monday, August 1, 2011

Data Validation-Microsoft Excel 2003

When we are working with tables where we need to type the same thing for a list of rows we may use this data validation as list. It is there in Microsoft Excel 2003 and next versions.


To apply Data Validation: 

1) Select the row just behind the column name under which the options have to be given.
2) Click Data menu and click validation.


3) Select in the dropdown under Allow and in Settings Tab.


4) Under Source type the option that are to be placed in that column and click OK.


We will get a dropdown with the list of words added in the column we chose for.



1 comments:

Intersting and beautiful blog lovely presentation thanks for sharing your views...microsoft office xp Call us at We24Support microsoft office xp number at 1-866-978-0799 and Enhance your system functioning and keep it clean with We24Support services.

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More