How do i split an unmerged cell in two?

  • Thread starter Thread starter Guest
  • Start date Start date
technically you can't

while I hate merged cells, they have given me too many problems there are
still times they are usefull.

you can insert a new row or column to the right or below where you want your
data to be.
select the new row or column and the one above or to the left and merge the
rows or columns. go to the cell you wanted to split and unmerge.
 
I’d ban them if I had the say. Good for looks only. I lost several hours
yesterday with a book inherited from a merge-happy coworker. You can’t copy
regions that partially intersect a merger. When I worked around the merged
cells, I suspect they’re the reason I got the dissertation like “cannot paste
because source & target regions are different sizesâ€, even though both were
1x1.
 
Back
Top