View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default How do I remove extra space when text wrapping?

Try setting the cell vertical allignment to the top of the cells using the menu

Format - Cells - Alignment - Top

"chosen-girl" wrote:

I am working in Excel 2007. I have a column with cells containing various
lengths of text. The control is set on wrap text and the alignment is on
bottom. The problem is that all of the cells look fine on the screen,
however, when I print there is added space (a whole blank line) at the
beginning of some of the cells. The cells are not sizing themselves
properly. Trim does not work to remove the space. Any suggestions?