On the pop-up that appears, click on OK to confirm.ģ. Select the Cells that you want to merge, click on the Home tab and then click on Merge button.Ģ. How to Merge Cells in Excelįollow the steps below to Merge Cells in Excel.ġ. Luckily, Excel does provide a warning message informing you about such data loss when you try to Merge cells in Excel. Similarly, when you Unmerge cells containing data, all the data gets placed in the first cell and other cells become empty. When you Merge cells containing data, only the data in the upper left cell (first cell) will remain in the resulting Merged cell, while data in other cells gets discarded (See image below). What Happens to Content in Merged Cellsīefore going ahead with the steps to Merge cells in excel, it important to understand as to what happens when you Merge two or more cells containing data in an Excel spreadsheet. While the Merge function combines cells, the Unmerge option in Excel splits back previously Merged cells into individual single cells, just as they existed before being merged.
0 Comments
Leave a Reply. |