SOLVED

Row height - How to close empty space

%3CLINGO-SUB%20id%3D%22lingo-sub-1340777%22%20slang%3D%22en-US%22%3ERow%20height%20-%20How%20to%20close%20empty%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1340777%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20cell%20in%20the%20row%20at%20issue%20contains%20no%20more%20than%20two%20lines%20of%20text%2C%20but%20each%20cell%20is%20three%20lines%20high.%20The%20third%20line%20is%20empty%20space.%20This%20may%20be%20because%20I%20had%20more%20text%20in%20there%20but%20deleted%20it.%20Backspace%20does%20not%20help.%20How%20do%20I%20close%20the%20empty%20space%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1340777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341036%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20height%20-%20How%20to%20close%20empty%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341036%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637558%22%20target%3D%22_blank%22%3E%40Ken1122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20step%20I'd%20suggest%20would%20be%20to%20go%20to%20%3CSTRONG%3EFormat....Row%3C%2FSTRONG%3E%20and%20see%20if%20a%20default%20Row%20Height%20has%20been%20set%20that%20keeps%20the%20height%20as%20you%20see%20it.%20Change%20it%20to%20%22%3CSTRONG%3EAutoFit%3C%2FSTRONG%3E%22....if%20that%20doesn't%20do%20it%2C%20there%20may%20be%20non-showing%20characters%20in%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20could%20upload%20a%20sample%20of%20the%20file%20showing%20the%20problem%20if%20you%20need%20further%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341069%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20height%20-%20How%20to%20close%20empty%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAuto%20fit%20didn't%20solve%20the%20problem.%3C%2FP%3E%3CP%3EI'd%20rather%20not%20upload%20the%20file%20as%20it%20is%20personal.%20There%20are%20no%20blank%20spaces%20in%20any%20of%20the%20cells%20causing%20this%20as%20far%20as%20I%20can%20tell.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341214%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20height%20-%20How%20to%20close%20empty%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F637558%22%20target%3D%22_blank%22%3E%40Ken1122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20isolate%20the%20cell(s)%20that%20are%20causing%20the%20problem%3F%20%5BSave%20a%20backup%20copy%20before%20doing%20anything%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDelete%20columns%20selectively%20to%20see%20which%2C%20when%20removed%2C%20allows%20the%20row%20to%20collapse.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20thought%3A%20I'm%20going%20to%20assume%20that%20these%20cells%20are%20formatted%20to%20allows%20%22Word%20Wrap%22%20--%20turn%20that%20setting%20off%20%2C%20which%20should%20force%20it%20all%20to%20one%20line%2C%20just%20very%20long%2C%20and%20then%20edit%20to%20just%20the%20essential%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20separate%20note...you%20said%20it's%20personal%20info...so%20I%20find%20myself%20wondering%20whether%20it's%20the%20kind%20of%20personal%20file%20where%20I've%20encountered%20exactly%20the%20same%20issue%3A%20credit%20card%20statements%20from%20some%20credit%20card%20issuers%20(notably%20American%20Express)%2C%20but%20also%20Chase.%20In%20the%20latter%20case%2C%20I%20discovered%20that%20their%20CSV%20download%20was%20actually%20far%20more%20appropriately%20designed%20than%20was%20their%20XLS%20format.%20For%20some%20reason%2C%20the%20Excel%20file%20was%20made%20to%20look%20pretty%20(colors%20and%20multiple%20row%20entries%20in%20some%20cells).%20AmEx%20had%20all%20addresses%20of%20vendors%20from%20whom%20purchases%20had%20been%20made%20displayed%20in%20single%20cells%20with%20multiple%20rows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341245%22%20slang%3D%22en-US%22%3ERe%3A%20Row%20height%20-%20How%20to%20close%20empty%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341245%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3EI%20found%20the%20offending%20cell%20as%20you%20suggested%20and%20cut%20all%20the%20text%20out%20of%20it%2C%20that%20didn't%20solve%20the%20problem%20but%20I%20pasted%20the%20text%20into%20a%20Word%20document%20and%20saved%20the%20Excel%20document.%20That%20made%20the%20offending%20cell%20collapse%20into%20one%20line.%20Went%20back%20to%20the%20Word%20document%2C%20got%20the%20text%2C%20pasted%2C%20wrapped%2C%20and%20voila%2C%20problem%20solved.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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. Backspace does not help. How do I close the empty space? Thanks

4 Replies
Highlighted

@Ken1122 

 

First step I'd suggest would be to go to Format....Row and see if a default Row Height has been set that keeps the height as you see it. Change it to "AutoFit"....if that doesn't do it, there may be non-showing characters in there.

 

You could upload a sample of the file showing the problem if you need further help.

Highlighted

@mathetes 

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

Highlighted
Best Response confirmed by Ken1122 (Occasional Contributor)
Solution

@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.

Highlighted

@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.