While the Excel 2010 "UPPER" function will convert a text string to upper case, the function only succeeds in creating a new cell with the upper case text, instead of converting an existing cell. To change all text in an entire worksheet to upper case, you'll need to use Visual Basic for Applications (VBA), which is a programming language that comes bundled with Excel. VBA can create a macro that will change every piece of text to upper case with the click of a button.
- Skill level:
Other People Are Reading
Open the Excel worksheet.
Press Alt and F11 to bring up the Excel 2010 VBA console. Once the console opens, find the name of your workbook on the list on the left side of the screen. Right-click the workbook name, move your mouse over "Insert" and select "Module." Double-click the module that appears.
Click anywhere in the blank white space on the right side of the VBA console. Type in the following: "Sub UpperCaseConvert()" and press Enter. VBA will automatically insert the "End sub" command at the bottom of the code.
Type "Dim x As Range" into the line directly beneath the "Sub" line. This will create a variable, "x," that you will need later in the VBA code. Press Enter to access the next line.
Enter the following code into the VBA console:
For Each x In Cells.SpecialCells(xlConstants, xlTextValues)
x.Formula = UCase(x.Formula) Next
This will go one-by-one through every cell that contains text on your worksheet and convert it to upper case. Click the "X" in the top-right corner of the VBA console to close it.
Click the "Developer" tab at the top of the Excel screen. Click the "Macro" button, which is located in the "Code" area of the ribbon. Select "UpperCaseConvert" from the list of macros and click "Run."
Tips and warnings
- The "Developer" tab in Excel might not be visible by default. If you don't see it, click the "File" tab and select "Options." Click "Customize Ribbon" and look for "Developer" in the right column. Click the box next to "Developer" to add a checkmark, then click "OK" to close the options window.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for