Forum Discussion

MBotha2020's avatar
MBotha2020
Copper Contributor
Sep 22, 2020
Solved

Row height issue

I don't recall changing any settings to cause this issue:   After editing a cell in Excel and pressing Enter to move on to the next cell, the row height of that cell suddenly expands and becomes so...
excel
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 22, 2020

    MBotha2020 You have a hidden column B, 8 pixels wide with rather long texts in the cells. Delete its content (if not needed) and rows can be set to auto-height again.

MBotha2020's avatar
MBotha2020
Copper Contributor
Sep 22, 2020

NikolinoDE 

 

Thank you for trying to assist. I have tried the option of autofitting the row heights, and it does not change anything, which I don't understand.

 

There should not be any VBA code in the file, I created it and it is a simple file.

 

I'm not sure if there is sensitive information that I must delete except data is contained in the cells themselves. I am attaching the file for you to look at. It is the last sheet in the document that I have been trying to work on.

 

Thank you again.

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 22, 2020

MBotha2020 You have a hidden column B, 8 pixels wide with rather long texts in the cells. Delete its content (if not needed) and rows can be set to auto-height again.

  • MBotha2020's avatar
    MBotha2020
    Copper Contributor
    Sep 22, 2020

    Riny_van_Eekelen 

     

    Thank you very much, this has indeed solved my problem. I did not really want to delete these columns but I was desperate enough to do it to solve the problem. What puzzles me is that it seems to me that these texts were not nearly long enough to justify the sizes of the rows. But I have to be wrong in this, because as we see deleting the columns solved the problem. 

     

    Thank you for taking the time to help me with such a basic issue that really had me feeling despondent.

     

    Much appreciated! 🙂 

Resources