Anchor an Excel Range without $ Signs

BY STANLEY ZAROWIN

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.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.

SPONSORED REPORT

Solving the lease accounting challenge

The challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.