Have a lot of data in your Google Sheet? Use a lot of Pivot Tables and QUERY functions to slice and dice it? You've probably hit the 5M cell limit in Google Sheets. Use this simple sidebar utility to see just how close you are to hitting that 5 million cell limit in real time.
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”)
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
