Merging / Unmerging Cells in Excel

Summary

In this article, you will learn the steps to merge and unmerge a range of cells in an Excel worksheet.

Body

   Overview   

You can quickly merge or unmerge a range of cells in an Excel spreadsheet.  Note that when you merge several cells, only the upper-right cell value is maintained.

   Instructions   

  1. Step 1: Choose the first cell in the range of cells that you want to merge, then press and hold the [Shift] key.
  2. Step 2: Select the final cell from the range of cells you want to merge, then release the [Shift] key.  
  3. Step 3: Click the Merge & Center drop-down arrow.
  4. Step 4: Click the Merge & Center option.
  5. Step 5: Click the OK button.
  6. Step 6: Click the Merge & Center drop-down arrow again.
  7. Step 7: Click the Unmerge Cells option.
  8. Step 8: The selected cells are unmerged.

In this article, you will learn the steps to merge and unmerge a range of cells in an Excel worksheet.

1. Step 1

step image

Within a worksheet, choose the first cell in the range of cells that you want to merge, then press and hold the [Shift] key.

Example shown here: cell R2 .

2. Step 2

step image

From the row and column headers, select the final cell from the range of cells you want to merge, then release the [Shift] key.  

Example shown here: click cell U2 then release the [Shift] key.

3. Step 3

step image

The selected cells are highlighted.

On the Home tab ribbon, click the Merge & Center drop-down arrow.

4. Step 4

step image

From the drop-down menu, click the Merge & Center option.

5. Step 5

step image

A dialog message is displayed, notifying you that merging cells only keeps the upper left values and discards other values.  

In this example, only the R2 value would be saved.

To complete the process of merging the selected cells, click the OK button.

6. Step 6

step image

The selected cells are merged.

To unmerge the cells, click the Merge & Center drop-down arrow again.

7. Step 7

step image

Click the Unmerge Cells option.

8. Step 8

step image

The selected cells are unmerged.

Note: After unmerging the selected cells, you can edit the data in each cell.   

Details

Details

Article ID: 149359
Created
Sat 9/24/22 11:11 PM
Modified
Fri 1/5/24 5:08 PM