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.



5 comments:

Wonderful Blog on recent updates, I have updated my knowledge through your blog, Thanks admin for sharing the recent information.
web designing course
web designing courses

I was really excited about your daily updates. If you have new update me.
PHP Course Chennai
php course

Hey Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
digital marketing course in coimbatore
php training in coimbatore

Great post! This is very useful for me and gain more information, Thanks for sharing with us.

Article submission sites
Guest posting sites

Post a Comment

Search This Blog

Followers

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