Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.

link|improve this question

80% accept rate
feedback

2 Answers

up vote 2 down vote accepted

Paul's suggestion is good or you can write your own macros and assign shortcut keys

 Sub makeUPPER()
  ActiveCell = UCase(ActiveCell)
 End Sub

 Sub makeLOWER()
  ActiveCell = LCase(ActiveCell)
 End Sub
link|improve this answer
Simpler and better. Thanks. – mydoghasworms Jun 7 '11 at 15:02
feedback

If you install the excellent ASAP Utilities Excel addin (free for personal use)...

http://www.asap-utilities.com/download-asap-utilities.php

this has in built UPPER CASE and lower case options (as well as a zillion others) which you can assign shortcut keys to (see their website for more info)

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.