1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel Max Columns ?

Discussion in 'Other PC Software' started by rtstanley, 2003/03/01.

Thread Status:
Not open for further replies.
  1. 2003/03/01
    rtstanley

    rtstanley Inactive Thread Starter

    Joined:
    2002/04/20
    Messages:
    50
    Likes Received:
    0
    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?
     
  2. 2003/03/01
    Miz

    Miz Inactive Alumni

    Joined:
    2002/05/02
    Messages:
    2,345
    Likes Received:
    35
    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,
    #2

  3. to hide this advert.

Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.