Forum Discussion

Greg Daughenbaugh's avatar
Greg Daughenbaugh
Copper Contributor
Nov 25, 2017

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...
excel
Excel Online
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Nov 25, 2017

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.

pamsmentions's avatar
pamsmentions
Copper Contributor
Nov 06, 2020

Haytham Amairah 

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

Resources