Try using this Google Sheets Add-On to crop all the empty cells off your spreadsheets
https://gsuite.google.com/marketplace/app/crop_sheet/42816466715
Although empty cells contain no data, they still have to be read, and this can take a few seconds if you have a few large mostly empty tables. So just use โCrop to Dataโ to reduce the table size
@1minManager Thank you very much for this Tip. This is very useful when creating new App.
While using the App and deleting entries via the App, in your Google Sheet you will have empty rows between.
This Add On can crop all empty cells AND it also deletes empty rows between.
https://gsuite.google.com/marketplace/app/remove_blank_rows/1031742376501
It has also a nice HowTo Video.