what is the shortcut to change small letters to capital letters in excel?
In Excel, there is no single built‑in keyboard shortcut that instantly changes selected text from small letters (lowercase) to capital letters (UPPERCASE) in-place in the same cell.
However, you can do it very quickly with a simple formula-based “shortcut”:
Fast way using UPPER function
- Suppose your lowercase text is in cell
A1. - In an empty cell (say
B1), type:
=UPPER(A1).
- Press Enter – you’ll see the capitalized version of the text.
- Drag the fill handle down to apply it to more cells (if needed).
- Select the results in column B, copy them, then use Paste Special → Values to overwrite the original lowercase text in column A (if you want to replace it).
If you really want a “keyboard shortcut”
The only way to have a true single key combo (like in Word) is to create a
small VBA macro and assign it a custom shortcut. For most users, though, the
=UPPER() approach is the quickest and safest option.
So if you’re searching “what is the shortcut to change small letters to capital letters in Excel?”, the practical answer is: use the UPPER function (and optionally Paste Special), because Excel doesn’t include a direct case-change shortcut like Word does.
Information gathered from public forums or data available on the internet and portrayed here.
