In Microsoft Excel, you may change the case of text to capital, lowercase, or proper case.
Below are all of the numerous approaches that may be employed.
To change the case of the highlighted text in a cell, there is no keyboard shortcut.
Using functions to change the case
To modify the capitalization of text in a cell, Excel has three functions.
Each of these roles is described in further detail below.
=LOWER( )
Using the lower function, you may change the value of any cell to lowercase text.
For example, if you wanted to display a lowercase version of the text in B1 in cell C1, you might enter the code below into C1.
=LOWER(B1)=PROPER( )
Using the proper function, you may transform the value of any cell to a proper case.
For example, if you wanted to show in cell C1 a correct case version of the text in B1, you might write the below code into C1.
=PROPER(B1)=UPPER( )
Using the upper function, you may transform the value of any cell to uppercase text.
For example, if you wanted to display an uppercase version of the text in B1 in cell C1, you might enter the following code into C1.
=UPPER(B1)After you’ve constructed any of the formulae shown above, you may use the Excel Fill Handle to duplicate the function into as many cells as you need.
Make use of Excel Flash Fill
Excel 2013 and newer users may now utilize Excel Flash Fill to automatically fill cells with the formatting they wish.
Enter the text as you wish it to look.
After inserting the appropriately formatted text, use the keyboard shortcut Ctrl+E or select Data and then Flash Fill to fill out the remaining cells.
Copy and paste
If none of the above options work, copy and paste the text from Excel into another program that may adjust the case.
For example, you could copy and paste text from Excel to Microsoft Word and use the shortcut key Shift+F3 to alter text between capital, lowercase, and proper case.