P
Pat
I am searcing for an answer to Excel 2003 and Excell 2007 not working
properly when I apply the Autofit Row Height option.
I have read most, if not all, of the responses on this and other sites and
they all want to point to there being merged cells involved.
To be sure this was not the problem (I was given the worksheet to correct
the problem), I copied the text from the cell and pasted it into Notepad and
then copied the text into a new sheet in a new workbook. I did this on two
different computers. One running Vista Business and Office Professional 2007
SP1, the other running Windows XP Professional SP2 and Office Professional
2003 SP3.
On both machines, the response was the same!
When I pasted the text into the blank cell I got one long string of text (as
expected). I formatted the column width for 65 and the cell for General, Top
and Wrap Text. When these were applied, I got a cell with 14 lines (Arial
12) of text. When I applied the Autofit Row Height there was no change.
When I manually expand the row height I get the additional 7 lines of text.
If I then select the Autofit Row Height it shrinks the row back down to the
14 lines!
Tried the old "double-click the bottom line of the row" to see if it would
expand back to show all my lines of text and it did not; manally expanded the
row height again to show all the lines and did the double-click and it shrunk
the row back to the 14 lines.
Setting the column width to 87 reduced the number of lines it would autofit
to 11. Each time I widened the column and asked it to autofit the row
height, I got fewer lines but basically the same number of characters, 1,183
to 1,233.
Is is possible that there is a character limit involved in the Autofit Row
Height function? Anything below the 1000 +/- character mark and it works
fine!.
Pat
IT Trainer
properly when I apply the Autofit Row Height option.
I have read most, if not all, of the responses on this and other sites and
they all want to point to there being merged cells involved.
To be sure this was not the problem (I was given the worksheet to correct
the problem), I copied the text from the cell and pasted it into Notepad and
then copied the text into a new sheet in a new workbook. I did this on two
different computers. One running Vista Business and Office Professional 2007
SP1, the other running Windows XP Professional SP2 and Office Professional
2003 SP3.
On both machines, the response was the same!
When I pasted the text into the blank cell I got one long string of text (as
expected). I formatted the column width for 65 and the cell for General, Top
and Wrap Text. When these were applied, I got a cell with 14 lines (Arial
12) of text. When I applied the Autofit Row Height there was no change.
When I manually expand the row height I get the additional 7 lines of text.
If I then select the Autofit Row Height it shrinks the row back down to the
14 lines!
Tried the old "double-click the bottom line of the row" to see if it would
expand back to show all my lines of text and it did not; manally expanded the
row height again to show all the lines and did the double-click and it shrunk
the row back to the 14 lines.
Setting the column width to 87 reduced the number of lines it would autofit
to 11. Each time I widened the column and asked it to autofit the row
height, I got fewer lines but basically the same number of characters, 1,183
to 1,233.
Is is possible that there is a character limit involved in the Autofit Row
Height function? Anything below the 1000 +/- character mark and it works
fine!.
Pat
IT Trainer