Excel Spreadsheets Home › Forum › Chat Forum › Excel Spreadsheets Overview Bike Forum Chat Forum For Sale Wanted Forum Help Classified Rules Viewing 18 posts - 1 through 18 (of 18 total) Excel Spreadsheets jon1973Member Why do Excel Spreadsheets only have 256 columns (ie. up to column IV). Why not go up to 676 (up to ZZ)? Posted 9 years ago nickcSubscriber I don’t know. Why do excel spreadsheets only have 256 columns? Posted 9 years ago jon1973Member Good question Nickc. I wish I’d thought of that. Posted 9 years ago wildrnesMember working days in a year and a couple of extra columns for good measure Posted 9 years ago StonerSubscriber 2^4, binary limitation. Posted 9 years ago conkermanMember Probably a hangover from when computers were crappy ans slow. Excel is a bit rubbish anyway 🙂 Posted 9 years ago StonerSubscriber Excel is a bit rubbish anyway wash your mouth out heathen! . . . *Alt+Tab, strokes excel model, you shouldnt have to hear such things my precious, Alt+Tab* Posted 9 years ago wildrnesMember that was a silly guess by the way Posted 9 years ago jon1973Member 2^4, binary limitation. I spotted that, but why should that limit the number of columns, unless it just historical. Posted 9 years ago jon1973Member that was a silly guess by the way That’s all I was expecting really 🙂 Posted 9 years ago StonerSubscriber doh, sorry mean to say 2^8. the reason it has continued so long is because the cell adressing would have been heavily embedded in the software from eons ago and would have required amassive rewrite to unwind. WHich they have now done for Excel 2007. Posted 9 years ago joemarshallMember I believe Excel is built on a pretty ancient code base, when for some reason they decided to make a cell reference fit into a 24 bit binary number. It also limits maximum rows to 65536. Excel 2007 has upped the numbers to 65536 columns and 1048576 rows though. Powers of 2 again. Joe Posted 9 years ago uplinkMember It all goes back all the way to the original VisiCalc app that started it all Posted 9 years ago IHNMember Posted 9 years ago coffeekingMember Posted 9 years ago plop_pantsMember slight threadjack. Is there much call for Excel vba programmers? Been enjoying myself for the last year and a half doing this but my contract is up soon so looking for work. Posted 9 years ago StonerSubscriber a contact of my brothers* was looking for some risk analyst Excel/VBA programmers in Cheltenham. If location suits I can pass on details. . . . . . . .* Geek family 🙂 Posted 9 years ago plop_pantsMember thanks Stoner, I’m in east Kent so Cheltenham is a bit out of my reach (although I can certainly see the benefits of moving that way with all that mountain biking around and abouts!) Posted 9 years ago Viewing 18 posts - 1 through 18 (of 18 total) The topic ‘Excel Spreadsheets’ is closed to new replies.