<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d8211560\x26blogName\x3dTech+Tips,+Tricks+%26+Trivia\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://mvark.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://mvark.blogspot.com/\x26vt\x3d-5147029996388199615', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Tech Tips, Tricks & Trivia

by 'Anil' Radhakrishna
An architect's notes, experiments, discoveries and annotated bookmarks.

Search from over a hundred HOW TO articles, Tips and Tricks


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

Labels:

Tweet this | Google+ it | Share on FB

« Home | Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »

Posted by Anonymous Anonymous | 3/05/2012 01:21:00 AM

Nice article. Didn't know how to get past column t, not intuitive. Your article solved my issue, thanks!!!!    



»

Post a Comment