In one cell?

You could try Formatting to Wrap Text and Autofit Row

Or whenever you want a linefeed in a cell hit Alt + Enter


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 20:33:51 +0000, bobbydog
wrote:


hi luke
next prob for an excel newbie (total)
if in the left hand column A1 i start to write an address, it
continues in a long horizontal line
and if at any time i want to start a new line then it goes into A2
what i want to do is to put in a full address as it would appear on an
envelope
HOW