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

Sharing workbooks limitations - Merged Cells 12
How do I locate merged cells in my Excel worksheet? 7
Merge Cell Cut & Paste 1
Page numbering with Merged Document and IF statements 1
Automatically color merged cells 1
Auto Merge text from multiple sources 0
MS Query results into merged rows 0
How to add cell's reference to cell's content 5

Top