Forum Discussion

skamati's avatar
skamati
Copper Contributor
Nov 01, 2024

Quick question

How can I lock data to copy from same row but different columns?

3 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor

    skamati 

     

    To amplify a bit on the response from wumolad the technical term for this is "Absolute Reference." It's possible to anchor to a cell, a column, or a row. You accomplish this by using the dollar sign. In the absence of any dollar sign, you're using what's called "Relative Reference."

     

    $A$1 anchors to the cell, regardless of where you copy the formula to.

    $A1 anchors to the column

    A$1 anchors to the row

     

    Here's a more complete guide.

  • wumolad's avatar
    wumolad
    Steel Contributor
    Hi skamati

    You can use this A$1. Here the assumption is that you are referencing cell A1, when you copy the formula to column B, anywhere in the row, it changes to B$1 i.e. the row does not change.
  • mathetes's avatar
    mathetes
    Silver Contributor

    skamati 

     

     

    How can I lock data to copy from same row but different columns?

     

    Quick answer: 

    How about beginning with an example or two to explain what you mean?

     

Resources