Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Ontario, Canada
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Fill Not working (XP )

    Hey there ... I am trying to do an autofill of sequential numbers with a series that looks like this:
    V123456789
    V123456790
    V123456791

    When I do the autofill, Excel simply copies the numbers. It doesn't matter if I select 1 or all three of the numbers in that column. Smart tag options only allow me to copy data or formatting.

    I am doing this in another worksheet on another computer without a problem, so I know that the letter in the item isn't having an impact. Can anyone think of a reason that this isn't working?

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

    Re: Auto Fill Not working (XP )

    Some threads in the MS newsgroups suggest making sure that Calculation is set to Automatic in the Calculation tab of the Tools | Options... dialog. On my system, that has no influence on AutoFill, but it takes just a few seconds to check it. I can't find anything else about it (except that AutoFill doesn't work if the cell contents are over 255 character long).

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

    Re: Auto Fill Not working (XP )

    If you right click on the fill handle and drag down, then click on "Fill series" in the popup menu, what happens.

    It works just fine on my XL2K.
    Legare Coleman

Posting Permissions

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