Table Formulas Toggle

The Hero Tools Add-in adds a checkbox toggle to the Table Design tab for Table Formulas. This feature toggles the “Use Table Names in Formulas” option on/off.

When the option is turned on, Excel will create structured references for the table and column names when you are writing formulas.

When the option is turned off, Excel will create regular cell/range references when you are writing formulas.\

table-formula-references-can-be-turned-off-example

The “Use Table Names in Formulas” option can also be turned on/off in the Excel options menu. Hero Tools just adds the option to the Table Design tab to make it faster and easier to toggle this popular option.

Please see our post on How to turn off Structured References in Excel Tables to learn more.

Comments or Questions?

Please post any comments or questions in the Hero Tools Community Forum.

>