Copy a Formula to Multiple Rows, but Keep One Column Ref in the Formula the Same?
Hey all!
I understand that when you copy a formula with criteria in certain columns to adjacent columns, it changes the column references to keep the relationship between columns the same (ie, column 10 has a formula that references col 1 & col 3, and copying the formula from col 10 to col 11 would result in the col 11 formula referencing col 2 & col 4)
Is there a way to keep a column reference as a hard reference no matter where it's place?
ie  Column 10 =Col1@row + Col3@row, Column 11 =Col2@row + [email protected] Col3@row reference never changes
Is there a symbol that can be put in front of it to always keep it there?
Thanks!
Best Answer

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.
Answers

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.
Help Article Resources
Categories
Check out the Formula Handbook template!