The way to Merge and Unmerge Cells in Microsoft Excel


Merging and unmerging cells in Microsoft Excel is an effective way to maintain your spreadsheet clear, well-organized, and straightforward to know. The most typical use is making a header to determine the content material throughout a number of columns, however regardless of the explanation, it will possibly rapidly be carried out in Excel.

Word that Excel doesn’t assist you to cut up a cell the identical method which you can in a desk in Microsoft Phrase. You may unmerge cells that you’ve got beforehand merged.

Merging Cells

Merging cells combines two or extra cells right into a single cell. To do that, choose the cells you wish to merge.

Highight cells in Excel

Subsequent, on the “Dwelling” tab, click on the “Merge and Middle” button.

Merge and Center

Because the title implies, this may merge the chosen cells. Any textual content within the cells might be centered by default.

Merged Cells in Excel

As you may see, the A1, B1, and C1 cells have merged into one single cell. There are additionally different choices to select from. To entry these choices, click on the arrow subsequent to “Merge and Middle” and a dropdown menu will seem.

dropdown options

These choices are comparatively straight-forward. One factor to notice is that “Merge Throughout” merges solely the chosen cells in a row, however not the cells in a column.

So what occurs if we merge cells that have already got content material in them? That is one thing you need to be very cautious with. Merging cells with already-existing knowledge solely retains the upper-left worth and discards all different values. Which means all knowledge besides the info within the upper-left cell might be deleted. Microsoft does provide you with a warning message earlier than merging the cells, although, however do be sure you perceive that the info might be misplaced earlier than persevering with.

Unmerging Cells

Unmerging cells splits beforehand merged cells again into single cells. Doing so is as straightforward as deciding on the merged cells after which clicking the “Merge and Middle” button once more to toggle the setting off. Equally, you may click on the arrow subsequent to “Merge and Middle” to entry the drop-down menu after which click on “Unmerge Cells.”

Unmerge Cells

If you happen to unmerge a cell that incorporates knowledge, all the knowledge is positioned within the top-left cell, and all different cells might be empty.

Leave a Reply