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.

SPONSORED REPORT

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.