Forum Discussion
Edit a named constant
Hi all, Is it possible to edit the value of a named constant in a formula? I'm using a workbook where a summary sheet is calculating the registration fees due for teams entered into a sporting ca...
Hi,
Go to Formulas >> Name Manager or press Ctrl+F3.
Then find the constant name, select it and change its value from the box below, and then hit Enter.
After you close the Name Manager the change will be applied to all formulas that use this constant.