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
)