Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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? -- LPS "Dave Peterson" wrote: 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: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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: 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? -- LPS "Dave Peterson" wrote: 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: 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 -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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. -- LPS "Dave Peterson" wrote: 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: 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? -- LPS "Dave Peterson" wrote: 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: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Formatting
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 cells Alignment. "LPS" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Formatting cells, Need help solving a problem with excel | Excel Discussion (Misc queries) | |||
Lost formatting in Excel | Excel Discussion (Misc queries) | |||
Excel conditional formatting error | Excel Discussion (Misc queries) | |||
Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions |