Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Max Number of Columns?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A collegue sent me an excel spreadsheet that only had about 20 or 30 columns in it, I needed to insert another one, but Excel said it couldn't shift nonblank cells off the worksheet. How do I make the worksheet bigger?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey I've seen that.

    Usually you can solve by selecting all of the columns to the right of the data and hitting editclear all. Then try it again..

    Adam

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here is a screenshot of the problem



    Any ideas?

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    You cannot exceed 256 columns in any version of Excel. However, exceeding 256 does not seem to be the actual case in your situation.

    On occasion, some character, possibly even a non-printable one, is found in the last cell of a column or row (or both). Go to column IV and delete the column (possibly a few more if necessary). Then, you will be able to insert columns as normal.

    Bye,
    Jay

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Still can't get it, how frustrating

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've had this happen quite often. When you insert a new column XL must delete one of the end ( it always has 256 cols. ).

    What I usually do is delete a few empty columns ( 10 or 20 ) to the right of the data. This usually sorts it.

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you have any hidden columns? Try unhiding and possibly format all columns to a specific width. You may be able to then do some of the steps listed earlier.

    Adam

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys, I ended up having to just Clear->All some columns at the end out like you said.

    Wierd...


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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