Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Having trouble with excell 2007 copying a formula I've created. I made the formula =S2/A2 which gives me the total of S2 divded by the static number in a2. I want to divide s3 and s4 and so own by the stattic number in a2. The problem is when i try to drag my formula down it changes my formula to s3/a3. Is there a way to have it leave my formula s3/a2 and so on?

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by gbanks View Post
    Having trouble with excell 2007 copying a formula I've created. I made the formula =S2/A2 which gives me the total of S2 divded by the static number in a2. I want to divide s3 and s4 and so own by the stattic number in a2. The problem is when i try to drag my formula down it changes my formula to s3/a3. Is there a way to have it leave my formula s3/a2 and so on?
    If you want your reference to A2 to be 'absolute' - i..e fixed, you need to write it as $A$2.

    There is a quick way of doing this, by hitting F4 when you've entered your initial A2. Depending on how many times you hit F4, you can change whether the reference is fully Absolute, or only absolute for rows or columns ($A$2 or $A2 or A$2).

    It took me years to discover the F4 trick!

Posting Permissions

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