WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change all caps letters to lower case in Excel?

October 7, 2023
32.0K Views

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.

Part 1: How to Change Capital Letters to Lowercase in Excel

Change Capital Letters to Lowercase



In the labyrinth of Excel's possibilities, the journey from uppercase to lowercase unfolds with artistry. Embark with us as we unveil an array of techniques, each a brushstroke in the canvas of transformation. From the subtle strokes of functions to the dynamic rhythms of macros, this segment illuminates the path to lowercase mastery. Let's dive into the heart of Excel alchemy and craft a symphony of change.

Method #1: Using Functions - The Elegant Transition

In the realm of Excel sorcery, functions weave a spell of transformation. Like a skilled magician, you'll learn to conjure formulas that effortlessly convert capitals to lowercase. Step into the realm of functions and witness letters gracefully bowing to your command.

Step 1. Open your Excel worksheet containing the data you want to transform.

Step 2. Select an empty cell where you want the lowercase version of your text to appear.

Step 3. In the formula bar, enter the function "=LOWER(" followed by the cell reference containing the text you want to convert (e.g., A1).

Lower Formula


Step 4. Close the parenthesis and press Enter.

Step 5. The cell will now display the lowercase version of the text in the referenced cell.

Lower Formula result


Step 6. To apply this formula to multiple cells, you can drag the corner of the cell with the formula down to copy it to other cells.

Embracing functions is like summoning a magical transformation. I found this method swift and efficient for smaller tasks, granting a polished uniformity to my data. For larger datasets, considering other techniques might be prudent.

Method #2: Use functions that retain initial capitalization followed by lowercase

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.

Method #3: Embracing Flash Fill - Swift and Spectacular

Imagine a dance of letters, a swift metamorphosis from uppercase to lowercase. Enter Flash Fill, the virtuoso performer of Excel's stage. With the wave of your wand, you'll witness data gracefully pirouette, revealing the elegance of lowercase.

Step 1. Ensure that the data you want to transform is in a column next to an empty column.

Step 2. In the empty column, start typing the lowercase version of the text for the first cell.

Step 3. Press Enter. Excel will automatically detect the pattern and suggest completing the transformation for the rest of the column.

Step 4. Press Ctrl + E or go to the "Data" tab and click on "Flash Fill" to apply the transformation to the entire column.

Data tab


Step 5. Watch as Excel swiftly transforms all the uppercase text to lowercase, matching your pattern.

Flash Fill dances with automation. I marveled as Excel's intuition understood my pattern and mirrored it across my dataset. Ideal for immediate changes, though complex patterns might require further exploration.

Method #4: The Microsoft Word Symphony - A Seamless Fusion

In the grand symphony of Microsoft Office, Excel and Word harmonize to bring lowercase majesty. Prepare for a crossover experience as we guide you through leveraging the prowess of Word within Excel. Let the rhythm of collaboration and transformation resonate.

Step 1. Open your Excel worksheet and identify the cells containing the uppercase text you wish to transform.

Step 2. Select the text you want to convert to lowercase.

Step 3. Right-click on the selected text and choose "Copy."

choose "Copy."

Step 4. Open Microsoft Word and paste the copied text into a new document.

Step 5. In Microsoft Word, select the text you just pasted.

Step 6. Navigate to the "Home" tab and find the "Change Case" button in the "Font" group.

the "Change Case" button


Step 7. Choose the "lowercase" option from the dropdown menu.

Choose the

Choose the "lowercase"


Step 8. Copy the transformed lowercase text from Microsoft Word and paste it back into the corresponding Excel cells.

This fusion of Word and Excel is seamless. My data journey flowed between the two effortlessly, offering a nuanced touch. However, this method may not be ideal for larger datasets due to the transition.

Method #5: Unleashing Kutools - The Power of Simplicity

In the world of Excel, simplicity wields great power. Enter Kutools, a trusty companion that simplifies complexity. With Kutools as your guide, you'll navigate the lowercase realm with ease, unlocking efficiency and precision in every stroke.

Step 1. Ensure you have Kutools for Excel installed.

Step 2. Open your Excel worksheet and locate the cells containing uppercase text.

Step 3. Select the range of cells you want to transform.

Step 4. Go to the "Kutools" tab and click on "Text" in the "Format" group.

the

the "Kutools" tab



Step 5. Choose the "Change Case" option from the dropdown menu.

Choose the "Change Case"


Step 6. In the "Change Case" dialog box, select "Lowercase" and click "OK."

