Home  >  Article  >  Topics  >  How to split one row into multiple rows in excel

How to split one row into multiple rows in excel

王林
王林Original
2020-02-27 15:41:5220684browse

How to split one row into multiple rows in excel

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

How to split one row into multiple rows in excel

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.

How to split one row into multiple rows in excel

Click OK in the reminder pane.

How to split one row into multiple rows in excel

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.

How to split one row into multiple rows in excel

#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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn