Don't copy formulas cell by cell — you're working way harder than you need to.

Excel is known as a complex number cruncher that only experts can use, but, in my view, labeling the program with such a sweeping generalization undermines its ability to make life easier. And in no ...