He,

I want to copy a formula and want to lock a certain column, just like you use the dollar signs in normal formulas. Because the data in tables can't be locked with dollar signs, I was wondering if it's possible to lock them on another way.

Example:
example 1.xlsx