1. column
  2. TECHNOLOGY Q&A

A Better Way

BY STANLEY ZAROWIN

Please note: This item is from our archives and was published in 2007. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

No Results

TOPICS

    Uncategorized Article

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.