Excel Tables - Allow Table Column to Drag with CRTL+D

[Wrathard]

Hello guys,
I'm working on an excel spreadsheet and I've run into an issue with tables.

Whenever I reference the entire column and try to drag it along with CRTL+D, the column refernce stays static and does not change.

Is there a way to allow relative column referencing with tables so whenever I drag the Column reference also moves along?

Thanks!