How to copy single cell into cell that is merged from two cells?

G

Guest

I have a single cell in one worksheet that I want to copy into another
worksheet where the cell is a merged cell of two cells. When I do this it
copies the one cell into both cells of the merged cells. I end up with two
of the same thing. I can not unmerge the cells that I am copying in to.
 
G

Guest

Dave,

I am not sure what you mean. Can you explain it more? Point of
clarification. I have a range of single cells that I need to paste into a
range of merged cells ( two cells merged together to make one).
 
D

Dave Peterson

One cell at a time.

Select the cell to copy from.
highlight the value/formula in the formula bar
rightclick|copy
hit escape

select the cell to copy to.
click inside the formula bar
rightclick|paste
hit enter.
 

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

How do I locate merged cells in my Excel worksheet? 7
Merge Cell Cut & Paste 1
Pasting into merged cells 1
Formula from a single cell to a merged cell 4
sorting two columns of merged cells 1
Copy/Paste into merged cells 2
Why does picking an cell highlight two cells? 1
Count with merged cells 2

Top