Answer:
Copy the same formula to other cells instead of re-typing it
Simply copy the formula to adjacent cells by dragging the fill handle (a small square at the lower right-hand corner of the cell). To copy the formula to the whole column, position the mouse pointer to the fill handle and double-click the plus sign.
Explanation:
hope its help
