how do i turn all letters into capital letters?

K

KeithT

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}
---
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...
 

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

Similar Threads

How to remove a combination of letters and special characters 2
Help With Typing Russian Letters On Microsoft Word Mac 0
Problem with SET & REF function 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Excel --> Word 4
VBA - exporting serial letters to single documents 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Keyboard Mistyping - as if a computer virus - only happens in Outlook (www.portal.office.com) 0

Top