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

How to split a row into multiple rows in excel

王林
王林Original
2020-04-16 13:34:1219932browse

How to split a row into multiple rows in excel

Adjust the cell width to the appropriate position.

How to split a row into multiple rows in excel

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

How to split a row into multiple rows in excel

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

How to split a row into multiple rows in excel

The split result is as shown in the figure:

How to split a row into multiple rows in excel

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!

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