How to prevent lowercase entry in an Excel selection?
In some worksheets, you may want users to enter numbers, uppercase letters, and special characters, while preventing lowercase letters. This article introduces three ways to control lowercase entry in a selected range in Excel.
- Prevent lowercase entry with Data Validation
- Prevent lowercase entry with Kutools for Excel
- Allow only uppercase entry with Kutools for Excel
- Video: Prevent lowercase input
- Frequently asked questions
Comparison of methods for controlling lowercase entry
| Method | Allowed entries | Setup |
|---|---|---|
| Data Validation | Uppercase letters, numbers, spaces, and special characters | Uses a custom formula; pasted values may bypass the rule. |
| Kutools: Prevent specified characters | Everything except the lowercase letters you specify | Enter the lowercase alphabet once and enable case sensitivity. |
| Kutools: Allow specified characters only | Only the uppercase letters you specify | Useful when numbers, spaces, and special characters must also be rejected. |
Prevent lowercase entry with Data Validation
Excel's Data Validation feature can reject an entry when its text is not identical to its uppercase version.
- Select the range in which you want to prevent lowercase characters, and click Data > Data Validation.
- In the Data Validation dialog box, on the Settings tab, select Custom from the Allow list. Enter the following formula in the Formula box:
=ISERROR(FIND(UPPER(G1),G1))=FALSE📝 Note:
G1 is the first cell in the selected range. Change this reference to match the first cell of your selection. The relative reference allows Excel to check each cell individually.
- Open the Error Alert tab. Keep the Style set to Stop, and enter the message you want to display in the Error message box.
- Click OK. When a user types a value containing a lowercase letter in the selected range, Excel displays the error alert and rejects the entry.
Prevent lowercase entry with Kutools for Excel
With Kutools for Excel, you can use Prevent Typing to block all lowercase letters while continuing to allow uppercase letters, numbers, and other characters.
- Select the cells in which you want to prevent lowercase entry, and click Kutools > Prevent Typing > Prevent Typing.
- In the Prevent Typing dialog box, select Prevent type in these chars. Enter all lowercase letters directly in the box below, and select Case sensitive.
📝 Note:
This feature has been updated. You no longer need to separate characters with commas. Enter the characters directly, such as abcdefg...
- Click OK. A message warns that applying the feature will remove existing Data Validation rules from the selected range.
- Click Yes. Another message confirms the typing restriction.
- Click OK. Lowercase letters can no longer be entered in the selected cells.
Allow only uppercase entry with Kutools for Excel
You can also configure Prevent Typing to allow only specified uppercase letters. Unlike the previous methods, this option also rejects numbers, spaces, and special characters unless you add them to the allowed-character list.
- Select the cells in which you want to allow only uppercase letters, and click Kutools > Prevent Typing > Prevent Typing.
- In the Prevent Typing dialog box, select Only allow to type in these chars. Enter all uppercase letters directly in the box below, and select Case sensitive.
📝 Note:
This feature has been updated. You no longer need to separate characters with commas. Enter the characters directly, such as ABCDEFG...
- Click OK. In the two messages that appear, click Yes and then OK.
- When a user enters any character that is not included in the uppercase allowed-character list, a warning appears and the entry is rejected.
Video: Prevent lowercase input
Frequently asked questions
Does the Data Validation formula allow numbers and special characters?
Yes. Numbers, spaces, and special characters do not have lowercase forms, so the formula accepts them. It rejects only entries containing lowercase letters.
Why can lowercase letters still appear after data is pasted?
Some paste operations can bypass or overwrite Excel Data Validation. If pasted values must also be controlled, use a method that provides stronger entry protection.
Can I allow uppercase letters and numbers but reject special characters?
Yes. In the third Kutools method, add A–Z and 0–9 to the allowed-character list, keep Case sensitive selected, and do not add spaces or special characters.
Why must Case sensitive be selected in Kutools?
Without this option, Kutools may treat an uppercase and lowercase version of the same letter as equivalent. Enabling it ensures that the lowercase letters are handled separately.
Will applying Prevent Typing remove existing Data Validation?
Yes. The confirmation message warns that existing Data Validation rules in the selected range will be removed. Review those rules before continuing.
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