Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I clear blank space at the top of a word-wrapped text cell?
Often when I set cells to word-wrap and then auto-fit the row height, cells
with text will end up with a blank line or two at the top. It's not extra spaces in the text because when I go to the formula bar, there's nothing before the start of the text. I can manually adjust the size of each row, but that's a hassle and not very consistent! Thanks. |
#2
|
|||
|
|||
In the same Format, Cells, Alignment, select Top in Text Alignment Vertical.
HTH, Carole O "mirage1210" wrote: Often when I set cells to word-wrap and then auto-fit the row height, cells with text will end up with a blank line or two at the top. It's not extra spaces in the text because when I go to the formula bar, there's nothing before the start of the text. I can manually adjust the size of each row, but that's a hassle and not very consistent! Thanks. |
#3
|
|||
|
|||
Thanks, Carole... I did try that, but then it just moves the blank space to
the *bottom* of the cell. Either way, I end up with a row that's not the right height for the contents. "Carole O" wrote: In the same Format, Cells, Alignment, select Top in Text Alignment Vertical. HTH, Carole O "mirage1210" wrote: Often when I set cells to word-wrap and then auto-fit the row height, cells with text will end up with a blank line or two at the top. It's not extra spaces in the text because when I go to the formula bar, there's nothing before the start of the text. I can manually adjust the size of each row, but that's a hassle and not very consistent! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted blank line in cell with wrapped text | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Blank cell conversion to text | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |