Hi
I have a spreadsheet with one column having quite a bit of data in it.

I have tried to 'wrap text' as well as 'auto-fit' within the row to no avail.

Some of the information is still not visible no matter what I do.

I have exhausted all possible options including excel help online and cannot fix the problem.

Any help is greatly appreciated.

Thanks again

TS

SHAVED

WvR

You have to change your row height as well to see al the data
format
row
autofit

WvR

sorry I see you alrready tried that - can you post an example of a cell that won't fit?

WvR

Try dragging the row higher with your mouse - the same way you would a column

tessica

I ran into the same problem and found the following:

"You cannot use the AutoFit feature for rows or columns that contain merged cells in Excel"

http://support.microsoft.com/default...10&Product=xlw

Once I took all of the merged cells out, it worked fine. Ridiculous, eh?

Skiprr

I had the same issue with Excel 2007, and it drove me nuts. I was using data pulled in from another application, and formatted it specifically as TEXT to try to help avoid any interpretations by Excel of the text as numeric or date data (some of the text was Spanish, some contained time-stamps, curly brackets, etc.).

Even manually resizing the row height and adding hard carriage returns (Alt+Enter) didn't help. On most of the long lines all I got was the infuriating "##########".

Purely by accident, I reset one of the rows to GENERAL formatting rather than TEXT. Guess what? Normal word wrap ensued.

So it seems Excel 2007 won't always let you text-wrap text. Check the cell formatting and see if changing it to GENERAL does the trick.