How to change the capitalization on Microsoft Excel? You can use the UPPER and LOWER functions in a new cell, type: =LOWER (the cell you want to convert to lowercase). =UPPER (the cell you want to ...