Auto Wrap Text
Step 1: Right click on the sheet name you want to auto wrap text.
Step 2: Click on 'View code'.
Step 3: Click on '(General)' dropdown menu.
Step 4: Click on 'Worksheet'.
Step 5: Write 'Cells.WrapText = True' and press enter then again write 'Cells.EntireColumn.AutoFit' and press enter and close the view code window (Microsoft Visual Basic window).
Now you can input any data inside that sheet and auto wrap text will be applied to your every row and column.