Home >Topics >excel >How to divide excel branches

How to divide excel branches

藏色散人
藏色散人Original
2020-03-09 09:23:1215530browse

How to divide excel branches

How to divide excel branches?

The first step is to open EXCEL and see the prepared data. This time I use "student basic information". The goal is: divide the data inside into 5 rows! ! !

How to divide excel branches

The second step, start! Click to enter the editing state of the cell (not to select it, but to enter it directly to edit text)

How to divide excel branches

The third step is to select all the contents inside (note how it looks after selection) Oh), as shown in the picture below

How to divide excel branches

Step 4, right-click and select "Copy". Or the shortcut key "ctrl c"

How to divide excel branches

The fifth step, select the next cell

How to divide excel branches

The sixth step, Right-click the mouse and select "Paste text only"

How to divide excel branches

Step 7, you can see that the above content has been divided into lines! ! ! ! !

How to divide excel branches

Step 8, complete

The above is the detailed content of How to divide excel branches. 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