How to Stop Auto Capitalization in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

Auto Capitalization is often a handy feature of Excel. But sometimes it can be a frustrating thing as Excel does Auto Capitalization by default. In this article, we are going to learn 5 quick steps to stop Auto Capitalization in Excel.


What Is Auto Capitalization?

In Microsoft Excel, when you enter data into cells, Excel tries to correct your mistakes and automatically capitalizes the first letter of a sentence. When you insert data in a cell, Excel thinks of it as the first letter of the sentence. As a result, it is also capitalized automatically by Excel.

Let’s have a look at the following screenshot where the text is auto capitalized by default.

how to stop auto capitalization in excel


How to Stop Auto Capitalization in Excel: 5 Steps

If you want to cancel this Auto Capitalization feature in Excel, you can use the following steps.

In the below-given data set, we have some words and a sentence in which Excel’s Auto Capitalization feature was enabled. We will turn off this feature and afterward, we will check whether it is working or not.

how to stop auto capitalization in excel


Step 1: Go to Files from Ribbon

First, go to the Files tab from the ribbon.


Step 2: Select Options from Excel Home

After that, click on the Options from Excel’s Home. You can find it on the bottom right side of the screen.

how to stop auto capitalization in excel Select Options from Excel Home

Note: You can press ALT + F to open the File menu.


Step 3: Choose Proofing from Excel Options Dialogue Box

Now, a dialogue box will open named Excel Options. Select Proofing from the Excel Options dialogue box.

how to stop auto capitalization in excel Choose Proofing from Excel Options Dialogue Box

Note: Also, you may open the Excel Options dialog box directly by pressing ALT + F + T.


Step 4: Click on AutoCorrect Options

After selecting Proofing from the Excel Options dialogue box, click on the AutoCorrect Options as marked on the picture below.


Step 5: Uncheck Capitalize First Letter of Sentences

Now, another dialogue box will pop up. Under the AutoCorrect tab in this dialogue box, you will find Capitalize the first letter of sentences. Make sure that you uncheck the box. Then press OK, and the dialogue box will close.

After that, again press OK in the Excel Options dialogue box.

how to stop auto capitalization in excel Uncheck First Letter of Sentences 

Then you will be redirected to your Excel workbook. Now, type the words and the sentence into the cells of Column C from Column B.

how to stop auto capitalization in excel Uncheck First Letter of Sentences 

You can see that Excel is no longer Auto Capitalizing the words.

Read More: Automatic Uppercase in Excel VBA


Things to Remember


Download Practice Workbook


Conclusion

We have come to the very end of our article. I truly hope this article could guide you to stop Auto Capitalization in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. Happy learning!


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zahid Hasan
Zahid Hasan

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo