How can I split and merge cells in excel? How to split and merge cells in excel

1. First, we pull down the cell as shown below.

2. Click the h column at the top of the excel file so that this column is selected. (This H column is not necessarily H, in your table, it can be A, which indicates the meaning of the current column.)

3. Click fill below to align the two ends

4. At this time, you will find that automatic merging has been implemented.

5. On the contrary, how can I quickly change the figure to the form on the left? Some friends can say that I use copy and paste, but you have to perform 12 operations if you want to know that.

6. In fact, we can use the opposite method to drag the cell width to the left to hold the two words.

7. Now, click align on both ends in the drop-down menu as shown in the figure.

8. Then, it is restored, as shown below:

Well, you will find that the key points in our article, split and merge cells, are completely explained to you. In fact, this is quite simple. I hope it will help you effectively.