This, combined with judicious use of named ranges makes for much more pleasant formulas. Seeing `tax_rate` in the formula instead of `A$7$` is well worth the extra clicks.

I usually end up assigning names to nearly everything, single-cell constants, user input fields, computed lists, etc, etc