Add-ons
Check out the store for many more
Add-on

Size My Sheet


(6)
698 users

Overview

How close is your spreadsheet is to the 2m cell Google Sheet limit? Use this add-on to show how much you’ve used.
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 2M cell limit in Google Sheets. Use this simple sidebar utility to see just how close you are to hitting that 2 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”)

Details

Version: 9
Updated: June 9, 2017
Language: English (United States)