How to keep part of a formula unchanged when copying

Cubicle53

New Member
Joined
Jun 29, 2007
Messages
9
Hi,

How do I enter the value in a cell (say B4) into a formula as a constant so it doesn't change when I copy it down the column?

For example,

B4 = 2.4 (a constant)

This is the result I want:

F6 =C8 + B4*4.243

F7 =C9 + B4*4.243

F8 =C10 + B4*4.243

B4 remains constant as I copy F6 down.

What's the correct formula for F6 so I can copy it down and keep B4 fixed?

Thanks.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,328
Office Version
  1. 365
Platform
  1. Windows
Select B4 in the formula bar and press F4.

F6 =C8 + $B$4*4.243
 

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
Put dollar signs in the cell reference, i.e:
=C8+$B$4*4.243
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
In adddition to what Norie suggested, check out "Absolute References" in the helpfile.

HTH,

Smitty
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
In adddition to what Norie suggested, check out "Absolute References" in the helpfile.

The $ signs make the column and row references static.

HTH,

Smitty
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,613
Messages
5,765,422
Members
425,286
Latest member
CazzaBabes

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
Top