The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Here we introduce the Change Case utility of Kutools for Excel, with this utility, you can easily capitalize all letters in selected range or whole column in Excel. Then all letters in selected range are all capitalized immediately.Ĭapitalize all letters in cell or column with Kutools for Excel In the popping up dialog box, select the range with letters you want to capitalize, and then click the OK button. Set WorkRng = Application.InputBox('Range', xTitleId, WorkRng.Address, Type: = 8)Ĥ. VBA code: Capitalize all letters in a range Sub ToggleCase() Copy and paste below VBA code into the Module window. In the Microsoft Visual Basic Application window, click Insert > Module.ģ.

Press ALT + F11 keys simultaneously to open the Microsoft Visual Basic Application window.Ģ. Download and try it now! ( 30-day free trail)Ĭapitalize all letters in a range with VBA codeīesides the formula method, you can run VBA code to capitalize all letters in a range.ġ.

With the help of Kutools for Excel's Change Caes utility, you can quickly change the text strings to upper case, lower case, proper case, sentence case and so on in a colomn as below screenshot shown. Easily make entire column capital or lowercase in Excel:

Make all text uppercase excel