When I create a filter in Google sheets, I want the range to automatically expand as I add/populate new rows. Sometimes, this works fine:

Gif of range auto-expanding

When I have a column using “Checkbox” data validation (required for my project), the range never auto-expands:

Gif of range not auto-expanding

My goal is to auto-expand the range whenever a new row is populated (also acceptable: auto-expand the range when a new row is first added) even when checkbox data validation is present.

I suspect I can accomplish this through a simple script, but I want to better understand the expected behavior. What is the logic for when the filter range auto-expands and when it doesn’t? I’ve searched the web but haven’t found a clear answer.

Your Answer

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

Browse other questions tagged or ask your own question.