01:40 Demo: How To Change UPPERCASE To lowercase In WORD Now follow me to my desktop and I will show you how you can apply this nifty trick to your text. Well, if you want more one minute productivity tips, then just please, depending on what platform you are: subscribe and turn the notifications on on YouTube, follow me on LinkedIn or Facebook. You can also alternate capitalization, or you could just have the first sentence start with a capital, which would be a great option, as you will discover soon. So, if there are all in uppercase, you can change them to lowercase and vice versa. My name is Olaf, I’m your ToolFinderr, and I’m going to show you how you can change the case of characters. Today I’m going to show you how you can tackle this problem. So, I thought there must be a better way. Well, all of those options aren’t in my opinion, very convenient. One is well typing it all over again, the other one is just copy, pasting it and then adjusting all the first sentence caps or the rest, and maybe a third one would be just to dictate it into something and then transcribe it. So in those cases most people can do one out of three things. But it was a large piece, a lot of words, and I didn’t want to write it all over again. The only problem was that it was all in caps. So, the other day I was writing a blog and I found a very interesting piece. How To Change UPPERCASE To lowercase In WORD wITH tHIS SHORTCUT (!).Pick one of 5 case options from the drop-down list.From the series: One-Minute Productivity Tips.Move to the Font group on the HOME tab and click on the Change Case icon.Highlight the text in your table where you want to change the case.Press Ctrl + V or right-click on the blank page and select the Paste option from the context menu.Press Ctrl + C or right-click on the selection and choose the Copy option from the context menu.
Select the range where you want to change case in Excel.
Feel free to discover how this method works. If you don't want to mess with formulas in Excel, you can use a special command for changing text case in Word. Use Microsoft Word to change case in Excel You'll see that changing case with the use of Excel functions is not difficult at all. Take it easy and try to go through all these steps yourself. This theory might look very complicated to you. Pick Entire column in the Delete dialog box and click OK.Right-click the selected helper column and choose the Delete option from the menu.Since you need only the text values, pick this option to avoid formula errors later. Click on the Values icon under Paste Options in the context menu.Right-click on the first cell in the original column.Highlight the cells that contain the formula and press Ctrl + C to copy them.Let's copy the values from the helper column and then get rid of it. I suppose you'd like to leave only the correct one.
So you have two columns with the same text data, but in different case. Note: If you need to fill the new column down to the end of the table, you can skip steps 5-7 and just double-click on the fill handle.