AutoFit row height with wrap text not working on 2016 Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2010036%22%20slang%3D%22en-US%22%3EAutoFit%20row%20height%20with%20wrap%20text%20not%20working%20on%202016%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010036%22%20slang%3D%22en-US%22%3EFor%20some%20reason%20my%20autofit%20is%20not%20working%20on%20my%202016%20Excel.%20I%20have%20typed%20multiple%20lines%20in%20a%20merged%20cell%20and%20have%20clicked%20wrap%20text.%20After%20finishing%2C%20the%20row%20height%20does%20not%20adjust%20and%20I%20can%20only%20see%20the%20beginning%20of%20the%20first%20line.%20Even%20after%20I%20go%20to%20format%2C%20and%20click%20on%20autofit%20row%20height%2C%20it's%20still%20stays%20as%20one%20line.%20I%20can%20drag%20it%20down%20to%20see%20all%20three%20lines%2C%20but%20when%20I%20double%20click%20the%20line%20to%20have%20it%20automatically%20adjust%2C%20it%20still%20shrinks%20back%20down%20to%20one%20line.%20Does%20anyone%20know%20a%20workaround%20for%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2010036%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010331%22%20slang%3D%22en-US%22%3ERe%3A%20AutoFit%20row%20height%20with%20wrap%20text%20not%20working%20on%202016%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909630%22%20target%3D%22_blank%22%3E%40James20202020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMerged%20cells%20is%20the%20source%20of%20many%20issues.%3C%2FP%3E%0A%3CP%3EIf%20you%20use%20Center%20Across%20Selection%20instead%20with%20Wrap%20text%20row%20will%20be%20automatically%20expanded%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20412px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242296i6F3A810BE387D0DE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
For some reason my autofit is not working on my 2016 Excel. I have typed multiple lines in a merged cell and have clicked wrap text. After finishing, the row height does not adjust and I can only see the beginning of the first line. Even after I go to format, and click on autofit row height, it's still stays as one line. I can drag it down to see all three lines, but when I double click the line to have it automatically adjust, it still shrinks back down to one line. Does anyone know a workaround for this?
2 Replies

@James20202020 

Merged cells is the source of many issues.

If you use Center Across Selection instead with Wrap text row will be automatically expanded

image.png

@Sergei Baklan - so strange that not having it work for all alignments.  That the default is set for center makes no sense either. The unusual thing is that it works for my work computer but not the new laptop.  Is there another setting?