how to use data validation in excel Archives

For Creating DATA VALIDATION Restrict User to add any data for a specific cell or range. please follow the few step shown below. Select a cell where you want to have restriction for user to not enter any data.Go to Data TabGo to Data Validation and click on it and one dialog box will pop up.Select Custom from that dialog box and go down one step into Formula row in that dialog box.Now enter the Formula For example :- =B2="EXCEL HELP"Once added the formula just hit ok button in the dialog box and its done.NOW B2 Cell will only accept the value EXCEL HELPNow for that particular range or a single cell user cannot enter any other value then the cell contain already.If you want to show a message when a user select the restricted cell just go to Input message next to setting in the dialog box...

For Creating a Data Validation restriction for user to enter limited character in a particular cell please follow the few step shown below. Select a cell where you want to have restriction for user to enter the number of limited character.Go to Data TabGo to Data Validation and click on it and one dialog box will pop up.Select Text Length from that dialog box and go down one step into source row in that dialog box.Now enter the minimum and maximum character the user must have to enter. For example :- Minimum = 5 and Maximum = 10Once Selected just hit ok button in the dialog box and its done.Now for that particular range or a single cell user only can enter the minimum to maximum character.If you want to show a message when a user select the restricted cell just go to Input message next ...

Tag: how to use data validation in excel

DATA VALIDATION Restrict User to add any data for a specific cell or range.

Data Validation Restrict User To Add Limited Character.