How to Unmerge Cells

– How to Merge Cells and Center the Contents
– How to Merge across Cells
– How to Merge Cells without Centering the Contents

When working with Excel, you may need to unmerge cells. Please see below for details:

Step 1: Select cells you need to unmerge;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the small triangle after the command "Merge&Center";

Step 4: Select "Unmerge Cells" from the drop down list;

Step 5: You will see the merged cells are now unmerged.

Alternatively, you can use the "Format Painter" to unmerge cells.

Step 1: Click any unmerged cell, e.g., cell A2;

Step 2: Double-click the "Format Painter" from the "Home" tab;

Step 3: Select the data range that you need to unmerge cells.

Leave a Reply