automatic row height increase

T

Tony

Want to format a column of cells to increase the row
height as needed, as text is typed in, so all the text is
displayed.
 
P

Paul B

Tony, wrap the text in the cells, format, cells, alignment, check wrap test

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
L

Laura

Highlight the column, go to format cells, and under the
tab called alignment, check the wrap text box. That should
do it.
 
T

Tony

The wrap text is checked, and the text wraps while the
cell is selected. Soon as you click on another cell the
original cell shrinks back to a single line text. Also
tried "row - height - autofit" and that did not help.
 
R

RagDyer

Did you perhaps forget to mention that you might have also merged cells ?

What you describe is exactly what happens when cells are merged.
You see the word wrap while entry is taking place, and after <Enter>, you
revert back to the single row height.

*Automatic* word wrap and merged cells don't go together.
You can of course manually expand the row height to attain the desired
appearance.

You could try "Center Across Selection" in conjunction with word wrap to
obtain your desired *automatic* wrapping, and the appearance is almost
exactly identical.

<Format> <Cells> <Alignment> tab,
In the "Horizontal Window", scroll to the bottom and choose "Center Across
Selection", then check the "Word Wrap" box, and then make sure the "Merge
Cells" box is *unchecked*, then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


The wrap text is checked, and the text wraps while the
cell is selected. Soon as you click on another cell the
original cell shrinks back to a single line text. Also
tried "row - height - autofit" and that did not help.
 
G

gflexpro

Supplement is needed since you cannot get all the nutrients required for increasing height from the foods that we eat. Try Growth FlexV Pro and I am sure you will have your height increase.
 

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