Question

How do you unmerge cells?​

Answer 1

Answer:

To unmerge cells immediately after merging them, press Ctrl + Z. Otherwise do this: Click the merged cell and click Home > Merge & Center.

Answer 2

Answer:

Merge and unmerge cells

In this course:

Move or copy cells and cell contents

Article

Change the column width or row height in Excel

Article

Find or replace text and numbers on a worksheet

Article

Merge and unmerge cells

Article

Apply data validation to cells

Article

Import or export text (.txt or .csv) files

Article

Next: Formatting

WindowsmacOS

You can't split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it.

Merge cells

Select the cells to merge.

Select Merge & Center.

Important: When you merge multiple cells, the contents of only one cell (the upper-left cell for left-to-right languages, or the upper-right cell for right-to-left languages) appear in the merged cell. The contents of the other cells that you merge are deleted.

Unmerge cells

Select the Merge & Center down arrow.

Select Unmerge Cells.

Important:

You cannot split an unmerged cell. If you are looking for information about how to split the contents of an unmerged cell across multiple cells, see Distribute the contents of a cell into adjacent columns.

After merging cells, you can split a merged cell into separate cells again. If you don't remember where you have merged cells, you can use the Find command to quickly locate merged cells.

Need more help?