Merging and unmerging cells in Microsoft Excel is a great method to keep your spreadsheet tidy, well-organized, and easy to understand. The most common usage is developing a header to identify the content throughout numerous columns, but no matter the reason, it can rapidly be carried out in Excel.
Keep in mind that Excel does not permit you to divide a cell the exact same way that you can in a table in Microsoft Word. You can unmerge cells that you have previously merged.
Combining Cells
Merging cells integrates 2 or more cells into a single cell. To do this, pick the cells you want to merge.
Next, on the “Home” tab, click the “Merge and Center” button.
As the name suggests, this will combine the chosen cells. Any text in the cells will be centered by default.
As you can see, the A1, B1, and C1 cells have combined into one single cell. There are also other alternatives to select from. To access these options, click the arrow beside “Merge and Center” and a dropdown menu will appear.
These choices are fairly straight-forward. One thing to note is that “Merge Across” combines just the picked cells in a row, but not the cells in a column.
What takes place if we merge cells that already have material in them? This is something you have to be very cautious with. Combining cells with already-existing information just keeps the upper-left value and discards all other values. That implies all data other than the data in the upper-left cell will be erased. Microsoft does give you a caution message prior to merging the cells, however, however do make sure you understand that the data will be lost prior to continuing.
Unmerging Cells
Unmerging cells splits previously merged cells back into single cells. Doing so is as simple as picking the merged cells and then clicking the “Merge and Center” button once again to toggle the setting off. Likewise, you can click the arrow next to “Merge and Center” to access the drop-down menu and then click “Unmerge Cells.”
If you unmerge a cell that contains data, all of the information is positioned in the top-left cell, and all other cells will be empty.
Merging cells integrates 2 or more cells into a single cell. As you can see, the A1, B1, and C1 cells have actually merged into one single cell. Unmerging cells splits previously combined cells back into single cells. Doing so is as simple as picking the merged cells and then clicking the “Merge and Center” button once again to toggle the setting off.