- 1). Launch Excel and open the Excel file that contains the text you want to change to an uppercase font. Insert a new column, or select an empty one on the spreadsheet. Select a column by clicking on the corresponding letter at the top.
- 2). Click once in the top blank cell in the new column. Type "=UPPER" into the cell, followed by the call name in the same row that contains text that you want to change to uppercase in parentheses. For example, you may type "=UPPER(A1)" into cell B1, to change the text in cell A1 to uppercase.
- 3). Fill the UPPER formula throughout the rest of the column. Select the cell into which you typed the formula, and double-click the small, black square in the lower-right corner. After the formula is filled, all the cells in the column are highlighted.
- 4). Right-click once on a cell in the column and select the "Copy" option. Right-click once on the top cell of a column that you want to change to uppercase. Select the "Paste" option and click "Values" to change the text in the column to uppercase. Repeat this step for each column in the worksheet that you want to change to uppercase.
SHARE
