×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Formula in Excel

Formula in Excel

Formula in Excel

(OP)
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?

RE: Formula in Excel

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

RE: Formula in Excel

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.

RE: Formula in Excel

(OP)
Thanks guys, the $ in front of the row & column designators did the trick.

Thanks again!

RE: Formula in Excel

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources