In this advance excel tutorial you’ll be amazed to see how you can change any letter to uppercase letter in excel automatically as you type. In this tutorial we are going to write a VBA and inside the VBA we’ll use excel UCase function to force input to uppercase in excel.

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

First, we need to think which sheet and which column we need to automate to change font to all caps 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 uppercase in excel automatically as you type.

Step 1: Right Click on the Sheet Tab and Click on View Code.
Step 2: In the VBA Editor Write the code (Please subscribe and here goes the code: https://www.patreon.com/posts/40832898)
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 capital letters in excel. This is how you can convert small letter to capital in excel. Not only that, you can able to convert any letters to capital letters in excel automatically.

#Excel #ConvertToCapital #Automatically

Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Please take the opportunity to connect and share this video with your friends and family if you find it useful.