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?