Editing a named range in Microsoft Excel 2019

  1. Using the same workbook from the preceding example, we will edit thename range.
  2. On the Formulas tab, locate theDefine Names group. Click toselect Name Manager.
  3. Click to select the PRODUCTname to edit in the dialog box provided, as illustrated in thefollowing screenshot:

ms office 801

  1. Click on the Edit… button.
  2. When the Edit Name dialogbox appears, edit the name of the range orlocation to which it refers.
  3. Click in the Refers to placeholderat the end of the name range formula, after which you can move to theworksheet to correct the range or add to the range.
  4. You can select cells directly from the worksheet, then return to theEdit Name dialog box, asillustrated in the following screenshot:
ms office 792
  1. Click on OK to confirm. Click onClose to exit the Name Manager dialog box.

Leave a Comment