Forum Discussion
Row height issue
- 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.
Change the column width and row height
You can change the language by pressing the globe or national language at the bottom left of the page.
If the problem has not been solved with this possible setting, it is possible that the file contains VBA code.
But in order to be able to tell you more precisely, you would need the file (without sensitive data).
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
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_EekelenSep 22, 2020Platinum Contributor
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.
- MBotha2020Sep 22, 2020Copper Contributor
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! 🙂
- Riny_van_EekelenSep 22, 2020Platinum Contributor
MBotha2020 You are most welcome!