Journal of Accountancy Large Logo
|
Technology

A Better Way

 

By Stanley Zarowin
October 2007

A BETTER WAY
The April column reported a technique for maintaining an Excel cell reference when copying a cell’s formula to a different location. Reader Dhan Brar, finance manager of Kern Health Systems, Bakersfield, Calif., suggests an easier way, if you want to move the cell rather than copy it. Just drag the cell with the formula to the new location; the cell reference stays the same as in the original formula. To drag a cell, first select it and then hover your mouse cursor over an edge of the cell until it changes into four outward-pointing arrows, then click and drag.

View CommentsView Comments   |  
Add CommentsAdd Comment   |  
CPE Direct articles Web Exclusive content
AICPA Logo Copyright © 2010 American Institute of Certified Public Accountants. All rights reserved.
Reliable. Resourceful. Respected. (Tagline)