Forum Discussion
Microsoft Excel keeping all cells uppercase
You can use another way, it's forcing users from the beginning to enter uppercase characters through Data Validation feature.
Just follow these steps:
- Select the entire column you want.
- Go to Data Ribbon Tab >> Data Tools Group >> Data Validation
- From Data Validation dialog box, select custom from Allow combo box.
- In the formula bar copy and paste this formula:
=EXACT(A1,UPPER(A1))
- Press OK.
After that, users are not allowed to enter lowercase characters in column A.
NOTE: If you want to apply this to a column other than column A, select that column entirely, and change the cell references in data validation formula.
- pamsmentionsNov 06, 2020Copper Contributor
Hi Haytham,
Am only able to add the data validation to one column.
When I add it to the next column, the next column does not work.
It only works for the 1st column created.
data validation --> formula custom = exact(a1,upper(a1)) works great
when i do same thing in next column, it does not work for that column
Any help is greatly appreciated.
Thank you,
Pam
- Robyn JohnsonSep 14, 2021Copper ContributorThis does not work to automatically change lower to upper case. It only shows an error telling one that the data is incorrectly entered. It does not change the entry from lower case to upper case automatically.
- Peggi21Mar 18, 2024Copper Contributor
Haytham Amairah That worked great! I just copy and paste into whichever cells I need in Upper Case.
Thanks for being here to answer these questions.