How to automatically convert uppercase to lowercase in excel documents

Reported answer
How to automatically convert uppercase to lowercase in excel documents
Ask online customer service
Scan the code to ask online customer service
  • Number of answers

    four

  • Number of browses

    seven hundred and twelve

4 answers Default sorting
  • Default sorting
  • Sort by time

Adopted
In Excel, you can convert uppercase to lowercase by pressing Ctrl+Shift+L. This shortcut key can be used not only in Excel, but also in other word processing software based on Windows operating system. In addition, if you want to convert the whole table or the whole document to lowercase, you can use the "Change Font" function under the "Format" tab and check "Apply this format to the selection". In addition, you can also choose whether to be case sensitive when entering, so that you can directly enter lower case or upper case when entering table content.
cancel comment
Edit cell with formula:

=LOWER (A1) can be implemented.
cancel comment
If lower case is converted to upper case, use the formula=UPPER();
If upper case is converted to lower case, use the formula=LOWER ();
cancel comment
The operation method of changing uppercase to lowercase in excel cells is as follows, taking numbers as an example:
1. First select the corresponding cell range;
2. Next, right click the mouse and click "Set Cell Format" - "Number";
3. Then click "Special" - "Chinese lower case numbers";



4. Finally, click "OK".
cancel comment
ZOL Q&A > How to automatically convert uppercase to lowercase in excel documents

report

Thank you for contributing to the harmony of the community. Please select the type of report

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

 Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?