Maintain absolute references when dragging Table headings

[3G]

Is there a way to "$" a table heading so it doesn't move a column when I drag it? I spend a lot of time fixing the table heading in a formula after I drag it to the right/left, when I want that to stay fixed. Other than manually typing in the cell range, is there another way? perhaps this is a limitation to using tables.

Thanks!

 

[Luke M]

Hi 3G,

I think this will shed some light on the issue, and offer possible alternatives/solutions.
http://www.mrexcel.com/forum/excel-questions/455143-absolute-cell-reference-when-using-tables.html

 

[kchiba]

I experience the same pain, so I convert the formula to TEXT with ' and then copy it and when I am done I remove the '

cheers
kanti