Wednesday, October 25, 2017

Split merged cells

Split merged cells

To unmerge cells immediately after merging them, press Ctrl + Z. Otherwise do this:

  1. Click the merged cell and click Home > Merge & Center.

merge and center button on the ribbon

The data in the merged cell moves to the left cell when the cells split.

Before and after unmerging cells

No comments:

Post a Comment