How to create data validation?

How to create data validation?

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.

The options that are available include the following: Decimal number, Whole number, Text, Text length, Date & Time, List, Cell range. 

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.

Edit data validation conditions

To manage data validation:

  1. Click Data validation > Manage Validation.
  2. You can choose the settings icon near every validation condition in order to edit, copy or clear the available validations.

Clear a data validation condition

To clear data validation:
  1. Choose the particular cell or the range of cells from which you want to clear data validation.
  2. Click on the Clear option  on the toolbar.
  3. Click on Clear Data Validation.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                  Zoho SalesIQ Resources

                      Zoho TeamInbox Resources

                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW

                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now

                                                          • Related Articles

                                                          • Create pivot tables to analyse your data

                                                            Create a pivot table in sheet To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created Drag and drop the fields into the desired positions in the Pivot ...
                                                          • Create a new blank spreadsheet

                                                            To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
                                                          • Create and customize charts to visualize data

                                                            Create a chart To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, ...
                                                          • Create a named range

                                                            To create a named range: Select the desired cell range. Go to  Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value. Enter the desired values and tap Done.
                                                          • Filter a data range

                                                            To apply a filter on a cell range: Select the desired cell range to filter. Go to  icon Under the Data menu, choose Filter. Switch on the toggle button to see the filter icons appear on the table header. Tap on the  to view the list of criteria (cell ...



                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.

                                                            Zoho Show Resources