How do I get excel to automatically capitalize words

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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.
 
Back
Top