Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default XL2003: "Auto row height" with Wrap Text driving me nuts

Hi

Anyone know of a workaround for this? If you turn Wrap Text on in a
cell or cells, Excel insists on reacting to entry of cell contents,
column resizing etc by resizing the row to a ridiculous height (about
twice the height of the text). Select All - Autosize rows does just
the same.

Even when you enter some text that appears as half the width of the
column, if you have Wrap Text set for that cell, Excel decides that
the row height needs doubling and resizes it.

I'm sure XL2000 didn't do this...

(and another thing - once you format one cell e.g. Bold Italic, Excel
insists on "knowing best" and formatting anything you enter below it
in the same way - even after you've forced the font back to normal a
few times. Very annoying, if like me you like to bold a header row
only.)

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
"Wrap text" makes row larger than text resulting in white space. Sherry Excel Discussion (Misc queries) 0 September 5th 06 10:05 PM
Disabling "wrap text" neuters alt-return line feeds within cell [email protected] Excel Discussion (Misc queries) 2 August 21st 06 04:49 PM
Count the number of Lines in a "wrap text"-cell MichaelS_ Excel Discussion (Misc queries) 2 March 20th 06 08:15 AM
"Wrap Text" problem in Excel 2003 SP2 jab Excel Discussion (Misc queries) 2 October 27th 05 03:09 PM
How to ensure that very large blocks of text "wrap" in a cell? nicholson61 Excel Discussion (Misc queries) 1 October 19th 05 05:18 PM


All times are GMT +1. The time now is 07:32 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"