clhare
02-19-2008, 04:48 AM
I have a spreadsheet with over 12,000 rows that will not autofit correctly. Most rows appear fine, but there are some rows throughout the spreadsheet that only show one line of text when there is actually 2 or more lines.
I've spent hours looking on the Internet yesterday trying to find a solution and am still stumped. There are no merged cells in this table and "wrap text" is selected in all columns. At one point I thought I might have got all the cells to show text by deselecting wrap text and then selecting it again, but while it corrects most rows, it doesn't correct all of them. I also then entered a new row and found it did not show all text.
Is there a way to set all rows correctly by macro so all text appears in each cell? I need help and I don't have a clue how to fix this problem!
I've spent hours looking on the Internet yesterday trying to find a solution and am still stumped. There are no merged cells in this table and "wrap text" is selected in all columns. At one point I thought I might have got all the cells to show text by deselecting wrap text and then selecting it again, but while it corrects most rows, it doesn't correct all of them. I also then entered a new row and found it did not show all text.
Is there a way to set all rows correctly by macro so all text appears in each cell? I need help and I don't have a clue how to fix this problem!