Autofit Row Height with Wrap Text - Automatically in Real Time

I am trying to get Excel to autofit to row height based on the length of text I am typing into a cell. I have Wrap Text turned on, but as I type text into the cell, I need it to adjust automatically.

I am aware of the Home(ribbon)-> Cells(section) > Format - Autofit Row Height but that is technically not "automatic". I know about the double-clicking between the row numbers as well as the shortcut Alt+H+O+I, but again, these steps remove the "automatic" from what I need.

Is there another setting I am not aware of? Is this a macro issue?

Any feedback helps. Thank you.

Open the workbook, press Alt+F11, right click on the sheet (you want to apply auto fit. You can select this workbook to apply to the entire workbook) select view code, select workbook from the drop down menu. and type this line Cells.EntireColumn.AutoFit between the lines which are auto displayed like this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.EntireColumn.AutoFit

End Sub

Thank you Rajesh! That works for what I need. Technically I needed the rows to autofit, so I just changed the code to Cells.EntireRow.Autofit and it works as intended. Thank you for the detailed instruction as well.

Glad I could help