Search code examples
google-sheetssyntaxformulamultiple-columnslimit

What is the maximum amount of columns in Google Sheets?


Could you please say what is the maximum amount of columns in Google Sheets? I heard that maximum is the 256 columns but I was able to add more? Is it only limited by the sum of cells (400000)?


Solution

  • the maximum number of cells per spreadsheet is 2000000 so if you have a one column you could have 2M rows. for column the max is 18278 which is ZZZ and can be tested with COLUMN formula:

    0