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 icon Answer


The answer is a four step process, shown here following the example in figure 1:

  1. Select the name to edit [Data]
  2. Edit the RefersTo element […:$B$9] is changed to [...:$B$13]
  3. Click the Add xlf-plus-square symbol to retain existing name IMPORTANT
  4. Click [OK]


xlf edit defined name in excel mac
Fig 1: Excel Mac - defined name dialog box


Watch the video


Fig 2: xlfVideo - Excel Mac - name a range, add more data, then edit the name - range of cells - to expand the dimension