Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    London, --AUSTRALIA--, England
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    increasing number of columns (2000)

    In Excel 2000, is there any way of increasing the maximum number of columns, I don't need too many rows, so could trade rows for columns. Due to the nature of teh data I don't want to rotate the data.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: increasing number of columns (2000)

    256 columns, 65536 rows. no more, no less.

    An option is using multiple sheets to "span" the data rows, but it is up to you to keep track of inserting/deleting rows to keep the data "synced" and inserting columns will not be possible.

    Another program: Access has less of these "physical size restrictions

    I would recommend Transposing the data, there might be ways around the "nature of the data". I tend to think of rows as "records" and columns as fields in a "flat-database" and I can't think of >256 "categories".

    Steve

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: increasing number of columns (2000)

    As Steve says, 256 x 65,536. You cannot exceed Excel specifications. See Help | Index | Specification | Microsoft Excel specifications, then click on Worksheet & Workbook specifications. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: increasing number of columns (2000)

    <hr> can't think of >256 "categories".<hr>

    365 days in one year is the one that gives me problems. It makes it difficult to set up a one year rolling calendar.
    Legare Coleman

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: increasing number of columns (2000)

    So rotate the text and you monitor by 90 degrees <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: increasing number of columns (2000)

    I don't think of days of the year as a category since they are essentially "identical"-type columns. I try to avoid having these "duplicate" columns in a database (Item1, Item2, Item3, -types of categories).

    I would design to use rows and make the data more relational- perhaps with multiple tables. You can put many full years in 65536 rows.

    But that is me, and many people comment that I am "odd" and don't think like "normal people" <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Steve

Posting Permissions

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