The shortcut to change letters from lowercase to uppercase in Excel using the keyboard is to select the text and press Shift + F3 repeatedly until the desired case (uppercase, lowercase, or capitalize each word) is applied
. However, this shortcut works only when editing text directly in a cell or when text is selected in Excel. Excel itself does not have a built-in single shortcut to convert an entire cell's content to uppercase without using formulas or macros.
Other common methods to convert text to uppercase in Excel:
- Use the formula
=UPPER(A1)in a new cell to convert the text in cell A1 to uppercase, then copy and paste values if needed
- Create a VBA macro to convert selected cells to uppercase and assign a custom shortcut like Ctrl + Shift + U for quick use
- Use Flash Fill or copy the text to Word and use Word's Shift + F3 shortcut, then paste back
In summary, Shift + F3 is the direct keyboard shortcut to toggle case on selected text in Excel, but for converting entire cells or ranges, formulas or macros are typically used
