Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Feb 2003
    Location
    Kansas, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max number of columns (2000)

    We've hit the column limit of 256 in Excel 2000, does a newer version of Excel support more columns? Thanks for any info. Greg

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Max number of columns (2000)

    Not through 2003.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Max number of columns (2000)

    The maximum number of columns has not changed in Excel 2002 or 2003.

  4. #4
    Lounger
    Join Date
    Feb 2003
    Location
    Kansas, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max number of columns (2000)

    I thought that would be the case but I wanted to check. Thanks for the quick response! Greg

  5. #5
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max number of columns (2000)

    But remember that it is 256 columns per worksheet. If you have a 500-column list, it could be spread across more than one worksheet, and selected data from the list could be assembled on yet other worksheets.
    Clunky, but could work. Might be helpful to duplicate one column on each sheet, as a database-style 'primary key'.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •