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?