How to make an entire column capital (uppercase) or lowercase in Excel?

In this article, we will discuss how to make an entire column capital(uppercase) or lowercase in Excel. A spreadsheet in Excel is prepared in a way such that end users can easily understand the data in a tabulated way. To make the headings and significant values stand out, it is required to change their format. For text values, this can be done by changing the case of the heading and the significant values. There are two ways to change the data of an entire column to either uppercase or lowercase.

• Using formula.

• Using Kutools.

Example 1: By using the formula

In this example, we will see how we can use the formula to change the case of text to either uppercase or lowercase.

Let us look at the steps involved to change the case to uppercase.

Step 1

In the given spreadsheet, column A has textual values, i.e., name of countries, from A2 to A6 as shown.

Step 2

In the B2 cell, enter the given formula.

=UPPER(A2)

Step 3

Now, press Enter key and cell B2 will show the uppercase version of the value in cell A2.

Step 4

Next, drag and use the Fill option to copy the above formula to all cells until B6. This will fill cells B3 to B6 with the uppercase version of the values of cells A3 to A6 respectively.

As seen from the output image, the UPPER() function is used to obtain the uppercase version.

Now, let us discuss the steps required to change the case to lowercase.

Step 1

In the C2 cell, type the formula “=LOWER(A2)” as highlighted in the below image.

Step 2

Press Enter key from the keyboard and cell C2 will display the lowercase version of the value in cell A2.

Step 3

Next, drag and use the Fill option to copy the above formula to all the cells until cell C6. This will fill cells C3 to C6 with the lowercase version of values in cells A3 to A6 respectively.

As seen from the output image, the LOWER() function is used to generate the lowercase version.

Example 2: By using Kutools

Let us look at how to use Kutools.

Step 1

Select the text whose case is to be changed. Click on Kutools tab.

Step 2

In the Editing section, click on Text as highlighted in below image.        

Step 3

A list of options will appear. Click on the Change Case option as highlighted in below image −

Step 4

A dialog box would appear having all the options for different cases. Check the UPPER CASE radio button. In the Preview section, you can see all the text in upper case. Click on the OK button. This will change the case of all the countries to the upper case.

Step 6

In the same way, to change the case to a lowercase, follow steps 1 to 4. When the box appears, select a lower case radio button. In the Preview section, you can see all the text in a lower case. Click on the OK button. The case of the selected text will be changed to lower case.

Conclusion

This article outlines two methods to change the case of values of a column into lower case and upper case. In the first example, two different formulas are used to make the content of the column either in upper case or lower case. In the second example, the Kutools option is used to achieve the same result. It is recommended that the reader should know formulas and Kutools in Excel. Also, the reader should be able to use Excel comfortably and should be aware of all the tabs in Excel to use them properly.