Programmers learn & share
0 votes

Problem :

I am getting below google sheet error
this action would increase the number of cells in the workbook above the limit of 2000000 cells.
by (6.9k points)   | 24 views

1 Answer

0 votes

Solution :

According to the Files you can store in Google Drive Google Sheets has the 5 million cells limit by spreadsheet. 

I myself tested the above scenario by trying to insert a 1,999,999 columns to the spreadsheet that contains a single sheet with a single cell (A1) by using the below script:

function testCol() {
  SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999)
by (36.1k points)  
2,218 questions
2,683 answers
241 users