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


The answer is no. You can either have:

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


  • 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. – user0 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
  • I do know how to accept answers when they actually answer the question. I didn't ask if it is possible, but how to do it since I have an example that clearly shows it is possible. As I explained in my last comment, the linked sheet works exactly like I want, however I can't get it to happen in a new sheet. – tbkn23 Jun 24 at 5:14

There is a quite hacky solution that I like to use to set a certain min row height for my spreadsheets. Follow the steps below to reproduce the result.

  1. Add a new column to the sheet
  2. Fill each row in the column with one letter, number, ...
  3. Set the column height to "Fit to data"
  4. By changing the text size of all the cells in the new column you can now adjust the minimum row height of all your rows
  5. (optional) Hide the contents of the column by having the same text and background color (Hiding the whole column will remove the min row height)
  • Neat hack. But it must be possible to do it without, I mean I have a living, breathing, example where it works exactly like I want. I just don't know how to reproduce it :( – tbkn23 Jun 24 at 5:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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