Let's say you have a list of something and you have already typed a bunch of it, but then looking it over, you wish you could go back and make it all in caps.
Well sometimes wishes come true! Here's a step by step guide to fixing this without having to retype everything - because Excel does magic all the time.
Here's my original list:
Pick a column next to your text and type in a cell: =Upper(
Once you start typing it, it will try to auto-populate the formula - it's part of the magic trick. Don't be alarmed. It wants to help you find the right formula. Because it's nice.
Typing an equals sign tells Excel you are going to use a formula. Your formula here is Upper. Then you tell it what you want to be in upper case by putting something in the ( ). You can just type one of the parenthesis and it will add the ending one in this formula. Once you type the formula: =Upper( -click on the cell you want to make uppercase. It will look like this:
Click and hold, then drag it down to the cells below it, like this: