0

Merging and unmerging cells in Microsoft Excel is a great way to keep your spreadsheet clean, well-organized, and easy to understand. The most common use is creating a header to identify the content across several columns, but no matter the reason, it can quickly be done in Excel.

Note that Excel doesn’t allow you to split a cell the same way that you can in a table in Microsoft Word. You can unmerge cells that you have previously merged.

Merging Cells

Merging cells combines two or more cells into a single cell. To do this, select the cells you want to merge.

Highight cells in Excel

Next, on the “Home” tab, click the “Merge and Center” button.

Merge and Center

As the name implies, this will merge the selected cells. Any text in the cells will be centered by default.

Merged Cells in Excel

Read the remaining 9 paragraphs


Post a Comment Blogger

We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.

 
Top