Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

4 Answers 4

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
share|improve this answer
    
Simpler and better. Thanks. –  mydoghasworms Jun 7 '11 at 15:02

I used the following technique to convert a column of text to uppercase.

  1. Move the cursor to a blank column.
  2. In the empty cell on the same row as the first cell you want to convert, type =upper(A3), if A3 is the first cell you want to convert.
  3. The previously empty cell should now show the upper case equivalent of your first cell of text.
  4. Copy this cell down the column to the same height as all of your text.
  5. You should now have a column equivalent to your text, but all in uppercase.
  6. Highlight all of the cells of uppercase text, and select copy.
  7. Left-click on the first cell of your source text (which is not in uppercase), which will select the cell.
  8. Right-click.
  9. Select Paste Special
  10. In the list box, select "Values" radio button, and click OK.
  11. You will now have 2 columns of upper case text.
  12. Delete the column containing the =upper() formulas.

The same principle works for Proper, and other text manipulation functions.

share|improve this answer

Check out this link: http://www.nucleation.in/change_case/

Change Case Excel Add-In is a simple tool that can help you in changing case of the selected cells in Excel.

This Add-In has the following features

a. Change case of selected cells to ‘UPPER CASE’

b. Change case of selected cells to ‘lower case’

c. Change case of selected cells to ‘Proper Case’

d. Change case of selected cells to ‘Sentence case’

e. Change case of selected cells to ‘tOgGlE cAsE’

f. Customizable shortcut keys to perform change case actions

share|improve this answer

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

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

this has built-in 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)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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