How to convert structured references in Excel to table references?

I'd like to have more "meaningful" formulas in my Excel columns. Tables provide a nice way to do that and I'd like to convert my existing sheets to use tables and automatically turn the formulas that use A1 notation into equivalent formulas with table references, such as:

Before:

Foo Bar Baz
1 2 = A2+B2

After:

Foo Bar Baz
1 2 = [@Foo] + [@Bar]

Alternatively, how could I use column aliases? I've been able to set the column aliases, but when I use "apply names", the formulas become broken (#spill)


Do you mean you Define Name in Excel and you want to use the Name in formula? Try this Define Name first and select the name from the list in formula: enter image description here