Is there some way to give a formula with a name without having to
manually retype the whole thing? I have a big formula that works
perfectly, and I'd like to define it as a name so I can use the
formula in several different places. I can't paste it in the Define
Name Refers to: box and it's too long for me to type in manually
without making an error.

I should mention that the sheet I'm using now has the formula
functioning this way (as a defined name), but the formula has changed
and editing it is impossible because I can't scroll through the
formula to change values without inserting cell references.

TIA