Step 7. Watch as Kutools efficiently transforms the selected text to lowercase.

Kutools unveiled simplicity's prowess. A swift transformation awaited as I harnessed its capabilities. A tool for those valuing efficiency, though exploring other methods may offer different insights.

Method #5: Mastering VBA Macros - Code Craftsmanship

Behind the scenes of Excel's stage, a realm of coding brilliance awaits. Venture into the world of VBA macros, where every line of code is a brushstroke of transformation. Embrace the realm of automation and elevate your lowercase journey through code craftsmanship.

Step 1. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.

Visual Basic for Applications (VBA) editor


Step 2. Click "Insert" in the menu and select "Module" to insert a new module.

select "Module" to insert

Step 3. Copy and paste the following VBA code into the module:

Sub ChangeToUpper()

   Dim cell As Range

   For Each cell In Selection

       cell.Value = LCase(cell.Value)

   Next cell

End Sub

Step 4. Close the VBA editor.

Step 5. Select the cells containing the uppercase text you want to transform.

Step 6. Press Alt + F8 to open the "Macro" dialog box.

Step 7. Choose the "ChangeToUpper" macro and click "Run."

the "Macro" dialog box

Step 8. Experience the magic as your selected text transforms to lowercase, courtesy of the VBA macro.

Embarking on the realm of VBA macros feels like wielding a coding wand. I was astounded by the automation potential and the sheer thrill of crafting my own transformation. This method provides unparalleled customization, making it an essential skill for data alchemy. However, it might be a steeper learning curve for beginners compared to the other methods

With these comprehensive step-by-step guides, you're equipped to elegantly transform uppercase to lowercase in Excel through a variety of methods. Choose your path and embrace the transformation!

Part 2: Why Use WPS Office

WPS Office logo

While the preceding methods are compatible with both Microsoft Excel and WPS Office Spreadsheet, we wholeheartedly recommend embracing WPS Office for your data endeavors. Allow us to illuminate the reasons why WPS Office shines brightly on the office software horizon:

Price: Your Budget's Best Friend WPS Office offers a cost-effective alternative, presenting a free version with robust features that cater to your essential needs. The option for advanced functionalities comes at an incredibly affordable price, ensuring you get exceptional value for your investment.

Compatibility: Harmonious Interactions Experience seamless compatibility across different file formats, saving you from the maze of compatibility issues. Whether you're collaborating with colleagues or sharing files, WPS Office ensures your data retains its integrity across platforms.

Features: A Plenitude of Possibilities WPS Office doesn't just meet your requirements; it anticipates your desires. Beyond the familiar trio of word processing, spreadsheet, and presentation tools, WPS Office offers a treasure trove of features, from resume assistants to smart forms, empowering you to accomplish more in less time.

User-Friendly Interface: Your Intuitive Companion Navigating through WPS Office is as natural as a conversation. The interface is designed with your convenience in mind, ensuring that your focus remains on your work rather than deciphering complex menus. Efficiency becomes your closest ally.

By choosing WPS Office, you embrace a potent ally that harmonizes price, compatibility, features, and user-friendliness. Your office experience transforms into an effortless symphony of productivity.

FAQs

How Do You Capitalize All Letters in Excel Without Formula?

To capitalize all letters in Excel without using a formula, follow these steps:

Step 1. Prepare Data: Make sure your data is organized in a column.

Step 2. Empty Column: Insert an empty column next to your data.

Step 3. Type Capitalized: In the empty column, type the capitalized version of the first data entry.

Step 4. Flash Fill: Press Enter and Excel will automatically detect the pattern.

Step 5. Apply to Column: Click on the suggested pattern icon to apply the transformation to the entire column.

Excel will capitalize all letters in your data without using formulas.

What Is the Shortcut Key to Change Small Letters to Capital Letters?

The shortcut key to change small letters to capital letters in Excel is "Shift + F3". When you have a cell or text selected, pressing "Shift + F3" will cycle through different text case options, including uppercase, lowercase, and proper case (only the first letter of each word capitalized). This keyboard shortcut provides a quick way to change the case of text without the need for formulas or additional steps.

Summary

In this guide, we've covered diverse methods to convert capital letters to lowercase in Excel, including functions, Flash Fill, Microsoft Word, VBA macros, and the standout option—WPS Office. Each method offers a unique approach, but WPS Office shines with its affordability, compatibility, rich features, and user-friendly interface. By choosing WPS Office, you unlock a versatile toolset that enhances productivity and simplifies data manipulation, making your office tasks more efficient and seamless.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.