Forum Discussion
how to change the "structured references" to "cell references"
Hi,
I have a table and many structured references formula. But now i want change to cell references formula. How can i change?
4 Replies
- Out of curiosity, why would you want to do such a thing? Maybe it is part of some obfuscation exercise designed to conceal the intent of the workbook?
- because the person who will use the file cannot use this method.
Select any cell in the table.
On the Table Design tab of the ribbon, click Convert to Range and confirm.
Excel will replace all structured references to the table in formulas to cell references.
Then convert the range to a table again.
Excel will not re-convert the formulas.
- Thank you for your answer
