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.
height as needed, as text is typed in, so all the text is
displayed.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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 **
--
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.
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.
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.
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.