data validation in excel

Data Validation with MS – Excel Data validation is an important for entering specific values in the column with size or length. Here are the steps. 1. Prepare the sheet as shown in following screen shot. 2. Select the cloumn “Employee code” then Go to “Data” menu tab in the excel. 3. Select Data validation. […]