Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    If I grab a cell and drag it, sometimes Excell increments numeric values (even if they are on the end of a string) and sometimes it doesn't. Sometimes I want it to and other times not.

    What governs whether it does or not?

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Brussels, Belgium
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just push Control while dragging - cell values will not increment.


  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    Or will increment if they weren't.

    cheers, Paul

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You can also right-click and drag, then you will get a choice at the end.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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