How to make capital letters small in Excel Online

Case change is a useful feature that is available in almost all modern services, including Excel Online . Thanks to this tool, you can quickly replace the text printed in capital letters with lowercase letters in a document. Most often, users need this feature if Caps Lock was quietly turned on, and there is no time, effort or desire to retype the document again. How to quickly make capital letters small - later in the article.

How to make capital letters small in excel

In the case of Excel Online, the most popular and easiest way to change the case of text does not work - the key combination "Shift" and "F3" . Unfortunately for users of the service. But this does not mean that it is impossible to do this simple action on the platform. There are at least 2 ways . The first is correcting capital letters to lower case using case. For this you need:

1. Open document;
2. Select all text in the document or only the area in which you want to change the text;
3. On the toolbar, select the section "Format" ;
4. In the window that appears, click on the subsection "Text" ;
5. In the next menu, select the item "Lower letters" .

The text will automatically change from uppercase to lowercase. This is a quick and easy way, but there is a more advanced way - using a formula.

How to make capital letters small in Excel Online via formula

Formulas are the backbone of Excel Online. The platform has its own formula for almost every action, which simplifies the work with the service and makes it multifunctional and universal. This also applies to working with texts. In order to change all capital letters to small letters, you need:

1. Open document;
2. Click on an empty cell next to the one in which you want to replace the text;
3. In the cell, enter the formula: "=LOWER" and click on the cell in which the text should be changed;
4. Press the "Enter" key .

In the same cell in which the formula was written, the text from the first cell will appear, only written in lowercase letters. In order for the text to appear in the desired cell, you just need to copy it and paste it in place to replace using the "Copy" and "Paste" options or the keyboard shortcuts "Ctrl + C>" and "Ctrl + V>".