View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chas486 Chas486 is offline
external usenet poster
 
Posts: 1
Default Merge Cell Cut & Paste

I have a complex sheet that has several merged cells. When I cut data from
one cell (2 merged cells), to paste it into another cell (2 merged cells),
the original cell I cut it from loses its merged cell format and goes back to
2 cells. How do I protect that format so that the cells don't unmerge? I
can use the protection on the sheet to keep borders from deleting, but not
the merge cell function.