How to split a row into multiple rows in excel

Adjust the cell width to the appropriate position.

Select the cells you want to split into multiple rows, switch to the "Home" tab, find "Fill", and click the "Align Both Ends" option in the shortcut menu

Click OK in the "Text will exceed the selected area" prompt box.

The split result is as shown in the figure:

Recommended tutorial:excel tutorial

The above is the detailed content of How to split a row into multiple rows in excel. For more information, please follow other related articles on the PHP Chinese website!