IBM Docs wiki
Custom Search Scope...
Installing and deploying IBM Docs 1.0.5
Installing and Deploying 1.0.5
Using IBM Docs 1.0.5
Using IBM Docs 1.0.5 documentation
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
Finding or editing named ranges
December 11, 2013
Use the Manage Named Ranges window to find all named ranges in a spreadsheet, or adjust which cells are included in a specific range.
Manage Named Ranges
To see the location of a named range, click the range name.
The corresponding range of cells is highlighted in the sheet.
To adjust which cells are included in a named range, take one of the following actions:
With the Manage Named Ranges window open, click in the sheet and reselect the range of cells you want. Click
. The range address is displayed automatically in the
Click the range name, edit the range address in the
field, and click
When files in the format of
contain named charts, the charts are retained with their name ranges when you edit the file in
Managing data ranges
Edit the article to add or modify attachments.
12/11/13 8:44 PM
Compare selected versions
Summary of changes
This version (1)
Dec 11, 2013 8:39:41 PM
Copy and paste this wiki markup to link to this article from another article in this wiki.