pugpink wrote:
I can fill every single cell in a spreadsheet with 1. Very simple, but
the result would be huge.

Look for stray data near the bottom or right edge of your spreadsheet.
Or copy your real data into a new spreadsheet, leaving anything you may
not be able to see behind, and it will probably shrink.