Drag without incrementing

Discussion in 'Excel Beginners' started by trvlnmny@yahoo.com, Apr 29, 2014.

  1. Guest

    I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
    When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1.
    How can I prevent this?
    Thanks for any and all help.
     
    , Apr 29, 2014
    #1
    1. Advertisements

  2. Claus Busch Guest

    Hi,

    Am Tue, 29 Apr 2014 03:11:25 -0700 (PDT) schrieb :

    > I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
    > When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1.
    > How can I prevent this?


    drag with pressed CTRL


    Regards
    Claus B.
    --
    Vista Ultimate / Windows7
    Office 2007 Ultimate / 2010 Professional
     
    Claus Busch, Apr 29, 2014
    #2
    1. Advertisements

  3. Gord Dibben Guest

    Right-click>drag>release and "copy cells"

    Gord



    On Tue, 29 Apr 2014 03:11:25 -0700 (PDT), wrote:

    >I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
    >When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1.
    >How can I prevent this?
    >Thanks for any and all help.
     
    Gord Dibben, Apr 29, 2014
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Debra Dalgleish

    How to click and drag to modify plotted data in Excel?

    Debra Dalgleish, Oct 20, 2004, in forum: Excel Beginners
    Replies:
    0
    Views:
    67
    Debra Dalgleish
    Oct 20, 2004
  2. MediaScribe

    Automatically 'incrementing' formulas for new rows.

    MediaScribe, Feb 21, 2005, in forum: Excel Beginners
    Replies:
    3
    Views:
    96
    MediaScribe
    Feb 21, 2005
  3. brbarto

    Table of incrementing by one numbers

    brbarto, Dec 20, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    108
  4. cerebro

    incrementing cost in excel???

    cerebro, Apr 28, 2006, in forum: Excel Beginners
    Replies:
    2
    Views:
    110
    cerebro
    Apr 28, 2006
  5. Bob
    Replies:
    2
    Views:
    93
    Gord Dibben
    Mar 15, 2010
  6. anickless

    Copy and Pasting Formulas are incrementing

    anickless, May 5, 2010, in forum: Excel Beginners
    Replies:
    3
    Views:
    112
    anickless
    May 5, 2010
  7. Bob

    Incrementing Numbers ?

    Bob, Jan 8, 2011, in forum: Excel Beginners
    Replies:
    3
    Views:
    154
    joeu2004
    Jan 8, 2011
  8. Picc

    Not incrementing cell reference

    Picc, Mar 8, 2013, in forum: Excel Beginners
    Replies:
    1
    Views:
    166
Loading...