Copying formulas

Topic

New Reply

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?

Reply | Quote

Replies

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!

Reply | Quote