I selected the whole sheet and re-sized the height of all rows at once to a certain height by clicking "Resize rows 1-1000" in the context menu. Then I entered some text in a cell and the text did not fit. I formatted the cell for text wrapping, but it did not fit anyway. I expected the row to automatically grow in height as I enter more text in the cell, but it did not happen. How do I reset to the default mode so rows would grow in height to auto-fit the content?
It works on a freshly created sheet on the same document, but does not work on the problematic sheet. When I copy-paste the whole problematic sheet content onto the newly created, the problem transfers to the newly created sheet.
After I copy-paste "formulas only" from the problematic onto a newly created sheet, auto-fitting height still works on the latter sheet, but my formatting and named ranges do not transfer to the new sheet.