Microsoft Office Tutorials and References
In Depth Information
Figure A–13. Filter options in the Name Manager. Note the range names are now sorted.
The Names with Errors filter option lists only those ranges containing any values which exhibit an
error message, e.g., #REF or #VALUE!.
Range names can add a measure of ease-of-use to the formula writing process, and can inform the
user—and her colleagues—about the contents of a range. On the other hand, there is a view that range
names should be used with caution, as there’s some evidence that they may hobble the spreadsheet
error debugging process. Your decision to name ranges will depend, as usual, on the purposes you
bring to your workbooks, and their complexity. But for straightforward formula writing tasks they’re
good to know about.