Anchor an Excel Range without $ Signs

If you have a range of data you need to keep together—for instance,
a lookup table—you can anchor it without using dollar signs, such as
in $A$1:$Z$50 . Do this instead: Highlight the target range of values.
Then click in the Name Box (in the top left corner of
the window) and name the range.