How to make lowercase letters uppercase in excel with one click

php editor Strawberry shares a practical Excel skill: how to change lowercase letters to uppercase in Excel with one click. When processing text data, sometimes it is necessary to convert lowercase letters to uppercase. This can be achieved through Excel formulas or shortcut keys to make data processing more efficient and faster. Through simple operations, Excel can quickly complete text conversion work and improve work efficiency. Next, let’s learn about the specific steps!

1. Open the excel table you want to edit on your computer, as shown in the picture. How to change these lowercase letters to uppercase? ,As shown below.

　

2. Then you will use the UPPER function, enter the formula as shown in the corresponding cell, and then click the Enter key, as shown below shown.

　

3. Next, place the mouse on the cell where the result is obtained. A black "small cross" will appear in the lower right corner of the cell. Click and drag down. Just move it, as shown in the picture below.

　

4. This is the final effect, as shown in the picture below.

　

With a few simple steps, all lowercase letters have been turned into uppercase letters, which saves a lot of time switching back and forth between uppercase keys and reduces useless duplication of work. Likewise This avoids the problem of capitalization errors caused by forgetting to switch. In the use of office software, batch processing is also one of the methods to improve efficiency. Accumulating operational skills in actual operations can bring great convenience to work.

The above is the detailed content of How to make lowercase letters uppercase in excel with one click. For more information, please follow other related articles on the PHP Chinese website!