[FIXED] What is the maximum amount of columns in Google Sheets?

Issue

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:

Answered By - player0

Answer Checked By - Dawn Plyler (PHPFixing Volunteer)