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

Use the "Caps Lock" key.
--
David Biddulph

"KeithT" wrote in message
...
In excel, how can i type any letters and it will turn to capital letter
automatically?

use following function
=upper(cell reference)

"KeithT" wrote:

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

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}
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"KeithT" wrote...
In excel, how can i type any letters and it will turn to capital letter
automatically?