View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maistrye Maistrye is offline
external usenet poster
 
Posts: 1
Default multiple lines in a cell


charles Wrote:
Does anyone know how to put multiple lines in a cell that is high enough
for
more than one line?
charles arnett


Two possibilities:

1) When you're typing, hit ALT-ENTER to keep typing on a new line for
the same cell.

2) If you just want the text to wrap to the next line when you're
typing, go to Format - Cells... Select Alignment, check off the Wrap
text cell, and hit OK. (As long as you haven't merged the cell, it
will automatically resize. If you've merged, you'll possibly have to
manually resize the cell.)

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=564298