The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.

At the time of writing (January 2025), TRIMRANGE doesn't allow you to trim blank rows or columns between existing data. You can only use it to trim data before or after your data.