Google Sheets allows up to 10 million cells in one spreadsheet file, counted across all tabs together. The count is based on the size of each tab's grid, not on how much data you typed, so empty cells in a big blank grid use up the limit as much as filled ones. When you hit it, Sheets shows a message that the action would increase the number of cells above the limit.
What exactly counts as a cell?
Every cell in every tab's grid. A new tab starts at 1,000 rows by 26 columns, which is 26,000 cells. Add 100,000 rows at the bottom and it becomes 26 times 100,000, which is 2,600,000 cells, even if only 6,000 contain data. Deleting the contents does not shrink the grid. Only deleting the rows and columns themselves does.
How can I find which tab is using the most?
Sheets has no built-in cell counter, but you can work it out per tab. In any empty cell of a tab write:
- =ROWS(A:A)*COLUMNS(1:1)
On a tab, A:A refers to the whole column of the grid, so ROWS returns the grid height and COLUMNS(1:1) returns the grid width. Their product is that tab's cell count. If the result looks wrong in your file, scroll to the bottom-right corner of the tab and read the last row number and column letter instead. Delete the helper cell when you are done.
| Tab (hypothetical) | Columns | Rows | Cells |
|---|---|---|---|
| Statement 2023 | 26 | 100,000 | 2,600,000 |
| Statement 2024 | 26 | 100,000 | 2,600,000 |
| Statement 2025 | 26 | 100,000 | 2,600,000 |
| Calc | 40 | 50,000 | 2,000,000 |
| Summary | 26 | 1,000 | 26,000 |
| Total | - | - | 9,826,000 |
That total is under 10 million, but adding a new tab with 10,000 more rows (260,000 cells) pushes it to 10,086,000, over the limit.
How do I free up space without losing data?
- Make a copy of the file first and work on the copy.
- On a tab, click the number of the first empty row, press Ctrl+Shift+Down to select everything below, right-click and choose Delete rows.
- Do the same for columns to the right of your data using Ctrl+Shift+Right and Delete columns.
- Leave a little room. In the example, trimming each statement tab to 6,500 rows frees 26 times 93,500, which is 2,431,000 cells per tab, or 7,293,000 across three.
- Check formulas that use whole columns afterwards; they should keep working because they adjust to the new grid size.
What if my data is genuinely that big?
Then split it by financial year, April to March. A tab for each year sounds tidy but still sits inside the 10 million; separate files do not share a count. Keep this year's working file small, archive old years as read-only copies and bring totals through IMPORTRANGE only when you need them.
Why did the message appear when I only added one column?
Adding a column across a tab with 100,000 rows adds 100,000 cells in one step. The error is not about your one column; it is about the grid height behind it. Trim the empty rows first and the same action will go through.
If you find yourself fighting the limit because of years of bank statement lines, SpendixAI stores imported transactions in your workspace and its Free plan includes statement import, so the sheet only needs the summary you actually build.
Short checklist
- Count each tab's grid, not its data.
- Delete empty rows and columns, do not just clear them.
- Keep a copy before trimming.
- Split old financial years into separate files.
- Re-run the count after you finish.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

