In Excel 2002, if you create a formula that uses a range of data, i.e.,
sum(a1:e1), when you move the data in that range to another location, the
formula changes to the new location of the data range. In other words, if
cell f1 contains the formula sum(a1:e1), and I move the contents of a1:e1 to
a4:e4, the formula in cell f1 changes to sum(a4:e4). Is there some way to
make the formula remain sum(a1:e1), even when the data is moved?