Download Article
A quick guide to moving the values from a merged cell back into individual cells in Excel
Download Article
Do you want to unmerge cells in Microsoft Excel? When merging cells, data from adjacent cells combine into a single cell. When you unmerge cells, the data is retained in the top-left cell while the cells split. You can easily unmerge cells by selecting your merged cells and selecting "Unmerge Cells" in the "Merge & Center" drop-down menu. This wikiHow will show you how to change a merged cell back into two or more standard cells in Microsoft Excel using your Windows or Mac computer.
Things You Should Know
- You can only unmerge a cell that has been previously merged.
- Select all the cells you want to unmerge. Go to Home , then click the drop-down menu next to Merge & Center .
- Click Unmerge Cells in the drop-down menu to unmerge the cells.
Steps
Download Article
-
Open a project in Microsoft Excel. You can use an existing project or create a new spreadsheet .
- Microsoft Excel is available on Windows and Mac. You can also use the online web version at the Microsoft 365 website .
- You can use Excel to make tables , type formulas , make graphs , and more.
-
Select the data you want to unmerge. To select an entire spreadsheet, click the A1 cell, hold down the Shift key, and then click the bottom value in the last column. This will select all of your data. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- You can also hold Shift (Windows) or Command (Mac) and click individual cells to add them to the selection.
- 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 can only unmerge a cell that has been previously merged.
Advertisement -
Click the Home tab. It's at the top of the Excel window. Doing so opens the Home toolbar.
- If you're already on the Home tab, you can skip this step.
-
Open the "Merge & Center" menu. Click the drop-down arrow to the right of the Merge & Center button in the "Alignment" section of the toolbar. This will prompt a drop-down menu to appear. [2] X Research source
-
Click 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.
- If you want to merge cells again, select the cells you want to merge. Click Merge & Center in the Home tab. You can also click the arrow to select Merge Across or Merge Cells .
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
- If you use Excel in a language which reads from right to left, the unmerged value will always go to the right-most cell.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
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 Summary
X
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?
Thanks to all authors for creating a page that has been read 289,510 times.
Advertisement
