answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

10y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

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

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change capital letters to small letters in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How can you change small letters to capital letter in Microsoft word?

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.


IS re small or capital letters?

re is small letters; RE is capital letters.


How can you change capital letters to small letters in MS Office 2007?

If they have already been typed, in Microsoft Word and Powerpoint select them all and then press Shift-F3 and you can change between the different case options, including upper, lower and sentence case. In Excel, you need to use the LOWER function.


What is represented by capital letters angle or side?

Angles are represented by capital letters. Small letters refer to sides.


Does capital letters in email id equivalent to the regular small letters?

yes.


What is the difference between toggle case and sentence case?

i think title case starts titles with capital letters while sentence case is starting sentesces with a capital letter


Why v of volume is capital p of pressure is in small letters?

why the v of volume & p of pressure is in small letters ?


How do you put in small letters for a code if your code keyboard doesn't show small letters only capital?

... Press capslock?


What is change case?

Change case is the change of parameters of text.That means that if you have your text in all small letters, you can make it to be all capitalized or vice versa.Also, you can automatically make all first letters of each sentence capital, if you have only small case text.For more information see related link bellow.


Capital or small case letters that represent numbers?

love


How can change small letter text to capital letter text viz virsa in word excel?

Highlight what you want to change, press Shift+F3 to switch between "all small letter", "all caps" and "only first letter of words caps".


Why Jehovah witnesses say that holy spirit in the original Greek text is in small letters?

Ancient greek does not have small (or capital) letters