Fixed cells in a formula

Mar 15th, 2002, 05:29 AM

Hi, I have created a formula in Excel, where I would like to keep two cells a fixed/constant in the formula, but I want to drag the formula down and use the same cells in the formula, without the formula picking up other cells as i drag down... am I supposed to use a $ sign in there somewhere?
Thanks

Dave Hawley · Mar 15th, 2002, 05:34 AM

Hi

Yes, you are correct, you need the $.

Select your formula cell, push F2 and the use the F4 key to rotate through relative and absolute. Trial and errror is the best way.

hrayani · Mar 21st, 2011, 03:32 AM

If i have understood the question correctly.

there is another way of doing it... You can name the cell which you want constant in the formula..

For Example:

if you have a formula in D1 which is A1+B1+C1 and when you drag it down to the required number of rows then it will be like A2+B2+C2, A3+B3+C3 and so on... whereas, you want A1 And B1 to be fixed/constant in the formula.

just name cells A1 & B1 (for example a1=code1 & b1=code2)

now enter the formula in D1 like this =code1+code2+c1 and then drag it down to the required number of rows...

you will find that only cell c1 will change and code1 & code2 will not change..

Regards,

Humayun

Mar 21st, 2011, 03:32 AM	#3
hrayani Board Regular Join Date: Jul 2010 Posts: 302	Re: Fixed cells in a formula If i have understood the question correctly. there is another way of doing it... You can name the cell which you want constant in the formula.. For Example: if you have a formula in D1 which is A1+B1+C1 and when you drag it down to the required number of rows then it will be like A2+B2+C2, A3+B3+C3 and so on... whereas, you want A1 And B1 to be fixed/constant in the formula. just name cells A1 & B1 (for example a1=code1 & b1=code2) now enter the formula in D1 like this =code1+code2+c1 and then drag it down to the required number of rows... you will find that only cell c1 will change and code1 & code2 will not change.. Regards, Humayun

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 05:29 AM	#1
Guest Posts: n/a	Hi, I have created a formula in Excel, where I would like to keep two cells a fixed/constant in the formula, but I want to drag the formula down and use the same cells in the formula, without the formula picking up other cells as i drag down... am I supposed to use a $ sign in there somewhere? Thanks

Mar 15th, 2002, 05:34 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Yes, you are correct, you need the $. Select your formula cell, push F2 and the use the F4 key to rotate through relative and absolute. Trial and errror is the best way.