Defining names

New Contributor

'how can i change a defined name to something different? every time i try to give a cell a different name than is already there I get the error message dialogue box which doesn't help'

2 Replies
best response confirmed by Scully64 (New Contributor)


Click 'Name Manager' on the Formulas tab.

Select a name and click Edit...

Perfect! thanks for your help