- column
- TECHNOLOGY Q&A
Anchor an Excel Range without $ Signs
BY STANLEY ZAROWIN
Please note: This item is from our archives and was published in 2006. It is provided for historical reference. The content may be out of date and links may no longer function.
Related
November 10, 2026
What Binance’s $6.3B crypto hack means for CPAs
November 1, 2026
Why AI needs to show its work
November 1, 2026
How firms make AI adoption work for them
TOPICS
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.
