Auto Fit w double click for heigh & width of rows/columns Excel not working

%3CLINGO-SUB%20id%3D%22lingo-sub-3241000%22%20slang%3D%22en-US%22%3EAuto%20Fit%20w%20double%20click%20for%20heigh%20%26amp%3B%20width%20of%20rows%2Fcolumns%20Excel%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3241000%22%20slang%3D%22en-US%22%3E%3CP%3EHope%20someone%20has%20a%20quick%20solution.%3C%2FP%3E%3CP%3EThe%20column%20or%20row%20doesn't%20auto%20fit%20when%20I%20double%20click%20on%20the%20boundary%20of%20either%20one.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EAlways%20used%20this%20method%20to%20adjust%20and%20fit%20even%20with%20merged%20and%20wrapped%20cells.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20loaded%20Office%2016%20and%20using%20the%20new%20version.%3C%2FP%3E%3CP%3EIs%20there%20settings%20I%20need%20to%20configure%3F%26nbsp%3B%20Worksheet%2C%20tabs%2C%20cells%2C%20doc%20not%20protected.%3C%2FP%3E%3CP%3EAfter%20I%20manually%20drag%20to%20height%20I%20need%2C%20if%20I%20double%20click%2C%20it%20adjusts%20back%20and%20hence%20my%20values%2Ftext%20are%20cut%20out.%26nbsp%3B%20Behavior%20not%20working%20only%20on%20merged%20rows.%26nbsp%3B%20If%20content%20in%20cell%20is%20merged%20and%20wrapped%2C%20the%202Xclick%20on%20column%20will%20widen%20to%20allow%20no%20wrapping%20(which%20is%20not%20the%20result%20I%20need).%26nbsp%3B%20Need%20row%20to%20adjust%20in%20height%20so%20I%20can%20keep%20column%20small.%26nbsp%3B%20Thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3241000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFeatures%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hope someone has a quick solution.

The column or row doesn't auto fit when I double click on the boundary of either one.  

Always used this method to adjust and fit even with merged and wrapped cells.  

I just loaded Office 16 and using the new version.

Is there settings I need to configure?  Worksheet, tabs, cells, doc not protected.

After I manually drag to height I need, if I double click, it adjusts back and hence my values/text are cut out.  Behavior not working only on merged rows.  If content in cell is merged and wrapped, the 2Xclick on column will widen to allow no wrapping (which is not the result I need).  Need row to adjust in height so I can keep column small.  Thoughts?

0 Replies