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?