I read that google spreadsheets have a column limit of something like 20000. However my spreadsheet does not have any column beyond AC.
How can I add columns to my spreadsheet?? (in Excel this is automatic)
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityYou can insert more columns in the Insert
menu.
If you need to insert more than one column, you can highlight a number of columns and it'll prompt to insert that amount:
If you need a huge amount of columns inserted, open a text editor, create a large quantity of TAB
characters, and copy into Google Sheet.
Google Sheet will interpret each tab as a column so it'll quickly create new columns based on the number of tab characters you have pasted.
You can go up to column ZZZ, which is exactly 18,278 columns following @Nelson 's process
[EDIT:] You can use the script below to add a specific number of columns
function userAddColumns() {
var spreadsheet = SpreadsheetApp.getActive();
var ui = SpreadsheetApp.getUi();
var result = ui.prompt("How many columns do you want to add?");
spreadsheet.getActiveSheet().insertColumnsAfter(spreadsheet.getActiveRange().getLastColumn(), result.getResponseText());
};