xlf QandA series
Editing the address of a defined name in Excel for Mac
QUESTION
HOW DO I EDIT THE ADDRESS OF A DEFINED NAME IN EXCEL FOR MAC WITHOUT HAVING TO CREATE A NEW NAME
Answer
The answer is a four step process, shown here following the example in figure 1:
- Select the name to edit [Data]
- Edit the RefersTo element […:$B$9] is changed to [...:$B$13]
- Click the Add
symbol to retain existing name IMPORTANT
- Click [OK]

Watch the video
- Development platform: Excel for Mac Version 16.22 (190211) Office 365 Subscription
- Published: 29th March 2019
- Revised: Friday 24th of February 2023 - 10:39 PM, Pacific Time (PT)