How to unmerge cells in Excel: 5 steps

This article will show you how to split cells that have been merged into one in Microsoft Excel.

Steps

Step 1. Open an Excel spreadsheet

To do this, double-click on it.

Step 2. Select the merged cell

To do this, click on it.

• Merged cells are arranged in two or more columns. For example, if you combine cells in columns "A" and "B", you get a cell that will be located in two columns at once ("A" and "B").
• You cannot unmerge a cell that is not merged with one or more other cells.

Step 3. Click the Home tab

It's at the top of the Excel window. The main toolbar will open.

Skip this step if you are already on the Home tab

Step 4. Open the "Merge and Center" menu

Click the down arrow icon

to the right of the Merge & Center option in the Align section. A menu will open.

Step 5. Click Unmerge Cells

It's an option on the menu. The cells will be disconnected and their value will be displayed in the leftmost cell.

For example, if a merged cell contains the word “Hello”, breaking the cell will place that word in the leftmost cell

Advice

If you are using Excel in a language that reads words from right to left, the value of the broken cell appears in the cell on the far right