Edit named range reference

B

brian

Hope you understand my terminology
I have a number of named ranges that I use a formula for in the "Refers
to" field. The formula is actually larger than the space allowed in
this field and so the end of the formula is not visible when I want to
edit it.
My problem is if I want to edit this field, I cannot move to the end of
the formula. The moment I start moving it inserts other cell
references. Is there a quick key or function key which allows me to
edit this.
Hope this makes sense
 
B

Bob Phillips

When you select the formula, hit F2, and you can move about the formula at
will without corrupting

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top