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 -
HOW TO get date N working days ahead in Excel & Google Spreadsheet
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.
HOW TO get date N working days ahead in Excel & Google Spreadsheet
Labels: Tools/Utilities
This entry was posted
on
Tuesday, October 06, 2009.
You can skip to the end and leave a
response.
Post a Comment