Edit named range reference

  • Thread starter Thread starter brian
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edit the rule description-how can u see a long formula in its enti 4
Excel - default to edit mode? 2
Applying defined names to existing formulas 3
Named Range maker code 9
hlookup with the sheet name is a reference from another cell 2
need to have SUM formula update on row add/delete/move - Excel 2003 14
Dynamic Names 1
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2

Back
Top