Lower Case in Excel

Updated on December 28, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Top 6 Methods to Change Capital Letters to Lower Case

There are many methods to change capital letter text to lowercase in Excel. This guide will look at the top 6 ways to make capital letters into lower cases.

You can download this LowerCase Excel Template here – LowerCase Excel Template

#1 Using Lower Function to change case in Excel

MS Excel has a built-in function for decapitalizing each character in a word, a LOWER function.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Example

Suppose we have a list of some verbs in Excel. We want to change the case of the text to lowercase.

Lower Case Example 1.1

To change the case to lower, we need to write the function in cell C2 as ‘=LOWER(A2)’. The”=’ or ‘+’ sign is used to write the function, the “LOWER” is the function name, and A2 is the cell referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more for the text we want to change the case.

Lower Case Example 1.3

Press the “Enter” key. This function will convert all letters in a text string to lowercase.

Lower Case Example 1.2

One value is converted now. For other values, we can either press the “Ctrl+D” key after selecting all the cells with the top cell or press the “Ctrl+C” and “Ctrl+V” for copying and pasting the function. Else, we can drag the formula to other cells to get the answer.

Excel Lower Case Example 1

#2 Using VBA Command Button

We can create a VBA command button and assign the code to change the following text to lowercase using the command button.

Lower Case Example 2.1

Example

Step 1:  To create the command button, click on the “Insert” command in the “Controls” group in Developer tab ExcelDeveloper Tab ExcelEnabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. This tab is disabled by default on excel; thus, the user needs to enable it first from the options menu.read more.’ And select the “Command Button.”

Lower Case Example 2.2

Step 2: Click the worksheet location where we want the command button to appear. We can resize the command button using the “ALT” button.

Lower Case Example 2.3

Step 3: Using the “Properties” command, change the properties of the command button like caption, name, AutoSize, WordWrap, etc.

Lower Case Example 2.4
Lower Case Example 2.5

Step 4: To assign the code to the command button, we must click on the “View Code” command in the “Controls” group in the “Developer” tab. Ensure “Design Mode” is activated.

Lower Case Example 2.6

Step 5: Please select “ConvertToLowerCase” from the drop-down list in the opened window.

Lower Case Example 2.7

Step 6: Paste the following code in between the lines.

Code:

Dim Rng As Range
Dim c As Range
    On Error Resume Next
    Set Rng = Selection
    For Each c In Rng
        c.Value = LCase(c.Value)
    Next c
Lower Case Example 2.8

Step 7: Exit the Visual Basic Editor. Ensure the file is saved with the .xlsm extension as we have a macro in the workbook.

Step 8: Now, deactivate “Design Mode.” After selecting the required cells, the values are converted to lowercase whenever we click on the command button.

Select all the values from A2:A10 and click on the command button. The text will get changed to lowercase.

Excel Lower Case Example 2

#3 Using the VBA Shortcut key

This way is similar to the above, except we do not need to create the command button here.

Example

Step 1: Open the Visual Basic Editor from the “Developer” tab or use using the excel shortcut keyUsing The Excel Shortcut KeyAn Excel shortcut is a technique of performing a manual task in a quicker way.read more (Alt+ F11).

Lower Case Example 3.1

Step 2: Insert the module using the Insert menu -> Module command.

Lower Case Example 3.2

Step 3: Paste the following code.

Sub LowerCaseConversion()

    Dim Rng As Range
    Dim c As Range

    On Error Resume Next
    Set Rng = Selection

    For Each c In Rng
        c.Value = LCase(c.Value)
    Next c

End Sub
Lower Case Example 3.3

Step 4: Save the file using Ctrl+S. Exit the visual basic editorVisual Basic EditorThe Visual Basic for Applications Editor is a scripting interface. These scripts are primarily responsible for the creation and execution of macros in Microsoft software.read more. Ensure the file is saved with the .xlsm extension as we have a macro in our workbook.

Step 5: Now, choose the “Macros” in the “Code” group in the “Developer” tab.

Excel Change LowerCase Example 3.4

Step 6: Then click on “Options” and assign the shortcut key to the macro. We can write a description as well.

Excel Change LowerCase Example 3.5

In our case, we have been assigned “Ctrl+Shift+L.”

Excel Change LowerCase Example 3.6

Step 7: Macro is ready to use. Select the required cells to change the values into lowercase and press the “Ctrl+Shift+L” keys.

Lower Case Example 3.7

#4 Using Flash Fill

If we establish a pattern by typing the same value in the lowercase in the adjacent column, the Flash FillFlash FillAutomatic fillers in the cells of an excel table are known as flash fills. When you type certain characters in the adjacent cells, the suggested data appears automatically. It can be found under the data tab's data tools section or by pressing CTRL + E on the keyboard.read more feature will fill in the rest based on the design we provide. Let us understand this with an example.

Example

Suppose we have the following data, which we want to get in lowercase.

Excel LowerCase Example 4.1

We need to manually write the first list value in the lower case in the adjacent cell to do the same.

Excel LowerCase Example 4.2

Come to the next cell in the same column and press the “Ctrl+E” keys.

Excel LowerCase Example 4.3
Excel LowerCase Example 4.4

Choose “Accept Suggestions” from the box menu that appeared.

Excel LowerCase Example 4.5

That is it. We have all the values in the lower case now. So, we can copy the values, paste the same onto the original list, and delete the extra value from the right.

#5 Enter Text in Lower Case Only

We can make a restriction so that the user can enter text values in lowercase only.

Example

To do this, the steps are:

  • We must select the cells which we want to restrict.
  • Then, choose “Data Validation” from the “Data Tools” group from the “Data” tab.
Excel LowerCase Example 5.1
  • Apply the settings explained in the figure below.
Excel LowerCase Example 5.2
Excel LowerCase Example 5.3
  • Whenever the user enters the value in capital letters, MS Excel will stop and show the following message.

Excel LowerCase Example 5.4

#6 Using Microsoft Word

In Microsoft Word, unlike Excel, we have a command named “Change Case” in the “Font” group in the “Home” tab.

Example

Suppose we have the following data table for which we want to change the text case to the “lower” case.

Excel Lower Case Example 6.1

First, we will copy the data from MS Excel and paste it into MS Word to change the case. To do the same, the steps are:

Select the data from MS Excel. And press the “Ctrl+C” key to copy data from MS Excel.

Excel Lower Case Example 6.2

Open the MS Word application and paste the table using the “Ctrl+V” shortcut key.

Excel Lower Case Example 6.3

Select the table using the “Plus” sign on the left-top side of the table.

Excel Lower Case Example 6.4

Choose the “Change Case” command from the “Font” group and select “lowercase” from the list.

Excel Lower Case Example 6.5

Now, the data table is converted to “Lower.”  After selecting the “Plus” sign from the left top corner, we can copy the table and paste it into Excel.

We can delete the old table using the “Contextual” menu, which we can get by right-clicking on the table.

Excel Lower Case Example 6.6

Things to Remember

Using the VBA code (command button or shortcut key) to convert the values into lowercase, we must save the file with the .xlsm extension as we have macros in the workbook.

This article is a guide to Lowercase in Excel. We discuss the top 6 ways to change capital letters to the lower cases, including – the LOWER function, VBA Code, Flash Fill, VBA shortcut keys, etc., along with examples. You can learn more about Excel functions from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *