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?
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