Help needed with Microsoft Works Excel 2007?

Here's what the problem is. I don't know how to change the text case (upper or lower) with a keyboard shortcut. So please someone let me know how to do this. I know how to change the text case in Microsoft Works Word 2007 (as in any other version) -

1. Select the text or just click on the word

2. Press Shift+F3.

I have given this explanation so that whoever answers knows what I'm talking about. Thanks in advance. :)Help needed with Microsoft Works Excel 2007?
In Excel you are not provided with any shortcut key that can chage the case of contents.

but you can use a formula to change the case of one Cell



=Upper(A1)

or

=Upper(';Have a nice day';) ';It will return HAVE A NICE DAY';





Similarly you can use ';Lower'; function for changing case to Lower and through ';Proper'; for First letter of every word will be capitalized and rest part of word will be Lowered.





you can copy and paste special on the original cell



(*.*)Help needed with Microsoft Works Excel 2007?
I'm sorry...it is not possible in Excel. Have been working in Excel since 95 version and in 2007 still not available. Is available in Word and PowerPoint. Hopefully 2010 will have the feature...have not learned it yet.



Hope this was helpful.



Microsoft Expert Excel Certified 2000, 2003

http://www.theproofpositive.com