When you reach the 2m cell limit Google will alert you when you try to add more rows or columns: “There was a problem. This action would increase the number of cells in the workbook above the limit of 2000000 cells.
Now what? Well, you have a number of options to trim your spreadsheet.
- Delete rows or columns. If you delete 100 empty columns in a 1,000 row spreadsheet, that’s 100,000 cells you’ll be freeing up.
- Remove sheets. Check in to see if you’ve added any additional sheets (tabs) that you’re not using and delete them to save some space.
- Move some sheets into another spreadsheet. You can right click the tab at the bottom for any sheet, and then choose “Copy to” to make a copy into another sheet. Once that’s complete, you can delete the original sheet from your maxed out spreadsheet.
- Archive previous years’ data in a copy of your Google Sheet. If you’re using Tiller and your Transactions and Balance History sheets have many years of bank data, you could create individual sheets for each year. Open the File menu then make a Copy of your spreadsheet. (The copy will be saved in your Google Drive.) In the copy, which is no longer linked to Tiller, you can delete this year’s data from either or both of your Transactions sheet and Balance History sheet. In your original spreadsheet, which will continue to be updated by Tiller, you can delete all prior year data.
- Separate your data from your reports. If you want to use cell-intensive formulas like ARRAYFORMULA or QUERY, set these up in a separate Google Sheet and use IMPORTRANGE to share specific columns of bank data into these new Google Sheets.
- Create multiple spreadsheets instead of one. You can create multiple Tiller finance spreadsheets, so a great way to keep your sheets in check is to spread your data out among several sheets. Perhaps you have one spreadsheet for your investment data, another for your family finances, and a third for your business spending.
How do I know if I'm close to the limit?
Use our Size My Sheet Add-on to check your sheet size so you know when you're getting close to the limit.