I have an Excel 97 (SR-1) spreadsheet and I cannot get the text to wrap in the cells. I have to manually resize the row height instead. Everything looks correct on the Alignment tab of the Format Cells dialog box.
I think the problem is that early on when I was building the spreadsheet I did a Ctrl-A to select all, and I resized all the rows/columns to suit what I was doing. Since overriding the default row height, wrap-text doesn't seem to work anywhere in the spreadsheet, even on otherwise unformatted cells way outside of the range I'm working in. But if I create a new sheet wrap-text works fine.
This is driving me batty! I have too much work invested to scrap the sheet and start over, but I don't want to resize hundreds of rows. Help! Please?