Forum Discussion
Microsoft Excel keeping all cells uppercase
I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case. Regardless of case the user enters the data in this column it is saved i...
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.
This 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.
