How to unmerge a cell in excel

Answer

To unmerge a cell in Excel, follow these steps:

1. Select the merged cell or range of merged cells.

2. Go to the Home tab on the ribbon.

3. Locate the Merge & Center button in the Alignment group.

4. Click the Merge & Center dropdown arrow.

5. Select Unmerge Cells.

The selected cells will return to individual cells, retaining the content only in the upper-left cell of the original merged range. All other cells will be empty.

Additional Notes

1. The Merge & Center option works the same way on both Windows and Mac versions. On a Mac, the button is located in the Home tab under Alignment, but the icon may appear slightly smaller.

2. Formatting like text alignment, font style, or background color remains unchanged when a cell is unmerged.

3. If multiple merged cells are selected, Excel will unmerge all of them at once.

Quick Keyboard Method (Windows)

1. Select the merged cell.

2. Press Alt → H → M → U sequentially.

This sequence quickly unmerges the cell without navigating through the ribbon.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report