View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How do I get the text to continue on the next line when its long

Just to make sure I understand your question: you have typed a fairly
long text string into a single cell in a spreadsheet, and instead of
stretching out toward the extreme right side of the spreadsheet you'd
like the text to appear in a uniform range on the spreadsheet. Is that
correct?

If yes, starting with the cell that contains the text as the anchor
cell, highlight the range where you would like the text to appear. On
the menu click ~Edit ~Fill ~Justify and the text will wrap to conform
to the range you highlighted.