How to Change a Range in Microsoft Excel. When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references.

How to Add the Difference Range In Excel. The simplest way to add cells in Microsoft Excel is using the plus operator, such as "=A1+A2," but that method fails when adding different ranges.