Thursday, November 21

Data Validation Restrict User To Add Limited Character.

For Creating a Data Validation restriction for user to enter limited character in a particular cell please follow the few step shown below.

  1. Select a cell where you want to have restriction for user to enter the number of limited character.
  2. Go to Data Tab
  3. Go to Data Validation and click on it and one dialog box will pop up.
  4. Select Text Length from that dialog box and go down one step into source row in that dialog box.
  5. Now enter the minimum and maximum character the user must have to enter. For example :- Minimum = 5 and Maximum = 10
  6. Once Selected just hit ok button in the dialog box and its done.
  7. Now for that particular range or a single cell user only can enter the minimum to maximum character.
  8. 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 and enter the title and input message.
  9. For Example see the step shown in the image and a video provided below.

Leave a Reply

Your email address will not be published. Required fields are marked *