A Better Way

BY STANLEY ZAROWIN

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.

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.