Home >Topics >excel >How to use shortcut keys in excel to change lowercase words to uppercase words

How to use shortcut keys in excel to change lowercase words to uppercase words

王林
王林Original
2020-02-29 15:31:5513179browse

How to use shortcut keys in excel to change lowercase words to uppercase words

Enter the formula guided by the Upper function, as shown in the figure below:

How to use shortcut keys in excel to change lowercase words to uppercase words

Drag down to fill in, and the result will be as shown in the figure below Display:

How to use shortcut keys in excel to change lowercase words to uppercase words

Enter the uppercase form of the first word in the first cell, as shown below:

How to use shortcut keys in excel to change lowercase words to uppercase words

After pressing Enter, press Ctrl E, which is the shortcut key for quick fill. The result is as shown below:

How to use shortcut keys in excel to change lowercase words to uppercase words

Recommended related tutorials: excel tutorial

The above is the detailed content of How to use shortcut keys in excel to change lowercase words to uppercase words. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn