Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits autofit row height when the cell is set to wrap t
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits autofit row height when the cell is set to wrap t
Pat
Excel help on specifications tells you that you can place 32767 characters in a cell but only 1024 will show or be printed. Add an Alt + Enter every 80-100 characters to add line feeds which increases the default 1024 limit. Nothing to do with merged cells in your case. Just too much text. Gord Dibben MS Excel MVP On Mon, 24 Mar 2008 14:04:04 -0700, Pat wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits autofit row height when the cell is set to wr
Gord,
Thanks so much for the reply! I probably searched for every word but "specifications" when I was trying to find the answer! My mind set was on "row height" when it should have been on "cell limits". Thanks again, Pat IT Trainer "Gord Dibben" wrote: Pat Excel help on specifications tells you that you can place 32767 characters in a cell but only 1024 will show or be printed. Add an Alt + Enter every 80-100 characters to add line feeds which increases the default 1024 limit. Nothing to do with merged cells in your case. Just too much text. Gord Dibben MS Excel MVP On Mon, 24 Mar 2008 14:04:04 -0700, Pat wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits autofit row height when the cell is set to wr
Yep.
If you know the right keyword Help is a great tool. Finding the keyword is the trick. Unfortunately there is no help for "how to pick a keyword"<g Gord On Tue, 25 Mar 2008 06:18:20 -0700, Pat wrote: Gord, Thanks so much for the reply! I probably searched for every word but "specifications" when I was trying to find the answer! My mind set was on "row height" when it should have been on "cell limits". Thanks again, Pat IT Trainer "Gord Dibben" wrote: Pat Excel help on specifications tells you that you can place 32767 characters in a cell but only 1024 will show or be printed. Add an Alt + Enter every 80-100 characters to add line feeds which increases the default 1024 limit. Nothing to do with merged cells in your case. Just too much text. Gord Dibben MS Excel MVP On Mon, 24 Mar 2008 14:04:04 -0700, Pat wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to control row height and text wrap in non-merged cell ??? | Excel Discussion (Misc queries) | |||
Minimum cell height while using AUTOFIT? | Excel Discussion (Misc queries) | |||
Cell Displays ### and Won't AutoFit for Height | Excel Discussion (Misc queries) | |||
Excel adjust row height upon merging 2 cell with word wrap | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) |