• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Unmerge Cells in Excel

April 9, 2021 by Andrew Childress
Unmerge cells Excel

Merged cells are often found in Excel spreadsheets. But what happens if you want to unmerge cells? Let's learn how to unmerge cells in Excel.

Merged cells are often found in Excel spreadsheets. But what happens if you want to unmerge cells? Let’s learn how to unmerge cells in Excel.

How to Unmerge a Cell in Excel

Imagine that you have a spreadsheet with a merged cell inside. But perhaps you want the cell unmerged. In other words, you want to transform the single merged cell into multiple unmerged cells.

Begin by clicking on the merged cell. In this example, as you can see, it spans across columns A, B, and C.

Make sure you’re working on the Home tab on Excel’s ribbon. The command you want is Merge & Center, in the Alignment group. As you might know, this is the command used to merge cells. It basically works as a toggle switch: click it to merge cells, then click it again to unmerge.

Unmerge in Excel

In this case, you’ll notice that Merge & Center is highlighted in gray. Click on it, and your cell will unmerge.

Unmerge cells in Excel

How to Unmerge Multiple Cells in Excel

What if you want to unmerge multiple cells in Excel? There are two quick ways to do this. One option is to click and drag to select all the merged cells, then click Merge & Center. All will unmerge simultaneously.

Unmerge multiple cells in Excel

If the merged cells aren’t together, you can select them by holding down Control/Command on your keyboard. Then, click into each cell and then click Merge & Center.

Your last option is to unmerge a single cell. Then, with the cell selected, click Format Painter on the ribbon.

How to unmerge in Excel

With that complete, drag over your remaining merged cells. They will mirror the formatting of the unmerged cell, meaning they too will unmerge.

As you can see, Excel offers a variety of ways to unmerge cells. This is useful for your own spreadsheets, or those sent to you by others. It gives you more control over your worksheet’s layout.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Column subtotals in ExcelSubtotal in Excel
Next Post:Add Cells in ExcelExcel add up column

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top