Lock ListColumn just like $A1

[Stevenn]

Normally I lock a column or row as "$A1" or "A$1", but when I use the names of my columns in a ListObject, eg. "SUM(MyTableName[Amount])", and copy the column it will change the name "Amount" to the column name just next to the column named "Amount". Is it possible to lock the column name?

 

[Andrew Poulsom]

If you copy by dragging the reference will change relatively. But if you copy and paste it will be absolute.