11
3
Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
11
3
Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
8
Paul's suggestion is good or you can write your own macros and assign shortcut keys
Sub makeUPPER()
ActiveCell = UCase(ActiveCell)
End Sub
Sub makeLOWER()
ActiveCell = LCase(ActiveCell)
End Sub
4
I used the following technique to convert a column of text to uppercase.
=upper(A3)
, if A3 is the first cell you want to convert.=upper()
formulas.The same principle works for Proper, and other text manipulation functions.
1
If you install the excellent ASAP Utilities Excel addin (free for personal use)...
http://www.asap-utilities.com/download-asap-utilities.php
this has built-in UPPER CASE and lower case options (as well as a zillion others) which you can assign shortcut keys to (see their website for more info)
0
This works best for me, as it works on multiple cell selections:
Sub Uppercase()
For Each Cell In Selection
If Not Cell.HasFormula Then
Cell.Value = UCase(Cell.Value)
End If
Next Cell
End Sub
0
Copy the text you want to change the case for paste into word highlight it and press shift + f3 till its all in the case you want and cut and past back.
That doesn't seem at all practical for multiple cells. – David Richerby – 2015-10-08T10:34:02.497
Here is an add-in to perform change case https://aneejian.github.io/Change-Case-Excel-Add-In/
– Ian – 2018-05-02T08:05:15.763