Google Spreadsheet Size Limits

I found that the column T is the last you will find by default in a sheet in Google Spreadsheets. After a little digging, I found that it can have up to 256 columns, or up to 200,000 cells, or up to 100 sheets -- whichever limit is reached first. There's no limit on number of rows.

So how do you go beyond column T? One way is to right click on the column header & then select "Insert 1 right" from the context menu.



Here are some more size limits of Google Spreadsheets -

• Each spreadsheet can have up to 20,000 cells with formulas. Of this total, the following limits apply:
  • Up to 1,000 GoogleFinance formulas
  • Up to 1,000 GoogleLookup formulas
  • Up to 50 Import formulas
• You have a limit of 1000 spreadsheets. The spreadsheets that are shared with you do not count against 1000 limit.
• The limit on spreadsheets open at one time is 11.
• You can import spreadsheets up to approximately 1 Mb in xls, xlsx, csv, ods, txt, tsv, or tsb format.

Also see:
HOW TO get date N working days ahead in Excel & Google Spreadsheet

Tweet