Keep text at top line of cell

[Sarah]

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.

 

[Pete_UK]

Highlight the cells in question, click on Format | Cells | Alignment
(tab) and check the pull-down on Vertical alignment. This is set to
Bottom by default, but you can change it to Top.

Hope this helps.

Pete

 

[Gord Dibben]

Format>Cells>Alignment>Vertical>Top


Gord Dibben MS Excel MVP

 

[Sarah]

Thanks, I knew there had to be an easy way to do that. This place is great.
Thanks for the help. Very much appreciated.