Note: the same command can be be used in a VBA (Visual Basic for Applications) macro. Just highlight the relevant cells and keep pushing Shift + F3, until you achieve the correct capitalization Its syntax is UPPER (text) so in case that for example cell A1 has your lower case text, you could write it in all CAPS in cell B1, by assigning the following formula content to B1: =UPPER(A1) Using a keyboard shortcut
The easiest way to change from small to capital letters in Excel is by using the UPPER formula. But what if we want to convert the entire sentence or cell contents to uppercase? In this post we will learn about uppercasing entire sentence contents in Word and Excel. Office often automatically changes the first letter of a sentence into uppercase by default. I usually forget to capitalize when needed.
Applicable to: Excel 2019, 2016, 2013 Office 365 and standard suites Windows 7, 8, 10 and macOS operating systems.