How do I...
Only allow certain entries in a cell
What to do
- Select the cells.
- Go to Data, then Data Validation.
- Under Allow, choose a type, such as Whole number or Date.
- Set the limits and click OK.
Good to know
- Use the Error Alert tab to write your own message.
- Pasting over a cell can get around the rule.
The idea in general
It checks an entry at the moment it is typed.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.