Forum Discussion
auto row height when using sort functio
If you can’t see all the data in a cell, changing the row height or column width can help:
Change column width or row height
Hope I could help you with these information / links.
NikolinoDE
yes its already very wide. i just cant figure how to get the cell height to auto adjust to suit the relevant text
Start -> Format -> Adjust column width automatically or Adjust row height automatically
It is probably not what you are looking for.
But what exactly you are looking for is not understandable to me from the text.
Unfortunately, the translation doesn't help me either.
Therefore, I recommend that you insert a file (without sensitive data)
and explain exactly what you want to do with an example.
Thank you for your understanding and patience
NikolinoDE
a test spread sheet is attached, so text is entered into text entry tab, its then processed with if functions to bring only rows with the word open in the last cell, then i use the sort function to collate all cells with text in at the top and this is where i cant get the row height to auto adjust.
Thanks
