DATA VALIDATION Articles: Excel and Google Sheets

All resources related to DATA VALIDATION for Excel and Google Sheets.

DATA VALIDATION

How to Delete a Drop Down List in Excel
The Excel data validation drop-down list is used to enter data in a worksheet from a predefined list of items to limit the user choices in a faster and convenient way. Sometimes we need to remove a drop down list in selected or all the cells to allow the user...
Use Data Validation in Excel to Allow Text Only
We can use the ISTEXT function to allow only text in a cell. This data validation formula will make excel allow only the kind of data we want. In a few steps below, we will learn how to use this formula. Figure 1: Result of applying the ISTEXT function General...
Data validation allow weekday only
We can use the Excel WEEKDAY function to ensure that data validation allows weekday only. The steps below will walk through the process of using Data Validation to allow weekday only. Figure 1 – Example of Data Validation to allow weekday only General Formula =WEEKDAY(A1,2)<6 Formula =WEEKDAY(C5,2)<6 Setting up the...
Data validation must not contain
In excel, we can easily disallow an input which contains one of many things. To do this, we can use a validation rule which utilizes the SEARCH function. In this article, we shall look at how one can carry out data validation must not contain something else in excel. Figure...
Data validation allow numbers only
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
Data validation exists in list
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
Data validation date in specific year
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
How to Use Data Validation for a Date in the Next 30 days
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
Data validation must contain specific text
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
How to Use Data Validation to Get Unique Values Only
Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell.  It automatically checks whether the value entered is allowed based on the specified criteria. This step by step tutorial will assist all levels of Excel users in allowing...
1 2