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.
📁 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.
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.
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.
- Then, fill up the first cell using all capital letters. We have done this in cell C6.
- 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.
- 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.
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
- COPPERPLATE GOTHIC
- Goudy Stout
- Perpetua Titling MT
- Showcard Gothic
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.
- 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.
- 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.
- Finally, you can see that all the letters are now in uppercase form.
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.
- After that, open a Microsoft Word file.
- Then, paste the copied column into that file.
- 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.
- Thus, we have capitalized all the alphabets.
- Now, copy this and paste it into your Excel file in the desired column.
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.
- Next, a window named Create Table will pop up.
- From there, tick the My table has headers option, and then click OK.
- 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.
- You will see a column is created under the header UPPERCASE. Notice that in that column all data are capitalized.
- After that, go to the File tab and then select the Close and Load option from there.
- The editor will be closed and a new sheet will be opened in the Excel file, including the capitalized column.
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.
- Then, in the first row, insert the first data, capitalizing the first letter only.
- For example, here we have inserted Chicago, in cell C6.
- 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.
- Finally, press Enter from the keyboard and see that all columns are now automatically filled.
📝 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.
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.
- 7 Quick Ways to Calculate Average Percentage Increase in Excel
- 3 Steps to Group Age Range in Excel Using VLOOKUP
- 6 Quick Ways to Create Dynamic List from Table in Excel
- 11 Examples to Do SUMIF in Date Range of Month and Year
- 7 Ways to Calculate Average Attendance with Formula in Excel