Page 1 of 2 12 LastLast
Results 1 to 15 of 25

Thread: Columns (2003)

  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Columns (2003)

    The worksheet will not allow me anymore columns, it went up to IV and stops.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Columns (2003)

    All versions of Excel up to and including Excel 2003 have had 256 columns per worksheet, labeled A to IV. So column IV is really the last available column. If you need more, you will have to use multiple worksheets.

    See Microsoft Office Assistance: Excel specifications and limits, and expand 'Worksheet and workbook specifications'.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    I'm not too sure why you need more that 256 columns Tony. (It depends obviously on what you are storing/doing in excel, but I would suggest either to consider reviewing the design of your spreadsheet, or considering storing info in Access where you have less limitations regarding storage of data).
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Columns (2003)

    Access tables and queries also have a limit of 256 columns (fields).

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>..... <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

    I didn't realize that!!! <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

    So <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>
    Regards,
    Rudi

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

    Re: Columns (2003)

    I've always wished that there were at least 366 columns so that I could get a years worth of daily data on one sheet. A calendar just does not work right going down the rows.
    Legare Coleman

  7. #7
    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: Columns (2003)

    I always put the dates down the rows. With autofiltering and pivot tables, I can view whatever I need this way, and create charts much easier. All the data in in 1 sheet (no need to grabbing multiple workbooks to compare between years). With 65536 columns you can put a good 179 years worth of data in a single sheet...

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    <hr>"With 65536 columns you can put a good 179 years worth of data in a single sheet..."<hr>
    Not if you are dealing with hourly readings.... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    As for Access, although you have a 256-field limit per record, it is so much faster to assemble data from other tables via queries than to do the equivalent in Excel to assemble data from multiple worksheets (Vlookups, Match or Index functions, etc), it isn't a serious limitation.

  9. #9
    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: Columns (2003)

    No, but then you would also need a lot more than 366 columns! I assumed that since Legare mentioned 366 and year, that he only wanted days.

    If you are dealing with hourly readings, you could put over 7 years of data in one sheet...

    Steve

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

    Re: Columns (2003)

    When you are doing manning charts for a four shift manufacturing operation, it make it a lot easier to see what is going on if you can put the days across the columns (about two characters wide) and the shifts down the rows. It is very difficult to see what is happening the other way around.
    Legare Coleman

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    I still find it strange why Microsoft has not considered the resizing of their sheets again. In Excel 95 we had 16000 odd rows, which was increased to 65000 odd rows. In this world of ever increasing data, its a logical step forward. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> I saw that Quattro Pro's lastest spreadsheet has a million rows by ??? (more than excel columns)!!!

    Anyways...thats just a thought! <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>
    Regards,
    Rudi

  12. #12
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns (2003)

    Have you considered writing down the rows, setting text as vertical, and tipping your monitor on its side? <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

  13. #13
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>.... It's a bit of effort.... but darn... it may just work!!!
    Sometimes a solution lies in muscle power..and not VBA power!
    Regards,
    Rudi

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Columns (2003)

    My NDA forbids me to say what MS's plans are with respect to # of rows and columns for Excel 12. Let us just say "Wait and see!"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Columns (2003)

    Just the fact that you answered this post indicated that something is in the pipeline. But as you say,...I will need to wait and see... <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15>
    Regards,
    Rudi

Page 1 of 2 12 LastLast

Posting Permissions

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