audioguy52
Electrical
In an Excel formula with dependent/referneced cells how do I lock a particular dependent cell while letting the other dependent cells increment as I copy the formula to subsequent rows?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula in Excel
- Thread starter audioguy52
- Start date
- Status
audioguy52:
If I understand the question correctly then you need to add $ signs to the formula such as $A$1 so that the cells you copy the formula to will continue to pint to the cell A1. If understood incorrectly please let me know
ktwannabe
If I understand the question correctly then you need to add $ signs to the formula such as $A$1 so that the cells you copy the formula to will continue to pint to the cell A1. If understood incorrectly please let me know
ktwannabe
If you want the cell to stay contant (ie, ref cell A1, hit the F4 key once selected A1 (should look like this, $A$1, or you can just type in the $).
If you only want the columns to remanin constant, type $A1, or for rows type A$1.
With this done, no matter where you copy cell to on worksheet, the row/column/both will remain unchanged.
If you only want the columns to remanin constant, type $A1, or for rows type A$1.
With this done, no matter where you copy cell to on worksheet, the row/column/both will remain unchanged.
- Thread starter
- #4
audioguy52
Electrical
Thanks guys, the $ in front of the row & column designators did the trick.
Thanks again!
Thanks again!
Just a note:
When you finish pasting formulas containing absolute cell references (like those using $ signs), it's a good idea to remove them from the sheet using edit find/replace. I have had some trouble in the past copying parts of Excel sheets that contained absolute references without realizing this, and it can be very troublesome to be referring to a part of a sheet, (or another file) by mistake.
i.e. absolute references retain the full filename and excel tab to which they are pointing ...yikes.
my 2 cents...
tg
When you finish pasting formulas containing absolute cell references (like those using $ signs), it's a good idea to remove them from the sheet using edit find/replace. I have had some trouble in the past copying parts of Excel sheets that contained absolute references without realizing this, and it can be very troublesome to be referring to a part of a sheet, (or another file) by mistake.
i.e. absolute references retain the full filename and excel tab to which they are pointing ...yikes.
my 2 cents...
tg
- Status
Similar threads