Fixed cells in a formula

G

Guest

Guest
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,920
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top