Docs: Size My Sheet add-on

Google Sheets Show & Tell
1

The Size My Sheet add-on allows you to see how close you are to hitting Google Sheets’ 10 million cell limit.

Install the add-on at https://workspace.google.com/marketplace/app/size_my_sheet/391759237464

After install you can launch the add-on via the Extensions menu to view a gauge in the sidebar.

The Size My Sheet add-on also allows you to insert a function within your sheet to retrieve the number of cells used or the percent used of the cell maximum that Google has set. It’s useful if you’d like to see these numbers in cells on the sheet rather than using the gauge in the sidebar.

To use this feature simply type one of the functions below into an empty cell of a Google Sheet with the Size My Sheet add-on installed.

Retrieve the number of cells used:
=tillerCellsUsed()

Retrieve the percentage used:
=tillerCellsUsed(“Percent”)

3

Dear Heather,
Thank you so much for your developments, it is important and necessary. Rarely, but usually so unexpectedly happens - oops and not enough space.
Thanks to your development it is now possible to conveniently manage the size of tables.
Google changes dimites from time to time, do you keep track of these fluctuations?

BR,
Oleg

4

Welcome @oleg.romanov - we don’t keep track of when Google changes the limit, no.