Apr 24 2022 12:34 PM
Hi,
I have a table and many structured references formula. But now i want change to cell references formula. How can i change?
Apr 24 2022 12:51 PM
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.
Apr 24 2022 01:24 PM
Apr 24 2022 02:38 PM
Apr 24 2022 02:39 PM