4 Approaches to Capitalize All Letters in Excel Without Formula

You do not need to use any formulas in order to make all of the letters in your Excel dataset capitalized. Excel comes with a number of pre-programmed features that can be utilized to complete this task. But in this article, we’ll talk about 4 simple and straightforward ways to capitalize all letters in Excel without using formulas. We are going to discuss how to use Flash Fill, all-caps fonts, Microsoft Word, and Power Query to capitalize all letters in Excel without formula. As you can see from the below picture, we have used one all-caps font to capitalize all letters in Excel.

Capitalize all letters- before and after


📁 Download Excel File

Download the Excel file we used to create this article so you can practice.


Learn to Capitalize All Letters in Excel Without Formula Using These 4 Approaches

It is possible if you wish to capitalize the entire dataset contained within your Excel file. Excel is equipped with a wide range of helpful features that can be utilized in these situations. You will be able to accomplish this process in a variety of ways. Even if you don’t want to use any formulas, you can still do it. If you want to know how to properly capitalize all of the data in your Excel file, then you should continue reading this article.

This article is going to discuss 4 easy methods of how to capitalize all letters in Excel without a formula.

Approach

 1. Apply Flash Fill Feature to Capitalize Letters

You can use the Flash Fill feature of Excel to fill up all the cells automatically. Flash Fill is a built-in feature of Excel, that follows a pattern. If you start to enter data that was previously inserted in your Excel file but only change the style, the Flash Fill feature will automatically detect this pattern and fill other cells. But you have to enter the first cell manually and the first word of the 2nd cell, only then it will be able to detect this and will suggest the rest. If this feature is not working on your computer, then you have to enable it first. To enable this follow the steps below.

  • Go to the File tab of Excel.
  • From there go to the Options.
  • Then a window named Excel Options will open.
  • You have to choose the Advanced option from there.
  • Then, tick on the Automatically Flash Fill, then press OK.

Enable flash fill in Excel

Now as you have enabled this feature, you can use this feature to capitalize all words in Excel. Let’s see how to use this feature to capitalize all letters in Excel.

⬇️⬇️ STEPS ⬇️⬇️

  • First of all, create a new column where you will capitalize the letters. We have used a column named Uppercase Form.

Entering new column

  • Then, fill up the first cell using all capital letters. We have done this in cell C6.

Manually fill the first cell

  • After that, in the next cell, type only the first letter of the text in capital letters. For example, we have typed L for LONDON.

Using Flash Fill to capitalize all letters in Excel without formula

  • You can see that all other words are now suggested in capital form due to the Flash Fill feature.
  • After, pressing Enter from the keyboard, you will see that the cells are auto-filled with all letters capitalized.

After pressing Enter from the keyboard and applying Flash Fill to capitalize all letters in Excel without formula

Approach

2. Use All-Caps Font for Capitalizing All Letters

There are some all-caps fonts in Excel that can be used to capitalize all letters. That means these fonts contain only uppercase letters. We have listed all these fonts below.

  • FELIX TITLING
  • ENGRAVERS MT
  • STENCIL
  • ALGERIAN
  • COPPERPLATE GOTHIC
  • Castellar
  • Goudy Stout
  • Perpetua Titling MT
  • Showcard Gothic
  • Stencil

You can use any of these fonts to capitalize all letters. Let’s see the steps to get a clear idea.

⬇️⬇️ STEPS ⬇️⬇️

  • First of all, insert a column where you will capitalize the letters.
  • Then, copy all the words that you want to capitalize. To copy, select the cells and press Ctrl+C on your keyboard.

Copy data to capitalize all letters in Excel without formula

  • After that, go to the new column and press Ctrl+V to paste the copied column. You will see that the column is now filled with the copied texts.

Paste the copied data

  • Now, select this new column and go to the Menu Bar.
  • From there, select Home and from the Font group, select any of the fonts mentioned above.
  • We have selected the font named ALGERIAN.

