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.
A Better Way
BY STANLEY ZAROWIN
