Hi ,



I'd like to know if it's possible to propagate a formula which references a named cell but having the formula change reference cells accordingly when propagated.

Say for example I had cell A1 named OmegaT and in cell B1 I had =OmegaT+180 then I propagated the equation down column B. It seems that OmegaT is treated as $A$1. Is it possible to make the equation in cell B# reference A# rather than being locked to A1?

Thanks