• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Merge and Unmerge Cells in Excel

How to Merge and Unmerge Cells in Excel

By: Waseem Patwegar

The Merge function in Microsoft Excel allows you to combine multiple Excel cells into a combined single cell. You will find below the steps to Merge and Unmerge cells in Excel.

Merge and Unmerge Cells in Excel

Merge and Unmerge Cells in Excel

One of the most common use of the Merge Cells function in Excel, as employed by its users is to create a header or title for content spread across several columns.

Others reasons for merging cells in Excel would be to insert logo or picture matching the width of the content and other such formatting reasons.

While the Merge function combines cells, the Unmerge option in Excel splits back previously Merged cells into individual single cells, just as they existed before being merged.

What Happens to Content in Merged Cells

Before going ahead with the steps to Merge cells in excel, it important to understand as to what happens when you Merge two or more cells containing data in an Excel spreadsheet.

When you Merge cells containing data, only the data in the upper left cell (first cell) will remain in the resulting Merged cell, while data in other cells gets discarded (See image below).

Data Loss After Merging Cells in Excel

Similarly, when you Unmerge cells containing data, all the data gets placed in the first cell and other cells become empty.

Data After Unmerging Cells in Excel

Luckily, Excel does provide a warning message informing you about such data loss when you try to Merge cells in Excel.

How to Merge Cells in Excel

Follow the steps below to Merge Cells in Excel.

1. Select the Cells that you want to merge, click on the Home tab and then click on Merge button.

Merge Cells in Excel

2. On the pop-up that appears, click on OK to confirm.

3. Once you click on OK, you will immediately see the selected cells Merged or combined into a single cell.

Merged Cell in Excel

As you can see in above image, cells A1 to D1 have been merged into a single Cell.

Unmerge Cells in Excel

Unmerging Cells in Excel is just as easy as Merging cells.

1. Simply, select the Merged cell and click on Merge/Unmerge icon.

Unmerge Cells in Excel

Alternately, you can also click on the Down Arrow next to the “Merge/Unmerge” icon and click on Unmerge Cells option in the drop-down menu.

Unmerge Cells in Excel

2. You will immediately see the Merged Cell reverting back in to individual single cells.

Other Merge Cell Options in Excel

The Merge Cells Function in Excel provides a few more option that you might be interested in.

Click on the Down Arrow next to the “Merge Icon” and you will be able to see all the available Merge options in the drop-down menu.

Merge Cell Options in Excel

  • Merge & Center: Combines selected Cells into a Single Cell and the content within the cell will be centered.
  • Merge Across: Combines only the selected cells in a row, but not the cells in a column.
  • Mere Cells: Combines selected Cells
  • Unmerge Cells: Splits the selected Merged cell into individual or single cells
Related
  • How to Hide Cells, Rows and Columns In Excel
  • How to AutoFit Column Width and Row Height in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Recent Posts

  • Fix: iPhone Camera Black Screen Problem
  • How to Clear Your Activity History In Windows 11
  • How to Find WiFi Password in Windows 11
  • How to Enable Touch Keyboard in Windows 11/10
  • How to Send Group Email In Gmail App On iPhone




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved