Clarified.com

Copying formulas is among the most common task performed by the users in the worksheet. Most of the formulas doesn’t use constant values rather the cell references and Excel is smart at copying the …