+ Reply to Thread
Results 1 to 11 of 11

formula wont copy across to other cells correctly

  1. #1
    Registered User
    Join Date
    03-05-2006
    Posts
    10

    formula wont copy across to other cells correctly

    I have a formula in say column D & have copied it across to various other columns, the thing is is that the copied cells do not have the same formula as in cell D (it adds a column instead of copyin the formula) thank you in advance

  2. #2
    Doug Kanter
    Guest

    Re: formula wont copy across to other cells correctly

    Exactly what keystrokes or mouse actions are you using to copy the formulas?

    "chrissywhittle"
    <chrissywhittle.24d2ay_1141838101.0849@excelforum-nospam.com> wrote in
    message news:chrissywhittle.24d2ay_1141838101.0849@excelforum-nospam.com...
    >
    > I have a formula in say column D & have copied it across to various
    > other columns, the thing is is that the copied cells do not have the
    > same formula as in cell D (it adds a column instead of copyin the
    > formula) thank you in advance
    >
    >
    > --
    > chrissywhittle
    > ------------------------------------------------------------------------
    > chrissywhittle's Profile:
    > http://www.excelforum.com/member.php...o&userid=32158
    > View this thread: http://www.excelforum.com/showthread...hreadid=520186
    >




  3. #3
    Registered User
    Join Date
    03-05-2006
    Posts
    10
    edit - copy - paste
    right click copy - paste or paste special

  4. #4
    Doug Kanter
    Guest

    Re: formula wont copy across to other cells correctly

    OK. And, you say it "adds a column". Do you mean that (for instance), if you
    had column F and column G, an actual column is inserted between them, as if
    you had used the Insert, Column menu commands? Or, that the column numbers
    are changing when you copy the formulae across?

    "chrissywhittle"
    <chrissywhittle.24d38a_1141839301.2623@excelforum-nospam.com> wrote in
    message news:chrissywhittle.24d38a_1141839301.2623@excelforum-nospam.com...
    >
    > edit - copy - paste
    > right click copy - paste or paste special
    >
    >
    > --
    > chrissywhittle
    > ------------------------------------------------------------------------
    > chrissywhittle's Profile:
    > http://www.excelforum.com/member.php...o&userid=32158
    > View this thread: http://www.excelforum.com/showthread...hreadid=520186
    >




  5. #5
    Registered User
    Join Date
    03-05-2006
    Posts
    10
    sorry, the column numbers change:

    say i have an amount i wish to multiply by in row 5B and in colums c,d, etc have different values, i wish to use row 5b as my mulitipliction 'master'. the same formula will be used throughout all coloumns the only change being the different values in columns c,d,etc. thank you

  6. #6
    Doug Kanter
    Guest

    Re: formula wont copy across to other cells correctly

    OK. When you copy a formula, Excel increments ("steps") cell numbers in a
    relative way. In other words, if you type =A1+4 in cell B1, Excel really
    sees that as "look one cell to the left", not necessarily as A1. When you
    copy the formula across the row, it'll change the A1 to B1, C1, etc. To stop
    this behavior, add a dollar sign to the original formula: =$A1+4. This is
    called an absolute reference.

    "chrissywhittle"
    <chrissywhittle.24d60a_1141842901.4344@excelforum-nospam.com> wrote in
    message news:chrissywhittle.24d60a_1141842901.4344@excelforum-nospam.com...
    >
    > sorry, the column numbers change:
    >
    > say i have an amount i wish to multiply by in row 5B and in colums c,d,
    > etc have different values, i wish to use row 5b as my mulitipliction
    > 'master'. the same formula will be used throughout all coloumns the
    > only change being the different values in columns c,d,etc. thank you
    >
    >
    > --
    > chrissywhittle
    > ------------------------------------------------------------------------
    > chrissywhittle's Profile:
    > http://www.excelforum.com/member.php...o&userid=32158
    > View this thread: http://www.excelforum.com/showthread...hreadid=520186
    >




  7. #7
    L. Howard Kittle
    Guest

    Re: formula wont copy across to other cells correctly

    Hi chrissywhittle,

    To add to Doug's replies. Type a formula in any cell such as =A1. You can
    use F4 to toggle through the different styles of absolute references. =$A1,
    =A$1, =$A$1.

    HTH
    Regards,
    Howard

    "chrissywhittle"
    <chrissywhittle.24d2ay_1141838101.0849@excelforum-nospam.com> wrote in
    message news:chrissywhittle.24d2ay_1141838101.0849@excelforum-nospam.com...
    >
    > I have a formula in say column D & have copied it across to various
    > other columns, the thing is is that the copied cells do not have the
    > same formula as in cell D (it adds a column instead of copyin the
    > formula) thank you in advance
    >
    >
    > --
    > chrissywhittle
    > ------------------------------------------------------------------------
    > chrissywhittle's Profile:
    > http://www.excelforum.com/member.php...o&userid=32158
    > View this thread: http://www.excelforum.com/showthread...hreadid=520186
    >




  8. #8
    Registered User
    Join Date
    03-05-2006
    Posts
    10
    thank you all so very much

  9. #9
    Registered User
    Join Date
    03-05-2006
    Posts
    10
    thank you all so very much it worked for a while yet it is still doing it
    the formula has changed the original column say my original formula is =sum($B3*C15) I would like the same formula along the rest of the row being ($B3&d15),b3*e15, b3*f15 etc.... but its not working it will change the formula

  10. #10
    Registered User
    Join Date
    03-05-2006
    Posts
    10
    sorry im a complete doughnut! - i was writing the formula incorrectly - sorry!!!!

  11. #11
    Doug Kanter
    Guest

    Re: formula wont copy across to other cells correctly

    "chrissywhittle"
    <chrissywhittle.24dnlm_1141865701.6365@excelforum-nospam.com> wrote in
    message news:chrissywhittle.24dnlm_1141865701.6365@excelforum-nospam.com...
    >
    > sorry im a complete doughnut! - i was writing the formula incorrectly -
    > sorry!!!!


    I was about to say "THINK!", but you got it. :-)



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1