In Excel I always got confused with named ranges, as I thought they were hard to track.
Not!
The F3 keyboard shortcut gives you a list of named ranges including name and location. Which makes it way easier to work with named ranges.
See the excellent post Show all named ranges in Excel: It even has an animated gif image that shows you F3 in action.
–jeroen