This wikiHow teaches you how to split merged cells into two or more standard cells in Microsoft Excel.
Step
![Unmerge Cells in Excel Step 1 Unmerge Cells in Excel Step 1](https://i.how-what-advice.com/images/003/image-6035-1-j.webp)
Step 1. Open the Excel file
Double-click the Excel file that you want to open.
![Unmerge Cells in Excel Step 2 Unmerge Cells in Excel Step 2](https://i.how-what-advice.com/images/003/image-6035-2-j.webp)
Step 2. Select the merged cells
Find the cell you want to split, then select the cell by clicking on it.
- Merged cells take up two or more columns of space. For example, merging cells that are in a column A and B will result in a cell that extends from the column A to B.
- You cannot unmerge a cell that has not been merged with one or more other cells.
![Unmerge Cells in Excel Step 3 Unmerge Cells in Excel Step 3](https://i.how-what-advice.com/images/003/image-6035-3-j.webp)
Step 3. Click the Home tab at the top of the Excel window
Toolbar (toolbar) Home will be opened.
When you have opened the tab Home, skip this step.
![Unmerge Cells in Excel Step 4 Unmerge Cells in Excel Step 4](https://i.how-what-advice.com/images/003/image-6035-4-j.webp)
Step 4. Open the "Merge & Center" menu
Click the drop-down arrow icon (drop-down)
to the right of the button Merge & Center in the " Alignment " section of the toolbar. A drop-down menu will be displayed.
![Unmerge Cells in Excel Step 5 Unmerge Cells in Excel Step 5](https://i.how-what-advice.com/images/003/image-6035-6-j.webp)
Step 5. Click Unmerge Cells in the drop-down menu
The cells you selected will be split, and the cell values will be added to the leftmost cell.