How to split one single row to multiple rows in Excel

For example a row is too long to display completely in the Excel window, and you have to move the horizontal scrollbar to view behind cells. For easily viewing all values in this row, you may want to split this long row to multiple rows, but how? Here are several solutions for you.

More details:
https://www.extendoffice.com/document...