Excel Tips: Data > Data Validation

Only Allow Typing

How to allow only date format in specific cells?

How to allow only numbers to be input in text box?

How to allow only yes or no entry in Excel?

How to apply data validation to force phone number format in Excel?

How to data validation the date of current year in Excel worksheet?

How to data validation to allow date greater than today or a specific date in Excel?

How to force uppercase of text entry in a textbox?

How to limit cell entry to numeric value or a list in Excel?

How to limit characters length in a cell in Excel?

How to limit date range entry in an Excel column?

How to only allow alphanumeric characters entry in Excel?

How to only allow certain values input or enter in Excel?

How to only allow negative numbers in Excel?

How to restrict value entry/input in a cell based on another cell value in Excel?

How to use data validation to force percentage in Excel cells?

How to use data validation to limit number of digits while typing in Excel?

How to use data validation to only allow SSN number entered in Excel?

How to validate cells to only accept IP address in Excel?

How to validate email addresses in a column of worksheet?

How to data validation the date of current year in Excel worksheet?

How to data validation to allow date greater than today or a specific date in Excel?

Prevent Typing

How to only allow unique values in Excel?

How to pop out a warning if duplicate entered in an Excel column?

How to pop out a warning if duplicate entered in an Excel column?

How to prevent blank or missing entries in cells in Excel?

How to prevent data entry into specific cells of a worksheet in Excel?

How to prevent duplicate entries in a column in Excel?

How to prevent duplicate entry in Google sheets?

How to prevent entering values with spaces in Excel?

How to prevent lowercase entry in an Excel selection?

How to prevent saving if specific cell is blank in Excel?

How to prevent special characters entering in Excel?

How to use data validation to prevent blank cells left in Excel column?