Merge Cell Cut & Paste

C

Chas486

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.
 
R

Ron@Buy

I don't believe that you can protect the merge when using 'cut' : you are
cutting the contents (including format) to paste elsewhere! The only quick
solution I can think of is; after 'paste', click on the format brush and
click back on the cut cell.
Perhaps somebody else has a better solution!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Document Merge Formatting Issue 0
Merging from an Excel file with graphics 1
Code to cut a paragraph that's followed by a table 2
How to add cell's reference to cell's content 5
Pasting into merged cells 1
Cant merge cell 2
Excel; tabbing through protected worksheet 2

Top