Changing font to capitalize all letters in Excel without formula

  • Finally, you can see that all the letters are now in uppercase form.

Result after changing font

Approach

3. Capitalize Letters in Microsoft Word and Transferred to Excel

You can simply use Microsoft Word to change the lowercase to uppercase. But we can’t do it inside the Excel file, that’s why we will capitalize all letters in Word and then bring them back into Excel. Follow the process below to learn more.

⬇️⬇️ STEPS ⬇️⬇️

  • To begin with, select the cells that contain the data that you want to capitalize. Copy that using Ctrl+C on your keyboard.

Select and copy cells to capitalize

  • After that, open a Microsoft Word file.
  • Then, paste the copied column into that file.

Paste this to Microsoft Word

  • Then, select the full data and go to the Menu Bar.
  • From there, go to the Home option.
  • Click on the Case Change (Aa) icon, and select UPPERCASE.

Change the font style to UPPERCASE

  • Thus, we have capitalized all the alphabets.

After changing the fonts to UPPERCASE

  • Now, copy this and paste it into your Excel file in the desired column.

Paste this changed style to Excel

Approach

4. Utilizing Excel Power Query for Capitalization of Letters

The Power Query feature of Excel can enable you to extract any data from your Excel file and Connect, Transform, Load, and Combine data according to your choice. We have used this to insert a column containing all letters capital. We have discussed the process step by step below.

⬇️⬇️ STEPS ⬇️⬇️

  • First, select any of the cells of your data.
  • Then, go to the Menu Bar. From there select the Data option.
  • After that, select From Table/Range from the Get & Transform Data group.

Open the Power Query Editor

  • Next, a window named Create Table will pop up.
  • From there, tick the My table has headers option, and then click OK.

Create Table

  • Due to this, a window named Power Query Editor will open.
  • In this window, select Add Column from the Menu Bar and then click on Format.
  • From the drop-down menu click on UPPERCASE.

Change format in Power Query Editor

  • You will see a column is created under the header UPPERCASE. Notice that in that column all data are capitalized.

After changing the format to UPPERCASE

  • After that, go to the File tab and then select the Close and Load option from there.

Close and Load Power Query Editor

  • The editor will be closed and a new sheet will be opened in the Excel file, including the capitalized column.

Capitalized all letters applying Power Query Editor after changing the format to UPPERCASE


How to Capitalize First Letter in Excel

You can capitalize only the first letter of your text string. You can do it in numerous ways, with function or without using function. Without using the function, you can use VBA code, the Flash Fill feature. In this article, we are going to discuss the Flash Fill method for doing so.

⬇️⬇️ STEPS ⬇️⬇️

  • First, create a new column where you will be inserting the new capitalized data.

Add a new column

  • Then, in the first row, insert the first data, capitalizing the first letter only.
  • For example, here we have inserted Chicago, in cell C6.

Enter the first cell by capitalizing the first letter

  • After that, enter only the first letter of the second data in the second row. We have entered the L for London.
  • Then, you will notice that Excel is suggesting you all other data, capitalizing the first alphabet.

Suggested pattern by Flash Fill feature

  • Finally, press Enter from the keyboard and see that all columns are now automatically filled.

Entering the Flash Fill suggested pattern


📝 Takeaways from This Article

📌  You have learned how to capitalize all letters in Excel without using any formula.

📌  An overall idea of how to use the Flash Fill feature and Power Query.

📌  You got an idea about how to capitalize only one word without writing any formula.


Conclusion

If you want to avoid using Excel formulas this article can be a rescue for you. These methods that we demonstrated above are easy to do and also time efficient. Please leave a comment if you have any suggestions or questions. Don’t forget to visit our Excelden page to enhance your Excel-related knowledge.


Related Articles

(Visited 39 times, 1 visits today)
Lamisa Musharrat

Lamisa Musharrat

Hey there! I am Lamisa Musharrat, a Marine Engineer and a Content Developer. I love to help people by writing articles for them. Hope you will enjoy my blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo