How to split an excel cell into two rows

How to split an excel cell into two rows?

Step 1. Open the Excel table file that needs to be edited.

Recommended: "excel tutorial"

Step 2. Use the mouse to select the cells that need to be split.

Step 3. Select the "Data" tab in the toolbar and click the "Column" button.

Step 4. Select the "Fixed Width" option in the pop-up dialog box, and then click the "Next" button.

Step 5. Use a dividing line to separate the split position in the box below, and then click the "Next" button.

Step 6. Select the "General" option in "Column Data Format" and click the "Finish" button.

Step 7. The cells are split, as shown in the figure.

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