3

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?

  • 2
    There 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
7
+50

Short answer

The limit of columns is 18278. 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

  • 18278 is a weird, non-intuitive limit for a computer system... – Michael Sep 28 '18 at 1:28
  • 1
    @Micheal Not weird. It's the column of "ZZZ:ZZZ" – TheMaster Apr 26 at 16:07
  • 2
    The current limit is 5M though. – TheMaster Apr 26 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.