Type in all caps
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? |
Type in all caps
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? |
Type in all caps
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? |
Type in all caps
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? |
Type in all caps
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? |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com