Forum Discussion
Row height - How to close empty space
Can you isolate the cell(s) that are causing the problem? [Save a backup copy before doing anything]
Delete columns selectively to see which, when removed, allows the row to collapse.
Another thought: I'm going to assume that these cells are formatted to allows "Word Wrap" -- turn that setting off , which should force it all to one line, just very long, and then edit to just the essential info.
On a separate note...you said it's personal info...so I find myself wondering whether it's the kind of personal file where I've encountered exactly the same issue: credit card statements from some credit card issuers (notably American Express), but also Chase. In the latter case, I discovered that their CSV download was actually far more appropriately designed than was their XLS format. For some reason, the Excel file was made to look pretty (colors and multiple row entries in some cells). AmEx had all addresses of vendors from whom purchases had been made displayed in single cells with multiple rows.
Auto fit didn't solve the problem.
I'd rather not upload the file as it is personal. There are no blank spaces in any of the cells causing this as far as I can tell.
Thanks
Can you isolate the cell(s) that are causing the problem? [Save a backup copy before doing anything]
Delete columns selectively to see which, when removed, allows the row to collapse.
Another thought: I'm going to assume that these cells are formatted to allows "Word Wrap" -- turn that setting off , which should force it all to one line, just very long, and then edit to just the essential info.
On a separate note...you said it's personal info...so I find myself wondering whether it's the kind of personal file where I've encountered exactly the same issue: credit card statements from some credit card issuers (notably American Express), but also Chase. In the latter case, I discovered that their CSV download was actually far more appropriately designed than was their XLS format. For some reason, the Excel file was made to look pretty (colors and multiple row entries in some cells). AmEx had all addresses of vendors from whom purchases had been made displayed in single cells with multiple rows.
mathetesI found the offending cell as you suggested and cut all the text out of it, that didn't solve the problem but I pasted the text into a Word document and saved the Excel document. That made the offending cell collapse into one line. Went back to the Word document, got the text, pasted, wrapped, and voila, problem solved. Thanks.