When you change fonts to all caps in Excel, you convert the selected letters to uppercase. This formatting technique turns lowercase letters into uppercase while keeping uppercase letters unchanged. Changing fonts to all caps ensures consistency in the presentation of text data, making it visually uniform and easier to read. It is helpful for data matching, particularly in situations that involve case-insensitive comparisons.
In the Excel tutorial, you will learn how to change the font to all caps.
The following dataset shows company department purchases. We will change the name font to all caps for the person related to the purchase.
Here are the 8 simple ways to change the font to all caps in Excel:
Using UPPER Function
To change the font in Excel to all caps, you can use the UPPER function. You need to create a separate column to apply the formula and then copy the data to your required location.
Here are the steps to change the font to all caps with the UPPER function:
- Select a cell in a new column.
- Insert the following formula:
=UPPER(C5)
Here, you can replace cell C5 with your cell reference to change text cases. - Drag the Fill Handle down to auto-fill the remaining cells.
- Now, copy the cells that contain the text after changing cases.
- Select your desired location.
- To paste the copied cells, go to the Home tab > Clipboard group > Paste dropdown > Paste Values group > Values.
- Now, select the entire column that was generated to change the font to all caps.
- Right-click on the mouse and select Delete.
Finally, you have changed the font to all caps in your desired location.
Read More: How to Change Font Within Formula in Excel
Using Shortcut Keys
You can use the UPPER function with shortcut keys to change fonts in Excel to all caps. You need not use a formula. You just have to define the formula and the cell range to change the font case.
To change fonts to all caps with shortcut keys:
- 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 the Text
- Click OK to finish.
Finally, you have changed the font to all caps.
Read More: How to Increase Font Size Using Keyboard in Excel
Using Flash Fill Tool
The Flash Fill tool predicts the data format as soon as you type your data in a cell and generates a similar format to the remaining data. To change the font to all caps, just accept the suggested format by Flash Fill.
The Flash Fill tool may produce unexpected results if there is no recognizable pattern for it. So, it is recommended to double-check the results after applying Flash Fill.
Here are the steps to change the font to all caps using Flash Fill:
- Select a blank cell in a new column.
- Write the text in all caps.
- Press Ctrl+E to accept the predictions.
Thus, you can change the font to all caps.
Alternatively, you can use the Flash fill tool from the Home tab.
- Go to the Home tab > Editing group > Fill drop-down.
- Select Flash Fill.
You will have the font changed to all caps.
Read More: [Fixed!] Excel Default Font Is Not Changing
Using All Caps Font
There are a few built-in fonts in all caps. You can use any of the fonts to change the font in Excel to all caps.
Follow the following steps to change the font to all caps:
- Select a cell or range of cells.
- Go to the Home tab > Font group > Font drop-down.
- Now, select a font with all caps.
Thus, you can change the font in Excel to all caps quite easily.
Using Microsoft Word
There is a built-in feature in Microsoft Word to change the font cases. You can use Microsoft Word as a helping tool to change the font in Excel to all caps.
To change the font in Excel to all caps with Microsoft Word:
- Copy the entire data from Excel.
- Open a new workbook in Microsoft Word.
- Paste the copied data.
- Next, select the data to change the font to all caps.
- Go to the Home tab > Font group > Change Case feature > UPPERCASE.
You will have the selected texts in all caps.
- Copy the data from Word and paste it into Excel.
Thus, you can change the font in Excel to all caps.
Using VBA
You can change fonts in Excel to all caps using VBA. Follow the steps:
- Select a cell or a range of cells.
- Go to the Developer tab > Visual Basic to open the Visual Basic Editor.
- Go to the Insert tab > Module.
- Copy and paste the following VBA code:
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.
Finally, you have changed the font to all caps.
Using Power Query
Power Query is highly efficient in connecting, transforming, and cleaning data from various sources. You can use the Power Query tool to change the font in Excel to all caps.
Here are the steps to change the font to all caps with Power Query:
- Select the data.
- Go to the Data tab > Get & Transform Data group > 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.
A Power Query Editor will pop up.
- Next, go to Add Column tab > From Text group > Format feature > UPPERCASE.
- Go to the Home tab > Close & Load.
Finally, you have changed the font of the selected data to all caps.
Using Cell Styles
For a one-click transformation, you can use Cell Styles to change fonts in Excel to all caps. Before that, you have to set an all-caps font to the cell styles.
To change the font to all caps in Excel with Cell Styles:
- Go to the Home tab > Styles > Cell Styles.
- Now, 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 > Font.
- Select an all-caps font and click OK.
- Click OK again from the Style box.
- Now, select a range of cells.
- Go to the Home tab > Styles group > Cell Styles drop-down > HEADING 2.
Thus, you can set a format to change the font in Excel to all caps with just one click.
Read More: How to Change Default Font in Existing Excel Workbook
Download Practice Workbook
You can download the workbook and practice by yourself.
Conclusion
In this article, we have discussed 8 simple ways to change the font in Excel to all caps. You can do this by using the UPPER function, the Flash Fill tool, selecting the all-caps font, and using Cell Styles. You can export data to Microsoft Word to change the font to all caps. Advanced tools, like VBA and Power Query, can also be used to perform the same task. If you have any questions or opinions, feel free to share them in the comments section below.
Frequently Asked Questions
Is it possible to change the font in Excel to all caps in a single click?
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.
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 3 built-in functions in Excel to change the font’s case.
- For Upper Case: =UPPER(B5)
- For Lower Case: =LOWER(B5)
- For Title Case: =PROPER(B5)
Related Articles
- How to Increase Font Size for Printing in Excel
- How to Lock Font in Excel
- [Fixed!] Unable to Change Font Color in Excel
- [Solved]: Font Changes Automatically in Excel
- How to Change Font in Excel for All Sheets
- How to Change Font Size in Excel
- How to Change Font Style in Excel
<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!