Carriage returns in Excel

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Excel seems to be the bain of my life at the moment

I am trying to create a spreadsheet and one column is going to contain address, however, when ever i press the enter key in the cell it just moves to the next cell, how can i set it up so that i can use the enter key within the cell

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

If you press alt-enter it adds another line to the cell.

 

Thanks Phil, I can finish my home work now

 

finish? ... finish???? it's never ending

 

You can say that again.