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

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

  • Select a cell in a new column.
  • Insert the following formula: =UPPER(C5)

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

  • Drag the Fill Handle down to autofill the remaining cells.

Applying Upper Function

  • Copy the cells that contain the text after changing cases.

Copying the Output

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

Final Output of Using UPPER Function

Read More: How to Change Font Within Formula in Excel

Method 2 – Using Shortcut Keys

  • Select a cell in a new column.
  • Press Shift + F3.
    Select a cell in a new Column
  • From the Insert Function dialog box:
    • Choose All from Or select a category.
    • Pick the UPPER function from Select a function.
    • Click on OK.

    Selecting UPPER Function

  • In the Function Arguments dialog box:
    • Define the range from the dataset in Text.
    • Click OK to finish.

    Defining the Range

  • This changed the font to all caps.

Final Output of Using Keyboard Shortcuts

Read More: How to Increase Font Size Using Keyboard in Excel

Method 3 – Using Flash Fill

  • Select a blank cell in a new column.
  • Write the text in all caps.
  • Press Ctrl + E to accept the predictions.
    Using Flash Fill Tool
  • This changes the entire column.

Output of Using Flash Fill

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

  • Go to the Home tab and select the Fill drop-down.
    Selecting Fill From Home
  • Select Flash Fill.
    Selecting Flash Fill
  • Here are the results.

Output of Using Flash Fill

Read More: [Fixed!] Excel Default Font Is Not Changing

Method 4 – Using an All Uppercase Font

  • Select a cell or range of cells.
  • Go to the Home tab and click on the Font drop-down.
    Going to Font Drop down
  • Select a font that doesn’t have lowercase letters. Selecting All Caps Font
  • Here’s a sample result.

Output after Changing All Caps Font

Method 5 – Using Microsoft Word

  • Copy the entire dataset.
    Copying the Data
  • 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.

Changing Cases in Word

  • Here’s the result.

Upper Cases in Word

  • Copy the data from Word and paste it into Excel.
    Final Output After Copying from Word

Method 6 – Using VBA

  • Select a cell or a range of cells.
    Selecting Cell Range
  • Go to the Developer tab and select Visual Basic to open the Visual Basic Editor.
    Opening Visual Basic Editor
  • Go to the Insert tab and pick Module.
    Creating a 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
  • Click on Run.
    Running the Code
  • Here’s the result.

Output of Excel VBA

Method 7 – Using Power Query

  • Select the data.
    Selecting Data
  • Go to the Data tab and choose From Table/Range.
    Defining 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.

    Defining Range

  • 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.
    Changing the Case
  • Go to the Home tab and choose Close & Load.
    Load in a new Sheet
  • Here’s the result.

Output after Using Power Query

Method 8 – Using Cell Styles

  • Go to the Home tab and select Cell Styles.
  • Right-click on Heading 2 and select Modify.
     Going to Heading 2
  • A Style dialog box will appear
  • Check only the Font box and click on Format.
    Selecting Font Only
  • 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.

     Setting the Font

  • Click OK again from the Style box.
    Confirming the Font
  • Select a range of cells.
  • Go to the Home tab and choose the Cell Styles drop-down, then apply HEADING 2.
    Selecting Heading2
  • Here’s the result.

Output after Changing Cell Styles

Download the Practice Workbook

Frequently Asked Questions

Is it possible to change the font in Excel to all caps in a single click?

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

Does changing the font to all caps affect sorting and filtering in Excel?

No, changing the font to all caps does not affect sorting and filtering in Excel.

What functions are to be used to change the font cases in Excel?

There are three built-in functions in Excel to change the font’s case.

  1. For Upper Case: =UPPER(B5)
  2. For Lower Case: =LOWER(B5)
  3. For Title Case: =PROPER(B5)

Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!


Yousuf Khan
Yousuf Khan

Yousuf Khan has been working with the ExcelDemy project for over one year. He has written 47+ articles for the ExcelDemy site. He also solved a lot of user problems with ExcelDemy Forum. He has interests in Excel & VBA, Desktop and mobile applications, and projects & templates. He completed his graduation and post-graduation in Information Technology from Jahangirnagar University. Currently, he works as a VBA & Excel Content Developer in ExcelDemy projects, writing unique and informative content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF