Open VBA window by pressing the key combination Alt + F11 , On the Sheet name contains the cell you want to automatically wrap the line you right-click select Insert -> Module .
How to automatically wrap lines in Excel (Wrap Text in Excel) Picture 6
Copy the above code into the Module window.
How to automatically wrap lines in Excel (Wrap Text in Excel) Picture 7
Return to Work Sheet, double-click the cell you want to auto-break, and then press the Enter button to automatically wrap the line.
The result is as shown below:
How to automatically wrap lines in Excel (Wrap Text in Excel) Picture 8
Good luck!