Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mirage1210
 
Posts: n/a
Default 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   Report Post  
Carole O
 
Posts: n/a
Default

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   Report Post  
mirage1210
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unwanted blank line in cell with wrapped text bbl Excel Discussion (Misc queries) 2 February 11th 05 09:29 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM
Blank cell conversion to text MaryMMG New Users to Excel 1 December 1st 04 08:56 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"