Pasting into merged cells

A

ann

I have a merged cell in which I want to paste text from another cell. Every
time I try get an error message saying that the cellsI have to unmerge the
merged cells first, paste, and them remerge. Is there any way to avoid doing
this? It is a real pain.
 
P

Paul C

If you copy only the text from the formula bar of the first cell you can
paste it into the formula bar of the second cell without going throught the
unmerge dance.

Alternately you could just put a formula in the merged cell referencing the
cell you want to copy from. You can than Copy-PasteSpecial-Values in the
merged cell.
 

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

Merge Cell Cut & Paste 1
How do I locate merged cells in my Excel worksheet? 7
Automatically color merged cells 1
Sharing workbooks limitations - Merged Cells 12
Help with merged cells 1
Merged Cell Sorting 1
Merging Cells that contain data anomaly 1
Copy/Paste into merged cells 2

Top