How to change caps lock on an excel list?
If you want to do it in proper case (first letter capitalized, the rest lowercase), then in a seperate column, enter the following function:
=proper(select the cell you want to change).
If you want them to be lower, then enter =lower(type or select the cell you want to change).
To apply it to the whole list, select the cell that you entered the first formula in and all of the cells beneath it, and hit CTRL+D, which copies the formula down to the other rows.
Then just cut or copy the data from the new column and right-click the top row of the original column, select %26quot;paste special,%26quot; then select 'values.' Hit OK.
How to change caps lock on an excel list?
thanks for sharing the answer. I found that to apply it to a whole list is easier to just , click on the new cell with the function, mouse over the bottom-right corner of the cell (little square), click %26amp; hold and then move down the list, release the mouse button at the end of your list. good luck!
Report Abuse
Hmmm... for me, the easiest way is actually to cut and paste it into word and use the Change Case feature in Word.
There is a formula to recreate single cells and change their case (=PROPER(A1)), but I don't know how to apply it to a whole list of cells.
