Are there limits autofit row height when the cell is set to wrap t


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
 
Ad

Advertisements

G

Gord Dibben

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
 
P

Pat

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
 
Ad

Advertisements

G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top