Excel Question: How to copy formula's in a column with a constant cell?

Discussion in 'OT Technology' started by Tie5to, Oct 22, 2005.

  1. Tie5to

    Tie5to New Member

    Joined:
    Aug 18, 2005
    Messages:
    3,501
    Likes Received:
    0
    Location:
    New York
    I'm trying to figure out how to copy a formula across an entire column that keeps a constant cell. For example,

    I wanna have C3- B1; C4- B1 ; C5- B1, and so on. Everytime I try and copy the formula it wants to change both variables to C3- B3; C4-B4; but I don't want that! Any ideas on how I can keep it how I originally had it?
     
  2. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
    put a $ in front of the column or row value that you want to remain static.

    in your example... C3 - $B$1. you can copy this formula to other cells and it will only change the first part, but the $B$1 will remain constant/static.

    just as an extra FYI, there is a keyboard shortcut to help do this. while you are editing the formula, place the cursor in teh cell reference that you wish to make static, and press F4. it will cycle thru the three options of static-ness that you can have. ($B1, B$1, and $B$1).
     

Share This Page