Forum Discussion

Ken1122's avatar
Ken1122
Copper Contributor
Apr 27, 2020
Solved

Row height - How to close empty space

No cell in the row at issue contains no more than two lines of text, but each cell is three lines high. The third line is empty space. This may be because I had more text in there but deleted it. Bac...
  • mathetes's avatar
    mathetes
    Apr 27, 2020

    Ken1122 

     

    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.

Resources