An easier way to make the formula absolute is to double-click the cell that contains the original formula and then, with your mouse, highlight the formula, press F4 and then Enter.

This tutorial will show you how to create a Formula to Add, Subtract, Multiply or Divide in Microsoft Excel. You can do basic calculations easily!

An easier way to make the formula absolute is to double-click the cell that contains the original formula and then, with your mouse, highlight the formula, press F4 and then Enter.