How to split one row into multiple rows in excel

Adjust the cell width to where we want the rows to branch

Select the cells to be divided into multiple rows , switch to the "Home" tab, find "Fill", and click the "Align Both Ends" command in the shortcut menu.

Click OK in the reminder pane.

The selected cell is divided into one column and multiple rows.

Note: If the width is adjusted to two characters per line, there will be two characters per line.

#If you want to know more related content, please pay attention to the excel tutorial column on the php Chinese website!

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