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?