The UPPER function instructs Excel to take that first character in cell T3 and capitalize it. I inserted just this portion of the formula in cell Z3 and copied it down to cell Z12. See the screenshot ...

How to freeze multiple rows and columns in Excel You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...