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.

Posted in: Data validation in Excel 2003,list options in columns,Microsoft Excel 2003,Microsoft Office Support,PC Support,Technical Support,TechSupp247,validate data