Monday, 15 June 2015

Simple Ways To Change Between UPPERCASE & lowercase



Ever typed a sentence or even a whole paragraph while accidentally left your caps lock on? 

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