Finding or editing named ranges

Use the Manage Ranges window to find all named ranges in a spreadsheet, or adjust which cells are included in a specific range.

  1. Click Insert > Named Range > Manage Ranges.
    Image of Manage Named Ranges window with one range selected
  2. To see the location of a named range, click the range name. The corresponding range of cells is highlighted in the sheet.
  3. To adjust which cells are included in a named range, take one of the following actions:
    • With the Manage Ranges window open, click in the sheet and reselect the range of cells you want. Click Apply. The range address is displayed automatically in the Refers to field.
    • Click the range name, edit the range address in the Refers to field, and click Apply.
  4. Click Close.

Trademarks | IBM Connections wiki