Windows, Operating System, Security, Networking, Malware, Support, Forum, Help Site Check Our Facebook Page!
Notices
Other PC Software Post questions here about PC Applications, Office Software, Games etc.


Register your FREE account to unlock additional features at WindowsBBS.com
   
 
 
LinkBack Thread Tools
Old 1st March 2003   #1
Inactive
THREAD STARTER
 
Profile:
Join Date: Apr 2002
Location: Raleigh, NC
Posts: 50
Computer Experience:
Intermediate
rtstanley Reputation Level

Excel Max Columns ?


How can I increase the maximum number of columns for an excel file? It appears there is a limit of 256 columns.

I actually have a working excel document that I cannot insert more columns into. I noticed that the columns end at IV. If you count from column A to IV, you see this is 256 columns.

For a quick test, I create a new excel file. Use the scroll button to start scrolling columns to the right: I thought this would simply go forever, but not the case. If you keep scrolling, the document ends at column IV.

How can I change this limit?

rtstanley is offline  

 

Register
to remove this ad.
 
 

Old 1st March 2003   #2
Miz
Alumni
 
Miz's Avatar
 
Profile:
Join Date: May 2002
Location: S.W. Kansas
Posts: 2,345
Computer Experience:
Lots of experiences
Miz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation LevelMiz Reputation Level

My System
Found on Excel Oddities:

The 256-column limitation
Every Excel worksheet is limited to 256 columns. Despite what must amount to thousands of requests over the years, Microsoft refuses to increase the number of columns in a worksheet. Beginners often discover this limitation when they want to set up a spreadsheet that contains data for each day in a year. If they store the data horizontally, they run out of column in mid-September.

So we're stuck with 256. Why such a weird number? Why not 250? Or 365? The number of rows and columns is a by-product of the binary number system. 256 is 2, raised to the eight power (2^8), which is the maximum value that can be stored using eight bits. The number of rows in a worksheet is 65,536, which is 2^16. Older versions of excel contained only 16,384 rows, which is 2^14 power.

The reason for the 256-column limitation is probably due to the fact that Excel is so old, and it contains lots of code that would be "broken" if the number of columns were increased.

Following are a few related facts:

Corel's Quattro Pro spreadsheet supports 18,278 columns and up to 1,000,000 rows.
The spreadsheet in Microsoft's Office Web Components supports 18,278 columns and 262,144 rows

Miz is offline  

Did you find this post helpful? Yes | No

Having problems with your computer? Does it crash or freeze? Is your pc slow? Our technicians can identify any issues and fix your PC quickly and reliably.

 

THIS THREAD HAS EXPIRED.

Are you having the same problem? Please post a new thread, but first you'll have to join us by Registering (FREE).



Discussion Forums
Operating Systems
Windows 8 Windows 8
Windows 7 Windows 7
Windows Vista Windows Vista
Windows XP Windows XP
Windows Server System Windows Server System
Legacy Windows OS Legacy Windows OS
Internet & Networking
Networking (Hardware & Software) Networking
Internet Explorer Internet Explorer
Microsoft Mail Microsoft Mail
Firefox, Thunderbird & SeaMonkey Firefox, Thunderbird
      & SeaMonkey

Web Applications & Cloud Web Applications & Cloud
General Internet
Security
Malware and Virus Removal Malware and Virus
     Removal

Security and Privacy Security and Privacy

Other
Other PC Software Other PC Software
Test Posts Test Posts
Hardware
PC Hardware PC Hardware
Mobile Devices Mobile Devices
Community
Introductions Introductions
General Discussions General Discussions
Site Comments & Suggestions Site Comments
      & Suggestions

News News @ WindowsBBS

Thread Tools


Find us on Facebook   Web Of Trust Rating

All times are GMT. The time now is 21:52.


Recent Discussions
DVD Drive (8)
Dell Studio 540 350watt psu require.. (2)
Unable to see other computers after.. (4)
Trouble seeing wireless printer Bro.. (4)
Keyboard and mouse freeze after a f.. (6)
Microsoft Windows 7 Support to End .. (5)
Wrong CPU Installing (5)
Win 7 32 to win 7 64 bit using Easy.. (1)
Windows 7 OLEAUT32.DLL Error (2)
Microsoft July 2014 Security Bullet.. (0)
Cannot access my website using IE 1.. (11)
External Hard Drive Question. (1)
MS security updates just released (1)
Make an original shortcut (5)
Internet connection lost in sleep m.. (6)
Malwarebytes Anti Exploit or MS EME.. (15)
External Hard Drive Freezes Entire .. (16)
Problem with resetting my outlook e.. (0)
XP fails to boot (4)
Can no longer see part of a logical.. (1)


Donate!
Support Windows BBS!



Powered by vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright 2002 - 2013 WindowsBBS.com. All rights reserved.
FDMA Media LLC
Terms of Use, Legal Information & Privacy Policy
Page generated in 0.05783 seconds with 7 queries