X
This article was written by Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 244,681 times.
This wikiHow teaches you how to change a merged cell back into two or more standard cells in Microsoft Excel.
Steps
-
1Open your Excel document. Double-click the Excel document that you want to open.
-
2Select the merged cell. Find the cell that you want to unmerge, then click it once to select it.
- Merged cells take up two or more columns' worth of space. For example, merging a cell range in the A and B columns would leave you with a cell that spans the A and B columns.
- You cannot unmerge a cell which has not yet been merged with one or more other cells.
Advertisement -
3Click the Home tab. It's at the top of the Excel window. Doing so opens the Home toolbar.
- Skip this step if you're already on the Home tab.
-
4Open the "Merge & Center" menu. Click the drop-down arrow icon to the right of the Merge & Center button in the "Alignment" section of the toolbar. This will prompt a drop-down menu to appear.[1]
-
5Click Unmerge Cells. It's in the drop-down menu. Your cells will be unmerged, and the cells' value will be added to the left-most cell.
- For example, if your merged cell had the word "Hello" in it, unmerging the cells would place the word "Hello" in the left-most unmerged cell.
Advertisement
Warnings
- You cannot unmerge a cell that isn't merged with another cell (or group of cells).Thanks!
Advertisement
References
About This Article
Article SummaryX
1. Click once a merged cell in your Excel document.
2. Click the Home tab.
3. Click the triangle to the right of the Merge & Center button.
4. Click Unmerge Cells.
Did this summary help you?
Advertisement
