Repetitively typing each formula quickly becomes tedious, but Excel offers several solutions to quickly extend column formulas ... A and B in each respective row. An added benefit of arrays ...