Hi,
I couldn't get my copy of Excel (2003) to do otherwise, without choosing
either
Format Cells Alignment Wrap text
or
Format Column AutoFit Selection
AFTER pasting text into the cell. Are you saying this is not your experience?
PS: posting your e-mail address in a public forum is a good way to get both
spam and viruses sent to it.
-IanRoy

" wrote:

I need to paste alarge amount of text into a cell without affecting the width
of column or height of row