Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-Line Text In Same Cell | Excel Discussion (Misc queries) | |||
trying to reference a cell in a line of text | Excel Discussion (Misc queries) | |||
Can you get line breaks in a text cell | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Forcing text onto new line in cell | New Users to Excel |