In this tutorial, you will learn how many sheets can you have in Google Sheets.
Google Sheets files tend to grow over time. New sheets can be added for each new month, project, customer, or for a number of other purposes. As the spreadsheet grows larger, you may find yourself wondering if there’s a limit to the number of sheets you can have in a Google Sheets file and, if there is, when you’ll hit that limit and what will happen if you do.
Keep reading to learn all about Google Sheets size limits and what to do if you hit one
Current Google Sheets Limits
The good news is that Google Sheets has no limit to the number of sheets you can have per se. However, there is a cell limit that can come into play if you keep adding sheets. At the time of writing this, Google Sheets has a 5 million cell limit for each spreadsheet. These 5 million cells can be split between any number of sheets within the spreadsheet, so in theory you could have up to 5 million sheets if each had only 1 cell
In addition to the cell limit, no one sheet can have columns past ZZZ, which means there is a limit of 18,278 columns in any given sheet. Google does not mention any limit to the number of rows in a given sheet, provided the 5 million cell limit is not surpassed.
Hitting the Limits
If you do end up hitting up against one of Google Sheets’ limits, there’s no need to worry about data loss. Google Sheets won’t delete your data to make room for the overlimit cells, it will simply pop up an error message warning you that the operation cannot be completed
If this happens, there are a couple different options available to you to:
Delete unneeded rows: Select the rows you want to delete by holding down the CTRL key and clicking on the row numbers of the rows you want to delete, then right click and choose Delete Rows
Extra columns can be deleted in the same way as rows
Check for hidden sheets that are no longer needed and can be deleted: Open the View menu and hover over Hidden Sheets to see the list. Unhide them and delete them as needed
If all else fails, split your spreadsheet into multiple spreadsheets. This can be done by copying sheets to a new spreadsheet using the Copy To option in the sheet right click menu
In this tutorial, I covered how many sheets can you have in Google Sheets. Want more? Check out all the Google Sheets Tutorials.