Type in all caps

L

Lori G

I thought I had previously been able to check a box in the formatting menu
that said All Caps to have the text type in caps automatically. Could someone
please tell me if I am losing my mind. I thought it was in the same area as
the option to print gridlines?
 
J

JP

You might be referring to the Spelling tab which has a checkbox you
can mark to tell Excel to not autocorrect text that is ALL UPPERCASE.


HTH,
JP
 
N

Nick Hodge

Lori

I think you're confusing it with Word. In Excel you will need to use a
helper column and the UPPER function

=UPPER(A1)

For example. You can then copy that data and Paste Special...+Values over
the old.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
K

Kevin B

You can do that in MS Word with a <Ctrl> + <Shift> + K, but I don't know of a
way to do that in Excel, unless you have a small caps font face that you can
apply.
 
G

Gord Dibben

I think you are confusing Word and Excel.

Excel has no such feature.

Word has it under Format>Font.

With Excel you can use the Caps Lock or event code or the UPPER function or a
macro to change case after the fact.


Gord Dibben MS Excel MVP
 

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