How to Change Font in Excel to All Caps (8 Simple Ways)

Absolutely possible. You can set the all-cap font from Cell Styles and use it to change the font to all caps in a single click.

The following dataset shows company department purchases. We will change the name font to all caps for the person related to the purchase.

Overview of Changing Font to all caps

Method 1 – Using the UPPER Function

You can replace C5 with your cell reference to change text cases.

Applying Upper Function

Select your desired location.
To paste the copied cells, go to the Home tab, select the Paste dropdown, and choose Values.
Select the entire column that was generated to change the font to all caps.
Right-click on the mouse and select Delete.
We have changed the font to all caps in your desired location.

Select a cell in a new column.
Press Shift + F3.
From the Insert Function dialog box:
- Choose All from Or select a category.
- Pick the UPPER function from Select a function.
- Click on OK.
In the Function Arguments dialog box:
- Define the range from the dataset in Text.
- Click OK to finish.
This changed the font to all caps.

Alternatively, you can use the Flash fill tool from the Home tab.

Copy the entire dataset.
Open a new workbook in Microsoft Word.
Paste the copied data.
Select the data to change the font to all caps.
Go to the Home tab and select the Change Case feature, then choose UPPERCASE.

Select a cell or a range of cells.
Go to the Developer tab and select Visual Basic to open the Visual Basic Editor.
Go to the Insert tab and pick Module.

Copy and paste the following VBA code into the module:

Sub AllCaps()
For Each Cell In Selection
If Not Cell.HasFormula Then
Cell.Value = UCase(Cell.Value)
End If
Next Cell
End Sub

Select the data.
Go to the Data tab and choose From Table/Range.
A Create Table dialogue box will pop up.
From the Create Table dialog box:
- Insert the cell range.
- Check My table has headers if you have any headers in your dataset.
- Click on OK.
The Power Query Editor will pop up.
Go to the Add Column tab, select the From Text group, choose the Format feature, and pick UPPERCASE.
Go to the Home tab and choose Close & Load.
Here’s the result.

Go to the Home tab and select Cell Styles.
Right-click on Heading 2 and select Modify.
A Style dialog box will appear
Check only the Font box and click on Format.
A Format Cells dialog box will pop up.
From the Format Cells dialog box:
- Go to the Font tab and select Font.
- Select a font with only uppercase letters and click OK.
Click OK again from the Style box.
Select a range of cells.
Go to the Home tab and choose the Cell Styles drop-down, then apply HEADING 2.
Here’s the result.