drag cell reference

Excel users often find themselves dragging colored box references when moving a formula in an asymmetric worksheet. The all-too-frustrating reality, however, is that when a formula references the same cell multiple times, you have to drag each reference in the formula. Unfortunately, there is no shortcut to select all instances of a cell reference within […]