how do i turn all letters into capital letters?

G

Guest

In excel, how can i type any letters and it will turn to capital letter
automatically?
 
D

David McRitchie

Hi Keith,
Assuming that you mean for some specific columns on a specific
worksheet, you would use an Event macro...

See the event macro under topic
http://www.mvps.org/dmcritchie/excel/proper.htm#upper
you would customize the macro so that it only processes
certain columns. As shown it processes column 6 (Col F) and
will not process row 1. It must be installed as Event macro
by right clicking on the sheet tab then View code.

As for Caps-Lock (see my shortx2k.htm page)
The next best thing to removing the caps lock key, or depression
obstruction is to have it make a noise, and would be what you
would choose for a laptop to avoid physical damage:
Windows Control Panel, accessibility, ToggleKeys option will
provide sound when invoking/revoking Caps Lock, Scroll Lock,
or NumLock keys. (two tones ON/off}


"KeithT" wrote...
 

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