Create a data validation for cells

Create a data validation for cells

To create data validation:

  1. Click Data > Data Validation.

  2. You can choose the required range to apply data validation from the dialog shown below.

                              

3. The options that are available include the following:

Decimal number, Whole number, Text, Text length, Date & Time, List, Cell range. 

Note:

You can choose a list of values that will be entered into a particular column before using data validation. There will be a drop down list displaying the values you have chosen and you can pick your value from the available list.


You can also set a legend near a particular cell that uses data validation to regulate its data and a warning error alert when the data validation condition is not followed. It can be done from the Data Validation box.​

    • Related Articles

    • Lock cells

      To lock a range of cells, Select the particular cell or range of cells that you wish to lock. Select Data > Lock> Lock Cells. You can also right click on the selected range and click Lock Cells. The Lock Cells dialog box appears. Choose the ...

    • Sort data present in cells

      To sort data: 1. Select the range of cells to be sorted. 2. Click Data > Sort > Sort Ascending or Sort Descending. 3. To set your conditions for sorting select Custom Sort. You can also use the Sort icon  from the tool bar.

    • Working with Validation Rules

      One of the most challenging tasks in CRM system is ensuring the validity of data in it. A poorly maintained set of data can cost a company in more ways than one - your activities are slowed down, you will have inaccurate reports and it's plain ...

    • Change the alignment of data in cells

      You can change both the horizontal and the vertical alignment of data entered into the cell. To change the alignment of data inside the cells: 1. Select the cells to be aligned.  2. On the default toll bar, click on Alignment    icon. 3. Choose to ...

    • Creating Validation Rules Using Functions

      By using function you can create a validation rule where the value entered by the user needs to be verified outside the CRM database. You can even validate the fields like phone numbers, zip code and so on for a particular pattern by mentioning the ...