Auto numbering stop
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Auto numbering stop

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

    Default

     
    I have an Excel document with over 960 items. In a column I used for numbering the items, each time a group of items was added I was pulling down from the corner to auto-number. When I reached 958 suddenly I was no longer able to do this. When I place the cursor over the lower right corner of the cell now it does not change to a cross. Also I am no longer able to change the print area by dragging down the dark blue line at the bottom of the previously set print area.
    I'm sure there must be a simple explanation for this but I haven't been able to find it.
    Thanks for any help.
    (BTW- I just found your site and can't wait until I have some time to sift through the archives. I couldn't find a way to search for references to this particular question though.)
    Andem

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'd suggest, instead of filling out everything again, just use this formula from A2 and below. That way you can just drag the last one everytime you add something.

    =A1+1
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    BTW, couldn't replicate your problem... may be a memory issue then ?
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

      
    Thanks guys for the quick response. The work around sounds great to me as the idea of plugging in each number was not a thrill.

    As for the question of memory- I don't know really. I have 512 MB of memory in this machine which should take care of it; however, I recently switched to Windows XP and have had problems several times with Photoshop that seemed to relate to memory. It was saying it didn't have enough scratch disk space (absurd since it had over 20G clear) but shouldn't have even had to go to the scratch disk if it had been using the memory properly. Maybe???? I seem to be a record holder when it comes to generating computer problems.

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
  •  

 

 
DMCA.com