How to change all caps letters to lower case in excel

August 1, 2022
1.1K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

If you're a lover of typography, then you'll appreciate the power of lower-case letters. In this Excel tutorial, we'll show you how to change all caps letters to lower case in excel in just a few simple steps. This is an easy way to improve your look and feel for your data sheets, making them more legible and user-friendly.

If you frequently work with text in Excel, you may have noticed that the default formatting of text is in to change all caps to lowercase in excel. This can be a bit of a pain if you're more comfortable working in lowercase, as all the sudden everything needs to be converted. Fortunately, it's easy to change the text formatting in Excel so that all text is lowercase. Here's how: 1. In the ribbon, click the home tab and then click the Font group.

If you're a fan of typing in all caps, you may be dreading the day when you must start typing in lowercase. In this article, we'll show you how to change all caps to lowercase in Excel quickly and easily.

How to Change All caps to Lowercase in Excel?

In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.

1. First, insert a temporary column next to the column that contains the text you want to convert. In this case, we’ve added a new column (B) to the right of the Customer Name column.

2. In cell B2, type =PROPER(A2), then press Enter.

3. A2 this formula takes the name in cell, converts it to uppercase, and returns it. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

Now, fill down the formula in the new column. The quickest way to do this is by selecting cell B2, and then double-clicking the small black square that appears in the lower-right corner of the cell.

4. At this point, the values in the new column (B) should be selected. Press CTRL+C to copy them to the Clipboard.

5. Right-click cell A2, click Paste, and then click Values. This step enables you to paste just the names and not the underlying formulas, which you don’t need to keep. You can then deselect column (B), as it is no longer required.


In conclusion, if you want to change all caps to lowercase in Excel, there are a couple of methods you can use. The easiest way is to use the standard keyboard shortcut: CTRL + L. Another way is to click on the textbox containing the all caps text, and then select the Edit > Copy option. Finally, right-click on the selection, and select Paste Special > Convert All Caps To Lowercase.

In conclusion, if you want to change all caps letters in a document to lowercase letters, you can do so by following these simple steps:

1. Select the entire text you want to change and press CTRL + L.

2. In the resulting dialogue box, click on the Text Formatting tab and select Lowercase.

3. Click on OK to apply the changes.


Has this process helped you learn about how to change column width in excel? If you want to find out more about excel functions and features, you can view and subscribe to WPS Academy to learn.

You should also download and use WPS Office to edit Excel, PowerPoint, PDF, and Word documents for free. Download now and enjoy these free services! With WPS Office, you can create a simple and enjoyable working environment.