Forum Discussion
skamati
Nov 01, 2024Copper Contributor
Quick question
How can I lock data to copy from same row but different columns?
3 Replies
Sort By
- mathetesSilver Contributor
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.
- mathetesSilver Contributor
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?