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?

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

On Nov 13, 4:31 pm, Lori G wrote:
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?

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
DTHIS
web: www.nickhodge.co.uk

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



"Lori G" wrote in message
...
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?

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.
--
Kevin Backmann


"Lori G" wrote:

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?

I think you are confusing Word and Excel.

Excel has no such feature.

Word has it under FormatFont.

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

On Tue, 13 Nov 2007 13:31:02 -0800, Lori G
wrote:

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?