Pasting large amount of text into a single cell

[Hal]

In Excel 2000, when pasting a large amount of text into a single cell the
data runs over the cells below it. How can I keep all the data into one
cell without having it run over the cells below it.

Thank you in advance.

Hal

 

[Max]

Maybe:
Format > Cell > Alignment tab
Check "Wrap text" > OK

 

[Dave Peterson]

Try pasting into the formulabar directly.

In Excel 2000, when pasting a large amount of text into a single cell the
data runs over the cells below it. How can I keep all the data into one
cell without having it run over the cells below it.

Thank you in advance.

Hal

 

[Max]

Try pasting into the formulabar directly

On the nth re-read of the original post ..
... think the above *is* what Hal was looking for <g>
cheers, Dave!

 

[Dave Peterson]

Sometimes, getting the real meaning is the difficult part <vbg>.

I know I like to read the questions the way I want--not always meaningful to the
OP, but fun nevertheless.

 

[Max]

Sometimes, getting the real meaning is the difficult part <vbg>.

I know I like to read the questions the way I want--
not always meaningful to the OP, but fun nevertheless.

Think a lot of OPs are *thankful* that
you and a host of other experienced regulars
are having "fun" here ..

cheers