How to caps lock all text in excel

00:00unlike Microsoft Word there's no button

00:02that's going to change all the case from

00:04upper to lower so we're going to run a

00:06formula and first we'll go ahead and

00:09click the cell that we want to start the

00:10formula in in this case it's B 1 and

00:13then we will type equals upper open

00:19parenthesis then we'll select the cell

00:21right next to us click it and then press

00:26Enter now we can see it's made the

00:28conversion now let's click that so again

00:31then we'll see in the bottom right

00:33there's a little rectangle a little

00:35square there and if we double click on

00:37that that's the fill handle it'll

00:39automatically fill in the formula all

00:41the way down now let's press ctrl C to

00:44copy all of that and then we'll

00:47right-click on a one and go to paste

00:51special click on that then we'll click

00:55on values that means it's going to just