You can click in the formula bar (or press F2) and do the paste there
(ctrl/v) -- that should leave the cell formatting intact.
Bob Umlas
Excel MVP

"jan@longcroft" wrote:

I have formatted my column for word-wrap but when pasting in text (from
Word), the word-wrap is ignored and the text is pasted in one long line, as
if over-riding the formatting of the cell. Is there a way to 'lock' word
wrap so that it cannot be over-ridden?