Here’s a tip sent by reader Mike Hendricks, CPA, cost accounting manager of Yarnell Ice Cream Co., Searcy, Ark.:
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.