Merging cells may be helpful at one stage of a spreadsheet’s existence, but you might find later that you need to unmerge those cells for a previously-unforeseen reason. Fortunately you can unmerge cells in a manner similar to how the cells were initially merged, so continue reading below to see how.  

Unmerging Combined Cells in Excel 2010

The steps in this article will show you how to undo a Merge & Center command that was performed on a group of cells. The result will be a series of individual cells that are restored to their normal, individual sizes and places in the Excel spreadsheet. The data that was contained within the merged cells will be placed entirely into the top-leftmost cell.  

   

        As mentioned earlier, the data that was in the merged cells will be placed in the cell at the top-left of the range of merged cells.   Printing is one of the biggest problems for most Excel users, but there are a number of common changes that you can make to your spreadsheet so that it looks better when printed on paper. One such change is repeating the top row on every page. This helps to identify the columns of data on each page that is printed after the first, which will ensure a better reading experience for your audience. He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices. Read his full bio here.

How to Unmerge Cells in Excel 2010 - 38How to Unmerge Cells in Excel 2010 - 38How to Unmerge Cells in Excel 2010 - 63