How do I change a range name back to the underlying data range?

[Guest]

I have inherited spreadsheets from users that were fond of naming ranges
using the Insert, Name, Create function, and a lot of formuls incorporate the
names in them. My problem is that I can't see at a glance of the formula
what the underlying data range is (on vlookup for example), and a lot of
these named ranges reference other named ranges, only to all lead back to one
data source.

Is there a way to replace the name in the formulas (quickly without the
obvious copy/paste, find/replace or redoing all formulas) with the actual
reference to the data source?

 

[Guest]

Since range names, used properly, make spreadsheet work easier, you might try
this before you go replacing them:

Add a new sheet to the workbook, then:
Insert>Names>Paste
Click the [Paste List] button

That will create a listing of range names and the what they refer to.

Does that help?