This article will show you how to split cells that have been merged into one in Microsoft Excel.
Step 1. Open an Excel spreadsheet
To do this, double-click on it.
Step 2. Select the merged cell
To do this, click on it.
- Merged cells are arranged in two or more columns. For example, if you combine cells in columns "A" and "B", you get a cell that will be located in two columns at once ("A" and "B").
- You cannot unmerge a cell that is not merged with one or more other cells.
Step 3. Click the Home tab
It's at the top of the Excel window. The main toolbar will open.
Skip this step if you are already on the Home tab
Step 4. Open the "Merge and Center" menu
Click the down arrow icon
to the right of the Merge & Center option in the Align section. A menu will open.
Step 5. Click Unmerge Cells
It's an option on the menu. The cells will be disconnected and their value will be displayed in the leftmost cell.