How to Merge Cells in Excel


Learning how to merge cells in Excel comes in handy when making a cell look like it’s split. Whilst we cannot actually split an individual cell, we can make it appear as if a cell has been split by merging it with the cells above.

Click here for more Excel Guides

This can allow you to format your document in a different way, as long as you know how to merge cells in Excel. If not, we are going to go through the steps today, so you can be a formatting professional! 

How to Merge Cells

How to Merge Cells in Excel
Credit: Microsoft
  • Step 1: Select all of the cells you want to merge so that they are highlighted.
  • Step 2: Select Merge & Center from the toolbar.

That’s it. Your cells will be merged together. If you are merging multiple cells that have content in them, it is worth noting only the contents of one cell, the upper-left cell for the left to right languages or the upper-right cell for right to left languages, will appear in the merged cells, with all other content deleted. 

How to Unmerge Cells

How to Merge Cells in Excel
Credit: Microsoft

If you want to unmerge cells, the process is very simple as well.

  • Step 1: Click on the Merge & Center down arrow with your Merged Cells highlighted
  • Step 2: Select Unmerge Cells.

It is worth noting that you cannot split unmerged cells and the data inside this mega cell might place itself in strange ways on Excel, depending on the formatting of the rest of the page. Now you can easily format your page in a way that makes sense for you.

The fighting in Ukraine is causing families to flee their homes. Please give now to save lives and protect people in need. Donate today!

Keep the conversation going by heading over to our Facebook and Twitter pages. You can also find us on Instagram, TikTok, and. Be sure to also check out our friends over on GameByte and Sporf.

Along with the latest games, merch, and accessories, the GameByte Shop has an epic Loyalty Points Scheme – earning you points for every £1 you spend. Sign up to hear about exclusive deals, PS5 console drops, and more!

<div class=”klaviyo-form-VAkrCV”></div>

Featured Image Credit: Microsoft