• Max number of columns (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Max number of columns (2000)

    Author
    Topic
    WSgwkeller
    AskWoody Lounger
    December 21, 2004 at 8:58 pm #413779

    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

    Reply | Quote
    Viewing 5 reply threads
    Author
    Replies
    • WSJohnBF
      AskWoody Lounger
      December 21, 2004 at 9:02 pm #915192

      Not through 2003.

      Reply | Quote
    • WSJohnBF
      AskWoody Lounger
      December 21, 2004 at 9:02 pm #915193

      Not through 2003.

      Reply | Quote
    • WSTonyE
      AskWoody Lounger
      December 21, 2004 at 9:02 pm #915194

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

      Reply | Quote
    • WSTonyE
      AskWoody Lounger
      December 21, 2004 at 9:02 pm #915195

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

      Reply | Quote
    • WSgwkeller
      AskWoody Lounger
      December 21, 2004 at 9:05 pm #915196

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

      Reply | Quote
      • WSitshimagain
        AskWoody Lounger
        December 23, 2004 at 2:25 pm #915858

        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’.

        Reply | Quote
      • WSitshimagain
        AskWoody Lounger
        December 23, 2004 at 2:25 pm #915859

        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’.

        Reply | Quote
    • WSgwkeller
      AskWoody Lounger
      December 21, 2004 at 9:05 pm #915197

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

      Reply | Quote
    Viewing 5 reply threads
    Reply To: Max number of columns (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.