Or even typed a few pages of reports using lowercase and suddenly your boss wants it all to be in uppercase?
In this post, I'm gonna share how I change sentences or even paragraphs from uppercase to lowercase or whatever case you want in a much simpler way. There are plenty of resources on the internet on how to do so, but some involve formula (especially when using Excel) which I find troublesome.
I'll be addressing those solutions for the 3 most widely used program for typing which is Microsoft Office Words, PowerPoint & Excel.
A. Microsoft Words
There are 2 ways to solve this problem when using MS Words.
1) Without Using Keyboard
- Click on the icon shown and select the desired case
OR
2) Using Keyboard
- Highlight the words
- Press Shift+F3
B. Microsoft PowerPoint
It is exactly the same with using Microsoft Words.
1) Without Using Keyboard
- Click on the icon shown and select the desired case
OR
2) Using Keyboard
- Highlight the words
- Press Shift+F3
C. Microsoft Excel
Out of the 3, this is the tricky one. But I promise, no formula involve.
1) When connected to the internet
- Go to http://convertcase.net/
- Paste you highlighted words there and click the desired case adjustment there.
- Paste it back onto the Excel sheet
OR
2) Not connected to the internet
- Highlight your words
- Paste it onto MS Words / PowerPoint
- Change to your desired case using the above method
- Paste it back onto MS Excel
There you have it. The easiest way for me (so far) to change between uppercase & lowercase with no formula whatsoever.
Hope it is useful.




No comments:
Post a Comment