How to change lowercase to uppercase in Excel

August 1, 2022
1.7K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

When you create a new worksheet in Excel, you're given the option to save it in either lowercase or uppercase. This can be helpful if you want to keep your workbooks organized by case, but it can be confusing if you need to reference a specific cell value. In this article, we'll show you how to change lowercase to uppercase in Excel so that all values are uppercase.

Changing lowercase to uppercase in excel worksheet to uppercase can make the data more legible and organized. This tip is especially helpful if you are working with a large volume of data that needs to be easily read.

If you are working with a lot of data in Excel, it can be helpful to change the letters in the data so that they're all in uppercase.

When you create a new worksheet in Excel, you're given the option to save it in either lowercase or uppercase. This can be helpful if you want to keep your workbooks organized by case, but it can be confusing if you need to reference a specific cell value. In this article, we'll show you how to change the default case of cells in Excel so that all values are uppercase.

Changing all lowercase text in an Excel worksheet to uppercase can make the data more legible and organized. This tip is especially helpful if you are working with a large volume of data that needs to be easily read.

If you are working with a lot of data in Excel, it can be helpful to change the letters in the data so that they're all in uppercase.


How to CHANGE LOWERCASE TO UPPERCASE IN EXCEL

1. Type a series of text in a column. For example, you could enter a list of names, artists, food itemsanything. You can use the UPPERCASE or PROPER function to alter the text in the file.

2. Add and move column to the right data. If there's already a blank column next to the column that contains your data, you can skip this step. Otherwise, right-click the column letter above your data column and select Insert.

3. Click the first cell in your new column. This is the cell to the right of the first cell you want to capitalize


4. Click on fx This is the function button just above your data. The Insert Function window will expand.

Displays Excel Functions to Change lower to Upper Case in Excel 2016/2019

1. Select the Text category from the menu. This displays Excel functions that pertain to handling text.

2. Click ok Now you'll see UPPER () appear in the cell you clicked earlier.

3. Highlight the cells you want to make uppercase. If you want to make everything in the column uppercase, just click the column letter above your data. A dotted line will line up the selected cells, and you may see the range appear within the Form Arguments window. If you're utilizing PROPER, just click on the cells you wish to use as their foundation

4. Click ok Now you'll see the uppercase version of the first cell in your data appear at the first cell of your new column.

In conclusion, if you want to change the lowercase letters in Excel to uppercase, follow these simple steps:

1. Select the text you want to change in the workbook.

2. On the Home tab, in the Font group, click the Down Arrow next to Type to open the Type dialog box.

3. In the list of fonts, click UPPERCASE.

4. Click OK.


In conclusion, if you want to change the case in Excel, use the UPPERCASE button in the Text Formatting palette. This will make all the text in the document uppercase. Be sure to save your work periodically to make sure your changes are reflected.


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.