How do i stop paste from spreading text across multiple cells ?
 

Hi Chris,

I think the short answer is "no". What you might consider doing though is
to use a temporary sheet that you paste into and then copy/move the pasted
data into the cells where you want it and then and then delete the temporary
sheet.

HTH

Peter Beach

"Chris W." wrote in message
...
Using Excel 2000:
Is there anyway to stop Excel's Paste method from taking multiline data
thats been put onto the clipboard and spreading it across multiple cells. I
need to copy large chunks of text and graphics and paste into distinct cells
for later retrieval.