Resolved Auto Uppercase in MS Excel

Hello,
Is there a way I can set a range of cells e.g. a column in MS Excel such that whatever is entered is automatically converted to uppercase without my going back to "manually" convert using say the UPPER function or other method?
I would like to type "fred" and see "FRED" in the cell, just like when I have added BOLD and RED format to a column, whatever I type in there turns out BOLD and RED.
I imagined it would be somewhere under text format but had no luck. MS Excel 2016 doesn't even have [Change Case] button like MS Word.

 

This is the "manual" way I would like to avoid.

 

I have found options I didn't know of here e.g. ablebits add-in. https://www.ablebits.com/office-addins-blog/2014/04/25/change-case-excel-uppercase-lowercase/
Not exactly what am looking for but with the ablebits add-in, I can Change Case of selected column/row/cells. I do not have to create an extra column, enter formula, then copy and hide column, etc.
Allow me to close this thread. I hope Microsoft will include "Format Text Uppercase" in Excel one day.