How do you change capital letters to small letters in Excel?

Answer 1

It would be different in different applications. In Word and Powerpoint, select the text and press Shift-F3 to change between different cases. In Excel and Access use the UPPER function, to convert text.

Answer 2

There is no way of doing it with shortcut keys in Excel, like you can with Shift + F3 in Word. What you can do is use the Upper function. Go to a blank cell. Say then that your text is in cell A15 and you want to convert it to upper case. First in the blank cell type in a formula as follows:

=Upper(A15)

You will now have a copy of the original text, all in capitals. The select that cell and do a copy. Go to the original cell where the text is, in this case A15, and go to the Edit Menu and pick Paste Special. On the dialog box that appear, click the box beside values and then click OK. Your original text will be replaced by the text in capitals. You can then delete the Upper formula.

Answer 3

There is no option, like in MS Word to format cells for letter case, but you can use the LOWER function to do so. If your upper-case word is in A2, then in B2 put the formula =LOWER(A2). You will observe the result is the same text as in A2, except all the letters are in lower case.

Answer 4

There are various options of changing small letters to capital letters in Microsoft Word. You can use the task bar to change to upper case or press shift and f3 on your computer keyboard.

Answer 5

In Word, you cans use Shift - F3 to change between different cases. See the related question below for what to do in Excel.