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

Could you tell which version of EXcel you are using.
If all wrapped text is not visible, it may be because the row is set to a specific height. Try to adjust the row height and check if it is working.

You have to change your row height as well to see al the data
Format
Row
Autofit

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

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

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.aspx?scid=kb;en-us;212010&Product=xlw

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

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. :confused: Check the cell formatting and see if changing it to GENERAL does the trick.

Type in the word "Limitations" into Excel Help. You will see that each cell can accommodate a maximum of 1,024 characters, even though 32,767 will display in the formula bar.

For some reason in my case Excel 2003 changes TEXT & WRAP formatted cell contents to display on hashes when there are more than 255/256 characters of text. Changing to GENERAL format displays more characters correctly and wraps text, with and without Alt+Enter given line breaks within the cell.

Try selecting all (CTRL-A) in the worksheet then double clicking one of numbered row dividers on the left hand of the screen. This will expand
Rows to fit their contents correctly.

Thank you Skiprr - that fixed my problem! I was importing the data into Excel 2007 from a text file created on a unix system. I imported it all as "text". One column was very long, and would not work wrap. When I changed the format to General, word wrap magically worked just like it should. Thank you ! Thank you ! Thank you!

I'm so glad I'm not the only one who's head is being done in with this!! I just tried UN-merging the cells and auto height adjust does work. Very annoying - so I guess you have to manually change the width of the cell instead of merging it?

You can select a range of cells and use the Center Across Selection option in the Alignment tab of the Format Cells window. (Press Ctrl-1)

WRONG!!

1. Select the suspect cell
2. RIGHT click
3. Select FORMAT CELLS
4. Select the far elft tab: NUMBER
5. Select the GENERAL category
6. Ta-Da

Thank you to SkipRR above - Changing the Cell format to General stopped the ########## and allowed me to view text.
Ahhhhhh I love Google and helpful peeps. :)