A8:B8 merged pair (A9:B9 through A24:B24 also merged pairs). I highlight 3
cells on other sheet. Then I right click to pull down menu and select copy;
then right click over cells A8-D8 of this sheet. Data drops into A8 B8 & C8
and A8 and B8 unmerge. I need the first cell of data to paste into A8:B8
merged. Is there a way to make it do that?
--
Therapist Matt


"Bernard Liengme" wrote:

I have merge K1:N1 on Sheet 1
I copy a single cell from Sheet3 to the merged cells
The result is merged on the four cells
I paste with either CTRL+V ,or by right clicking and using Paste
What is different with you? (I also am using XL2003)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Therapistmatt" wrote in message
...
When I try to paste from another sheet into merged cells the cells unmerge
placing the data that is supposed to be in the adjacent collumn into the
now
unmerged cells. As this sheet is as a standard form throughout our
department
not using merged cells is not an option. How do I get the cells to stay
merged when pasting?
--
Therapist Matt