Formatting cells so I can copy paragraphs

[breenan]

I know this is a bit confusing but I'm lost!

I am trying to duplicate a word document and copy paragraphs into excel cells to create a mini book.

I have tried to format the cells so that the words are aligned at the top and the text wraps.

For example, I am copying the following paragraph into a cell:

NOTE:

If, when you remove the rock from its box it appears to be excited, place it on some old newspapers. The rock will know what the paper is for and will require no further instruction. It will remain on the paper until you remove it.


Two things happen. First, the word NOTE in bold will go into one cell and the rest of the paragraph will go into the cell below. Second, even though I have tried to format all the cells to have the text aligned at the top and for the text to wrap, the cells keep reverting back to the default of bottom and no wrapping. Also, if there is more than one paragraph I am trying to copy into the cell they all end up in different cells.

Last question, if I type something into a cell (word, sentences) and I want to start a new paragraph how do I do that? Hitting enter moves me to the next cell.

If anyone can help I'd really appreciate it. I am making these little Pet Rock books for my nieces birthday party I did take a class once for excel but it's been a LONG time and obviously i have forgotten most of what I learned.

[VBA Noob]

Try selecting the cell then click into the formula bar and paste

http://www.bettersolutions.com/excel...T423111411.htm

For a carriage return use Alt + enter together

VBA Noob