How do I get excel to automatically capitalize words

G

Guest

How do I get excel to automatically capitalize words as I type them. The
feature is enabled in Autocorrect options but when I use excel I have to keep
using my shift key if I want a capital letter. It's particularly annoying as
I'm trying to enter names in a database and have to constantly remember to
use shift on each word I type!
 
G

Guest

Hello,

Yoa can format a cell next to the one you are entering to repeat the text
you are entering in all caps by entering a formula like the one shown below.

=UPPER(A1)

Alternately, if you have a spread sheet that you are already using and do
not wish to create a duplicate cell, you may want to create a macro that
changes all the text in desired cell location by using the UCase function in
a manner similar to the one show below.

Range("A1").Value = UCase(Range("A1").Value)

Hope you find this helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top