I've got a Google Sheet I'm creating for settlement purposes and I have 8 variables that only get used sometimes. Each variable has its own line devoted to it. For example, this load has a scale charge that is visible in the image I posted (but the other 7 rows are blank in the Row 14-21 range).

The data is getting pulled in from a master sheet but I'd like the empty rows to be of MINIMAL HEIGHT by default and then expand ONLY IF any data is actually present to be displayed for a particular variable.

Why do I need to do this, you ask? For space saving purposes for printing since most settlements will have multiple loads. I'd prefer not to leave 8 lines of BLANK SPACE fully expanded all the time for each load for paper-saving & aesthetic purposes. Any ideas?

enter image description here

1 Answer 1

  • select rows 14-21
  • right click on them
  • select resize rows
  • set to 2

if any of the rows get filled with something then the row will auto expand

note that this solution works only on old sheet versions (created before 1. September 2018)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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