Skip to main content

How to merge and unmerge cells in Microsoft Excel

Microsoft Excel 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.

Check out our other articles for more Excel tips and tricks.




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.

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

Editors' Recommendations

Mark Coppock
Mark has been a geek since MS-DOS gave way to Windows and the PalmPilot was a thing. He’s translated his love for…
Even Microsoft thinks ChatGPT needs to be regulated — here’s why
A MacBook Pro on a desk with ChatGPT's website showing on its display.

Artificial intelligence (AI) chatbots have been taking the world by storm, with the capabilities of Microsoft’s ChatGPT causing wonderment and fear in almost equal measure. But in an intriguing twist, even Microsoft is now calling on governments to take action and regulate AI before things spin dangerously out of control.

The appeal was made by BSA, a trade group representing numerous business software companies, including Microsoft, Adobe, Dropbox, IBM, and Zoom. According to CNBC, the group is advocating for the US government to integrate rules governing the use of AI into national privacy legislation.

Read more
You won’t believe how much ChatGPT costs to operate
The ChatGPT website on a laptop's screen as the laptop sits on a counter in front of a black background.

A new report claims to know how much ChatGPT costs to run per day, including how much each query approximately costs. The popular text-to-speech chatbot might have set off an AI revolution in November 2022, but has proven extremely expensive to maintain.

The new report comes from Dylan Patel, chief analyst at the research firm SemiAnalysis, who says it costs approximately $700,000 per day, or 36 cents per query, to keep the chatbot up and running.

Read more
Elon Musk threatens to sue Microsoft over AI training
tesla and spacex ceo elon musk stylized image

Shortly after reports emerged on Wednesday that Microsoft is about to remove Twitter from its ad platform, Twitter CEO Elon Musk fired back with the threat of a lawsuit, claiming the computer giant illegally used Twitter’s data, such as users’ tweets, to train its artificial intelligence (AI) tools.

“They trained illegally using Twitter data,” Musk tweeted, adding: “Lawsuit time.”

Read more