1. column
  2. 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

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.