It is not possible to unmerge only a part of a merged range. With the previously merged cells selected, you can access the "Unmerge" option from the Merge icon in the toolbar or the Format menu in the workbook menu. However, unmerging cells does not restore the data previously in those cells.
QUICK SPREADSHEET MERGE HOW TO
How to Unmerge CellsĬells that have been merged can also be unmerged.
To undo an action, either use the keyboard shortcut Ctrl + Z, select the Undo button in the Toolbar, or choose the Undo option in the Edit menu. To return the data, you will have to undo the merge and then move the data before merging the cells again. Merging cells may delete data from your worksheet.
When you merge cells where some data will be lost, will warn you that only the top-leftmost value will remain. Merging horizontally will merge the leftmost value in each row across all selected rows and merging vertically will merge the topmost value in each column across all selected columns. If you merge cells with values in multiple cells, only the top-leftmost value will remain. Looking for a quicker way to merge cells? Try the merge keyboard shortcut ( Ctrl + M).īy default, clicking merge cells will merge the top-leftmost value across all selected cells.
Merged cells can also be unmerged, which we'll cover later in this article. supports three merge options: Merge All, Merge horizontally, and Merge vertically.
0 kommentar(er)
