Microsoft Office Tutorials and References
In Depth Information
The Name Manager – Tracking Your Ranges
The Name Manager – Tracking Your Ranges
The final and largest button inlaid into the Defined Names button group is the Name Manager. Click it
and you’ll see (Figure A–12):
Figure A–12. Range finder: the Name Manager dialog box
Most obviously, the Name Manager lists all the workbook’s named ranges, identifying their
location, some of the values populating the cells in the ranges, and their scope and any comments
about the range. By clicking Edit after clicking on a range name you'll be brought to an Edit Name
dialog box, which enables you to both change the range’s name as well as the range’s coordinates.
Click on a range name and then clicking Delete will naturally delete the range’s name – but not the
data in its cells (you can also do the same by clicking on a name and tapping the delete key). Clicking
the Name header sorts the ranges names in A-Z order.
The Filter button displays a list of options by which you can selectively view certain of your named
ranges (Figure A–13):
Search JabSto ::

Custom Search