Skip to main content

How to merge and unmerge cells in Microsoft Excel

Image used with permission by copyright holder

If you use Microsoft Excel, you'll recognize that it is a powerful application, capable of acting as a full-featured spreadsheet and data analysis tool.

While Excel is fully capable of some powerful data manipulation tasks, sometimes you need to do something simple like merge and unmerge cells. That essentially means placing the value of one into multiple cells or two cells into a single cell. That's exactly what we're going to cover in this how-to.

Recommended Videos

Difficulty

Moderate

Duration

15 minutes

What You Need

  • A desktop or laptop with Microsoft Excel

Using the Merge and Center command to merge cells

The easiest way to merge a single cell into multiple cells is using the Merge and Center command from the main menu. This command takes the value in the left-most cell in left-to-right languages or the right-most cell in right-to-left languages and places it into however many cells are selected. It's particularly useful when you want a column header to cover multiple columns, such as in the sample spreadsheet where we would like the "Q1 Sales" title to refer to all of the first quarter months.

(This data might later be used to create a graph in Excel.)

Step 1: Select the cells you want to merge into and click on the Merge and Center command.

how to merge cells in excel selecting
Mark Coppock/Digital Trends

Step 2: If you simply click on the Merge and Center button, then the "Q1 Sales" will be spread across the three cells and centered. Note that any data in the cells to the right will be overwritten.

Cells merged across rows in Microsoft Excel.
Mark Coppock/Digital Trends

Step 3: You can also select Merge Across and the cells will be merged but the content will be moved to the left. The Merge Cells function will do the same in most cases.

how to merge cells in excel merged across 2
Mark Coppock/Digital Trends

Using the Merge Cells command to unmerge cells in Microsoft Excel

It's easy enough to unmerge cells that you've merged using the Merge Cells command.

Simply select the cells you wish to unmerge, and select Unmerge Cells from the drop-down menu.

how to merge cells in excel unmerged
Mark Coppock/Digital Trends

Using the Concatenate function to merge cells in Microsoft Excel

Sometimes we want to take two columns and merge them into one, keeping the information from both columns. In our sample spreadsheet, we'd like to take the first name and last name and combine them into a cell containing the full name.

This is easily done by using the Concatenate function. We create the formula in the cell where we want the full name to populate. The formula is in the format "=CONCATENATE(A2," ",B2), where A2 refers to the left-most cell in the second row, B2 refers to the right-most cell in the second row, and the middle section indicates that we want the data separated by a space. Of course, the cell references will change as you move down your table. We could use any symbol we like here. Note that any data in the column where the data is to be merged will be overwritten.

how to merge cells in excel merged with concatenate function
Mark Coppock/Digital Trends

Using these steps you can easily merge, unmerge, and generally manipulate the layout of your spreadsheet. It has possibilities beyond a simple table, as you'll discover with regular use.

Recording important data that you don't want changing? Learn how to lock cells in Microsoft Excel and protect your data.

Mark Coppock
Former Digital Trends Contributor
Mark Coppock is a Freelance Writer at Digital Trends covering primarily laptop and other computing technologies. He has…
Best Microsoft Office deals: Get Word, PowerPoint, and Excel for free
Students using Microsoft Office software on their laptops outside.

There is almost always going to be a discussion between Microsoft vs. Google and which one has the best business and productivity tools, but Microsoft has certainly been around longer and ingrained itself in a lot of businesses, making it a standard. As such, you may want to grab yourself a copy or subscription, although Microsoft Office can get quite pricey, and while there is a free trial of Microsoft Word, it's not really the same thing. Luckily, there are a few Microsoft Office deals with grabbing, which is why we've gone out and collected some of our favorites for you below.
Best Microsoft Office deals
Microsoft Office is a pay once, receive once service. You don't have to pay recurring monthly fees to use it, but the software also never updates. For what it's worth, the Microsoft Office packages are labelled "2021", so they're all fairly recent but also ripe for a good deal. With the exception of AI integrations, not much has really changed in the past couple of years when it comes to your basic document creation and these programs should continue to be effective for years to come. Depending on what package you get, you'll get access to different apps, based on the needs of the target audience. For example, Microsoft Office Home & Student 2021 keeps it lean and cool and with Microsoft Word, Microsoft Excel, and Microsoft PowerPoint being the only apps included.

Here are our favorite deals for the classic Microsoft Office experience:

Read more
How to alphabetize lists in Microsoft Word
Microsoft word document.

Microsoft Word is a powerful word processing application that's capable of creating complex and compelling documents. It can also perform very simple but useful tasks, like alphabetizing a list.

Even if you know how to use Microsoft Word, you might not know how to alphabetize lists. Well, here's how to do that.

Read more
How to draw in Microsoft Word
Computer user touching on Microsoft Word icon to open the program.

Microsoft Word is jam-packed with features and formatting options. It also has numerous ways for users to add shapes, diagrams, and other visual elements to regular word processing templates. But even if you know how to use Microsoft Word, you might not be aware that you can even draw and sketch in the application.

Whether you’d like to call attention to a certain part of your document, or you’d just like to add some flair, this guide will teach you the ins and outs of drawing in Microsoft Word.

Read more