Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » Any way to increase maximum columns?

Any way to increase maximum columns?

Previous | Next
Latest post Sun, Jun 8 2008 3:54 AM by hrlngrv. 7 replies.

  • Mon, May 19 2008 8:52 PM

    • Taxon
    • Top 500 Contributor
    • Joined on Tue, May 20 2008
    • Posts 3
    • Points 63

    Any way to increase maximum columns?

    Reply |Contact

    I use Excel 2000 under Windows XP.  The maximum number of columns seems to be 230 (A-IV).  Is there any way to increase the number of columns?  I am using the transpose option when pasting ~700 rows, and it is a real pain to have to do it in 4 pieces, and of course, greatly increases the likelihood of making a mistake.
    Filed under:
    • Post Points: 37

  • Tue, May 20 2008 1:36 AM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 542
    • Points 9,275
    • MVP

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

    Taxon

    I'm afraid not, you'll need to be up to Excel 2007 before the rows increase from 256. (16k in 2007)

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    • Post Points: 21

  • Tue, May 20 2008 2:17 AM In reply to

    • Taxon
    • Top 500 Contributor
    • Joined on Tue, May 20 2008
    • Posts 3
    • Points 63

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

    Nick-

    Thanks for the prompt reply.  Guess my upgrading to a newer version of Excel is long overdue anyway.  Would I also have to upgrade from XP to Vista in order to use Excel 2007?

    Roger Rohrbeck

     
    • Post Points: 21

  • Tue, May 20 2008 2:30 AM In reply to

    • kaak
    • Top 25 Contributor
    • Joined on Fri, Jan 18 2008
    • Edam, Netherlands
    • Posts 71
    • Points 1,246

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

     Roger,

    Office 2007 will perform fine on Windows XP.

    Jelle-Jeroen
    • Post Points: 37

  • Tue, May 20 2008 3:05 AM In reply to

    • Taxon
    • Top 500 Contributor
    • Joined on Tue, May 20 2008
    • Posts 3
    • Points 63

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

    Thanks, kaak.  You guys are terrific, and that is what I hoped to hear.Big Smile
    • Post Points: 5

  • Tue, May 20 2008 4:08 AM In reply to

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

    Roger,

    Office 2007 will perform fine on Windows XP.

    Jelle-Jeroen

    Debatable that it works fine on anything!

    Regards

    Bob

    • Post Points: 21

  • Wed, May 21 2008 4:49 AM In reply to

    • sam
    • Top 75 Contributor
    • Joined on Mon, Jan 14 2008
    • Posts 10
    • Points 178

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Answer

     If you want to have more rows and columns in a lower version (<2007) then a workaround is to insert an OWC Spreadsheet in a sheet.

    This will give you 2^18 = 262144 rows and 18278 (zzz) columns

    Sam
    • Post Points: 5

  • Sun, Jun 8 2008 3:54 AM In reply to

    • hrlngrv
    • Top 25 Contributor
    • Joined on Thu, Jan 17 2008
    • somewhere in the western US
    • Posts 68
    • Points 1,092

    Re: Any way to increase maximum columns?

    Reply |Contact |Mark as Not Answer

    Bob Phillips:
    Roger,

    Office 2007 will perform fine on Windows XP.

    Jelle-Jeroen

    Debatable that it works fine on anything!

    When did you become a curmudgeon?

     
    • Post Points: 5
Page 1 of 1 (8 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.