View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Keep text at top line of cell

FormatCellsAlignmentVerticalTop


Gord Dibben MS Excel MVP

On Fri, 28 Mar 2008 13:18:00 -0700, Sarah
wrote:

Is there a way to keep text on the top line of a cell?

For example, If in Cell 1A I have the number 1000 and Cell 1B I have text
that takes up two lines (text wrapped) the number in 1A automatically drops
down to the second line (as the cell becomes two lines high as well to match
1B's size).

Is there a way to keep that text in 1A on the top line of that cell?

Thank you for your help.