View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I enter a line break within a cell?

alt-enter if you're typing
or "& char(10) &" if you're using a formula:

="this is line 1" & char(10) & "this is not line 1"

format|Cells|alignment tab|check wrap text.



Striving for efficiency wrote:

--

Dave Peterson