Auto to fit Row Height COVERING the text

[Yonina]

My worksheet is being funny.

 

I choose auto to fit row height, and it's showing normal in worksheet edit window, but when jump out the row is too narrow for my text.

 

ps. I did click "wrap text" in whole cells

 

anyone know how to fix it?

 

[michaelk]

This is not uncommon.

 

2 things to try.

 

1.  Sometimes it shows the row height being too small when editing the worksheet, but when you close it, the instance of the worksheet in the drawing is correct.  That doesn't seem to be happening here.

 

2.  When #1 fails, set your row height to some value.  Doesn't matter what.  Hit ok.  Edit the row height again, set it to Auto Fit Row Height.  That usually works.

[Yonina]

22 hours ago, michaelk said:

This is not uncommon.

 

2 things to try.

 

1.  Sometimes it shows the row height being too small when editing the worksheet, but when you close it, the instance of the worksheet in the drawing is correct.  That doesn't seem to be happening here.

 

2.  When #1 fails, set your row height to some value.  Doesn't matter what.  Hit ok.  Edit the row height again, set it to Auto Fit Row Height.  That usually works.

 @michaelk i am not sure if i was right following you #2 step.

so, i record my screen.

I tried to set whatever height and change back to Auto Fit Row Height. But my text still missing.

Edited May 26, 2021 by Yonina
tag !