I have 137 columns (EG). I cannot scroll to the right of column EG. I have many rows, but only 37 used rows.
Reading what I can find via searches, it seems I should not be facing this restriction. Does anyone have a suggested workaround?
-
2There is a limit of 2,000,000 cells in the spreadsheet, used or not. For example, 137 columns with 15,000 rows would already exceed it. Reduce the number of rows and try again. – user135384 May 29 '17 at 15:35
-
@user135384 Is the limit really 2,000,000 or is it actually 2,097,152? – Michael Sep 28 '18 at 1:24
-
@Michael Google says 2 million, and the other limits on that page are in multiples of 10. Those are intentionally imposed quotas, not technical limitations. – user135384 Sep 28 '18 at 2:48
Add a comment
|
Short answer
The limit of columns is 18278, the last possible column is column ZZZ:ZZZ. It's very likely that the OP issue isn't directly related to the number of columns but something else that if affecting the web browser or computer like an extension, the lack of enough resources to handle the spreadsheet, etc.
Explanation
According to Files you can store in Google Drive Google Sheets has 5 million cells limit by spreadsheet. One could think that the limit consider all the spreadsheet cells, no matter of how many sheets / rows / columns are being used.
Validation
I tested the above by trying to insert a 1,999,999 columns to a spreadsheet that contains a single sheet with a single cell (A1) by using the following script:
function test() {
SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999)
}
When I run it, the following error message was shown:
This action would increase the number of columns in the sheet above the limit of 18278 columns. (line 2, file "Code")
Related question: Google Spreadsheet column limit
-
-
1
-
2
I just deleted the extra rows and columns in a few worksheets and it worked! It frees up the cells.
