software

Why is it, with Excel 2000, when you change the text orientation to vertical
and / or invoke text wrapping, and then try to use the auto row height
feature (double-click on the row divider), the row height snaps to about 5
times what it needs to be? There are no spaces or blank lines in any of the
cells within the rows yet the rows all jump to a height way beyond the length
of the text. When cell orientation is returned to the default horizontal and
text wrapping is removed, the cell height snaps to the default for the
current font.

This is driving me nuts... any help will be greatly appreciated.
Thx.
--
LPS

Do you have any hidden columns in your worksheet?

Does the cell in that hidden column on that troublesome row have lots of text?

Excel will use those hidden cells when autofitting a rowheight.

LPS wrote:
gt;
gt; Why is it, with Excel 2000, when you change the text orientation to vertical
gt; and / or invoke text wrapping, and then try to use the auto row height
gt; feature (double-click on the row divider), the row height snaps to about 5
gt; times what it needs to be? There are no spaces or blank lines in any of the
gt; cells within the rows yet the rows all jump to a height way beyond the length
gt; of the text. When cell orientation is returned to the default horizontal and
gt; text wrapping is removed, the cell height snaps to the default for the
gt; current font.
gt;
gt; This is driving me nuts... any help will be greatly appreciated.
gt; Thx.
gt; --
gt; LPS

--

Dave Peterson

I have unhidden all rows and columns and there are no merged cells. Hmmm...

I have tried using the Format | Rows | Autofit feature but nothing seems to
change it. Is this a glitch with text wrapping?
--
LPSquot;Dave Petersonquot; wrote:

gt; Do you have any hidden columns in your worksheet?
gt;
gt; Does the cell in that hidden column on that troublesome row have lots of text?
gt;
gt; Excel will use those hidden cells when autofitting a rowheight.
gt;
gt; LPS wrote:
gt; gt;
gt; gt; Why is it, with Excel 2000, when you change the text orientation to vertical
gt; gt; and / or invoke text wrapping, and then try to use the auto row height
gt; gt; feature (double-click on the row divider), the row height snaps to about 5
gt; gt; times what it needs to be? There are no spaces or blank lines in any of the
gt; gt; cells within the rows yet the rows all jump to a height way beyond the length
gt; gt; of the text. When cell orientation is returned to the default horizontal and
gt; gt; text wrapping is removed, the cell height snaps to the default for the
gt; gt; current font.
gt; gt;
gt; gt; This is driving me nuts... any help will be greatly appreciated.
gt; gt; Thx.
gt; gt; --
gt; gt; LPS
gt;
gt; --
gt;
gt; Dave Peterson
gt;

The only time I recall seeing this is with hidden cells (that contain long
text).

You sure you don't have anything in the other cells in that row?

Sorry, I don't have any better guess.

LPS wrote:
gt;
gt; I have unhidden all rows and columns and there are no merged cells. Hmmm...
gt;
gt; I have tried using the Format | Rows | Autofit feature but nothing seems to
gt; change it. Is this a glitch with text wrapping?
gt; --
gt; LPS
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Do you have any hidden columns in your worksheet?
gt; gt;
gt; gt; Does the cell in that hidden column on that troublesome row have lots of text?
gt; gt;
gt; gt; Excel will use those hidden cells when autofitting a rowheight.
gt; gt;
gt; gt; LPS wrote:
gt; gt; gt;
gt; gt; gt; Why is it, with Excel 2000, when you change the text orientation to vertical
gt; gt; gt; and / or invoke text wrapping, and then try to use the auto row height
gt; gt; gt; feature (double-click on the row divider), the row height snaps to about 5
gt; gt; gt; times what it needs to be? There are no spaces or blank lines in any of the
gt; gt; gt; cells within the rows yet the rows all jump to a height way beyond the length
gt; gt; gt; of the text. When cell orientation is returned to the default horizontal and
gt; gt; gt; text wrapping is removed, the cell height snaps to the default for the
gt; gt; gt; current font.
gt; gt; gt;
gt; gt; gt; This is driving me nuts... any help will be greatly appreciated.
gt; gt; gt; Thx.
gt; gt; gt; --
gt; gt; gt; LPS
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Nope, there is nothing else hidden... from reading other posts it seems as
though this is a bug with Excel. Guess it will have to be manually adjusted,
unless someone else has a suggestion.

Thanks for your prompt help.
--
LPSquot;Dave Petersonquot; wrote:

gt; The only time I recall seeing this is with hidden cells (that contain long
gt; text).
gt;
gt; You sure you don't have anything in the other cells in that row?
gt;
gt; Sorry, I don't have any better guess.
gt;
gt; LPS wrote:
gt; gt;
gt; gt; I have unhidden all rows and columns and there are no merged cells. Hmmm...
gt; gt;
gt; gt; I have tried using the Format | Rows | Autofit feature but nothing seems to
gt; gt; change it. Is this a glitch with text wrapping?
gt; gt; --
gt; gt; LPS
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Do you have any hidden columns in your worksheet?
gt; gt; gt;
gt; gt; gt; Does the cell in that hidden column on that troublesome row have lots of text?
gt; gt; gt;
gt; gt; gt; Excel will use those hidden cells when autofitting a rowheight.
gt; gt; gt;
gt; gt; gt; LPS wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Why is it, with Excel 2000, when you change the text orientation to vertical
gt; gt; gt; gt; and / or invoke text wrapping, and then try to use the auto row height
gt; gt; gt; gt; feature (double-click on the row divider), the row height snaps to about 5
gt; gt; gt; gt; times what it needs to be? There are no spaces or blank lines in any of the
gt; gt; gt; gt; cells within the rows yet the rows all jump to a height way beyond the length
gt; gt; gt; gt; of the text. When cell orientation is returned to the default horizontal and
gt; gt; gt; gt; text wrapping is removed, the cell height snaps to the default for the
gt; gt; gt; gt; current font.
gt; gt; gt; gt;
gt; gt; gt; gt; This is driving me nuts... any help will be greatly appreciated.
gt; gt; gt; gt; Thx.
gt; gt; gt; gt; --
gt; gt; gt; gt; LPS
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;


Maybe its the font you are using, try it with times roman or arial. Turn off
Bold
or
You may be using toolbar buttons to set your wordwrap or orientaion.
Maybe use the dialog.

Format gt; cells gt; Alignment.
quot;LPSquot; wrote:

gt; Why is it, with Excel 2000, when you change the text orientation to vertical
gt; and / or invoke text wrapping, and then try to use the auto row height
gt; feature (double-click on the row divider), the row height snaps to about 5
gt; times what it needs to be? There are no spaces or blank lines in any of the
gt; cells within the rows yet the rows all jump to a height way beyond the length
gt; of the text. When cell orientation is returned to the default horizontal and
gt; text wrapping is removed, the cell height snaps to the default for the
gt; current font.
gt;
gt; This is driving me nuts... any help will be greatly appreciated.
gt; Thx.
gt; --
gt; LPS