0

In the past, I used to open a new spreadsheet, resize all lines (the default feels way too cramped for me), and then enter data. If at some point I entered data longer than the row height, it would stretch the entire row automatically.

So basically, it would keep the "Fit to data" row height setting, while letting me manually define the "default" height (height when no text is present).

Not sure what changed, but now whenever I resize lines manually, it disables the "Fit to data" checkbox, so whenever I enter data longer than my line height, it won't automatically adjust. If I return the "fit to data" setting, it will shrink all empty or single-line lines to the default, too-small height.

Did something change? Am I missing something? Is there a way to set a minimum line height but still keep the "fit to data" mode?

Here's an example of a spreadsheet I have where everything works as I want it - All rows are at least 30 pixels high, but when adding data it expands if two lines or more.

spreadsheet sample

0

The answer is no. You can either have:

  • fixed rows (custom hight / 'fit to data' hight)
  • floating rows (default hight)

screenshot

  • Then how do you explain the situation in the spreadsheet I linked to? I have all lines 30 pixel high, and when I add more data they stretch as needed. – tbkn23 Dec 30 '18 at 15:07
  • @tbkn23 well exactly. in your linked sheet the 2nd row is ~37px and 3rd row is ~54px and not 30 obviously. the moment you entered your data in rows you lost your 30px and internally it got rewritten to "fit to data mode" even if its shown to you that its 30px as you set it up. – MARK MY ANSWER Dec 30 '18 at 16:03
  • This is what I'm looking for. So that when I enter more data it gets rewritten to "fit to data". Can't get it to happen in a new sheet. But also, when I delete the extra data from say line 2 or 3, it goes back down to 30, and not the default 21. – tbkn23 Dec 31 '18 at 7:21

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.