How to Merge and Split Cells in Microsoft Excel

Merging cells is one of the best ways to keep your Microsoft Excel documents organized, clean and easy to understand. One of the uses of this feature is usually to make header that separates one table group from another.

However, the function and use of this feature is not only limited to that. You can use it for anything according to your needs.

For Androbuntu friends who want to know how to combine and split cells in Microsoft Excel, just read the full tutorial below.

Baca juga: Cara Mengaktifkan Fitur Simpan Otomatis di Microsoft Excel

How to Merge and Split Cells in Microsoft Excel

First create a new document in Microsoft Excel, or open an existing document. Then block several cells that you want to merge together. In this tutorial, I blocked three cells.

Once the cell is marked, tap the tab Home > Merge & Center.

How to Merge and Split Cells in Microsoft Excel by Androbuntu 2

As you can see, all the cells you blocked are now one.

How to Merge and Split Cells in Microsoft Excel by Androbuntu 3

If you fill the cell with a sentence or word, the word will automatically be in the middle of the cell.

How to Merge and Split Cells in Microsoft Excel by Androbuntu 4

To separate cells that have been merged, the method is as easy as the above method. First, select the cells that have been merged earlier, then tap Home, then tap the down arrow next to Merge & Center. You will see several other options appear, one of which is Split Cells. Tap the option.

How to Merge and Split Cells in Microsoft Excel by Androbuntu 5

After performing the steps above, the cells will be separated again as usual.

What is the maximum number of cells that can be combined?

Based on my own experiments, I haven’t found a limit on how many cells can be combined in Microsoft Excel. So it can be assumed that there is no limit.