I am trying to enter a formula in a cell (B1) which equals A1 multiplied by the value of 1 cell (F11) on another worksheet within the workbook. I then want to copy the formula so that any numbers entered in column A will be multiplied by the value of F11 on the other wksht. However, when I drag the cell, the F11 goes up by one row. I want the B1 to change but want the "F11" to stay the same. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copying/Pasting Formulas
- Thread starter SMatthews
- Start date
Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
You have to make F11 an absolute. To do this, either edit the formula manually by entering a $ sign before the F and another one before the 11, so that it looks like this:
=A1*Sheet2!$F$11
or click on the F11 part of the formula in the formula bar and press F4 one time.
This anchors both the F column and row 11.
Suggest you check out "Absolute reference" and "relative reference" in Help, as this is a pretty basic operation in Excel.
=A1*Sheet2!$F$11
or click on the F11 part of the formula in the formula bar and press F4 one time.
This anchors both the F column and row 11.
Suggest you check out "Absolute reference" and "relative reference" in Help, as this is a pretty basic operation in Excel.
Upvote
0
Similar threads
