Buzz
Want to switch between lowercase and uppercase in Word, Excel quickly? Follow these detailed instructions from Mytour.
1. Changing lowercase to uppercase in Word and vice versa
Method 1: Using shortcuts in Word
Step 1: Highlight the text you want to convert from lowercase to uppercase or vice versa.
Bước 2: Nhấn tổ hợp phím tắt SHIFT + F3 để thay đổi giữa chữ thường, chữ in hoa hay viết hoa ký tự đầu tiên.
Method 2: Utilizing Built-in Functionality in Word
Select the text you want to modify => On the Home tab, click on the Aa feature
+ Choose UPPERCASE to convert lowercase to uppercase.
+ Choose lowercase to convert uppercase to lowercase.
Moreover, you can change other text formats by selecting:
+ Sentence case: Convert the first character in a sentence to uppercase
+ Capitalize Each Word: Transform the first letter of each word to uppercase.
+ tOGGLE cASE: Change the first letter of each word to lowercase and the rest to uppercase.
2. Converting lowercase to uppercase in Excel and vice versa
Converting lowercase to uppercase
Step 1: Type the formula =UPPER (cell containing the text you want to convert)
Step 2: Press Enter to get the result of converting lowercase to uppercase => Place the mouse cursor in the bottom right corner of the screen to see the “+ sign => Hold and drag down to the rows below.
Converting UPPERCASE to lowercase
Step 1: Type the formula =LOWER(cell containing the text you want to convert)
Step 2: Press Enter to get the result of converting from UPPERCASE to lowercase => Place the mouse cursor in the bottom right corner of the screen to see the “+” sign => Hold and drag down to the rows below.
Converting the first letter of each word to UPPERCASE
Step 1: Type the formula =UPPER(cell containing the text you want to convert) anywhere you like.
Step 2: Press Enter to see the conversion result => Place the mouse cursor in the bottom right corner of the screen to see the “+” sign => Hold and drag down to the rows below.
Here's how to switch between lowercase and uppercase in Word, Excel, and vice versa. We hope that Mytour's tips will assist you in quickly and efficiently composing documents. Wishing you every success!
Check out some laptop models with great prices, best sellers at Mytour:
