How to Automatically Convert to Proper Case as You Type in Excel

In this advance excel tutorial I will demonstrate how you can change any letter to Proper case letter in excel automatically as you type. Proper case letter means capitalize first letter of each word in a sentence. In this tutorial we are going to write a VBA and inside the VBA we’ll use excel function to force input to proper case in excel.

In this tutorial I’ll build an automatic system in excel and the amazing part is that it will tell excel to convert any text to proper case as you type. That means you write something in lowercase, uppercase or mixed case but when you press enter everything will be in proper case. Let’s learn how we can create this.

First, we need to think which sheet and which column we need to automate to change the case to proper case in excel. Once we determine that, it is just a few steps to complete the process. Let’s assume we are going to automate SHEET1, Column A. Now follow the steps below to change text to proper case in excel automatically as you type.

Step 1: Right Click on the Sheet Tab and Click on View Code.
Step 3: After writing the code you need to close the VBE (VBA Editor)
Step 4: Write something on Column A and press Enter and Done

Your text has been automatically converted into proper case in excel. That means the first letter or each word will be capital. Not only that, you are able to convert any letters to proper case letters in excel automatically.

#Excel #ProperCase #Automatic

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[JagguRDX]

This is genuine and masterpiece video - I was searching for this solution since last many years and finally got it here... Million thanks sir.... Love you

[iandurr]

On line 6:
If Intersect(Target, Range("B:D, 2:4")) Is Nothing Then Exit Sub 'In Range ("START COLUMN:END COLUMN, START ROW:END ROW")

Do you know of a way to remove a row or column from the code? For example, I want both Row 1 & Column 1 to be whatever case I select.

Thanks and I have subscribed as well.

[Shibashisha]

Hey there! I had subscribed liked and filled up the form.. But i din't got the code.. Will you please look into it..

[JagguRDX]

I have tried the code given in description box but its not working please help.... I am your subscriber

[omkarghumare]

Hey I've subscribed you channel but where is the form,
Can you please send me code..

[maureenr]

Please send me the code to change a full sheet to proper case. I have subscribed. Thank you

[chelseasnook]

I want to use this code for one column and I want to use the all uppercase code for 2 other columns. Is this possible to do? If so, can you please provide the code for using?

[richardviernes]

Hi, i had liked, subscribe and filled up the form. Hope to get the code. Thank you.

[mateuszklich]

Hello, Could you send me the code please as I have subscribed

[Antediluvian_analyst]

Please Send the code. I have subscribed your channel

[giftfriends]

Hi, I have subscribed to your channel and have requested for the code but haven't rec'd it yet. Can you please send it ASAP? Thanks