Row Height

[nkrause]

In excel, when my test goes beyond my column width, I go
to Format - Cells - Alignment - Wrap text. Then, it does
not expand my row to show all of my text. I can double
click the row and nothing happens, I can select the whole
document and double click the row and nothing happens, I
can to to Auto-fit row and nothing happens. The only way
that I can make the row fit the text is to manually
expand each row by entering the row width or dragging
it. However, at work, when I select wrap text, it
automatically adjusts my row heights. I have the Office
XP Standard for Students and Teachers.

 

[JMay]

To expand All relevant Columns to show All Data Values in the Rows --
Highlight the Columnar Headings of Interest, say C thru K; Click on the
Actual C and drag over to K (Each will darken as you go). then move your
mouse to the line-separator between say D and E and double-click the line;
All Columns C thru K will adjust individually to the width necessary to
accommodate the largest entry in each of those columns.
HTH