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)?
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: