Keep text at top line of cell
 

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.

Keep text at top line of cell
 

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


On Mar 28, 8:18*pm, 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.

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.

Keep text at top line of cell
 

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

"Gord Dibben" wrote:

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.