How to allow only certain values or characters in Excel?
Excel can restrict what users enter in selected cells, but the correct method depends on whether you want to allow only specific complete values or only specific characters. This article shows how to create a list of permitted values with Data Validation and how to restrict entries to selected characters with Kutools for Excel.
- Allow only certain values with Data Validation
- Allow only certain characters with Kutools for Excel
- Video: Allow only certain characters
- Frequently asked questions
Comparison of methods for restricting entries
| Method | What it restricts | Example | Best for |
|---|---|---|---|
| Data Validation | Allows only complete values from a predefined list. | An entry must be exactly Approved, Pending, or Rejected. | Status fields, categories, departments, and other fixed choices. |
| Kutools for Excel | Allows entries containing only the specified characters. | If ABCDE is allowed, users can enter AB, DE, or ABCDE. | Codes and IDs that must use a limited character set. |
Allow only certain values with Data Validation
Excel's Data Validation feature can limit entries to the complete values stored in a source list.
- Enter the values you want to allow in a range of cells.
- Select the cells in which you want to restrict entries, and click Data > Data Validation.
- In the Data Validation dialog box, on the Settings tab, select List from the Allow list. In the Source box, click the range-selection button
and select the list created in the first step. 
- Click OK. Users can now select or type only a value that exactly matches an item in the source list.
If a user enters a value that is not in the list, Excel displays an error alert and rejects the entry.
and select the list created in the first step. 
Allow only certain characters with Kutools for Excel
If users need to enter different combinations of a limited set of characters, use the Prevent Typing feature in Kutools for Excel. For example, you can allow the letters A, B, C, D, and E without limiting users to a predefined list of complete values.
- Select the cells you want to restrict, and click Kutools > Prevent Typing > Prevent Typing.
- In the Prevent Typing dialog box, select Allow to type in these chars. Enter the permitted characters directly in the box below, such as ABCDE, and select Case sensitive if uppercase and lowercase letters should be treated differently.
📝 Note:
This feature has been updated. You no longer need to separate characters with commas. Enter the allowed characters directly, such as ABCDE.
- Click OK. A message warns that applying this feature will remove existing Data Validation rules from the selected range. Click Yes to continue, and then click OK in the confirmation message.
- The selected cells now accept only the specified characters. In this example, users can enter combinations of A, B, C, D, and E, but other characters are rejected.
📝 Note:
If Case sensitive is cleared, both uppercase and lowercase versions of the specified letters are allowed. For example, entering ABCDE also permits abcde.
Video: Allow only certain characters
Frequently asked questions
What is the difference between allowing certain values and allowing certain characters?
Allowing certain values requires the entire cell entry to match an item in a list. Allowing certain characters lets users create different entries, but every character used must belong to the permitted character set.
Can users type a Data Validation list value instead of selecting it?
Yes. Excel accepts a typed entry when it exactly matches one of the values in the source list.
Why can an invalid value appear after data is pasted?
Some paste operations can bypass or overwrite Excel Data Validation. Review pasted data afterward or use stronger entry protection when pasted values must also be controlled.
How can I allow letters, numbers, and a hyphen with Kutools?
Enter all permitted characters directly in the box, for example ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-. Enable Case sensitive if lowercase letters should remain blocked.
Will Kutools Prevent Typing remove existing Data Validation?
Yes. Kutools displays a warning before removing Data Validation rules from the selected range. Review those rules before you continue.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in