Name Define

K

Ken Johnston

Hi ,

I have a rather long formula which has been given a name.

I need to edit it occasionally but when I choose INSERT - NAME - DEFINE and
choose the "name" the formula appears in the refer box as expected. However
only the first 63 characters can be edited. I cannot scroll along to the
remaining characters. At the moment I am having to rewrite the formula
again.

Anyway around this without resorting to writing the formula into a cell
rather than the defined name?

Ken
 
G

Guest

Ken this is going to sound a bit weird

Highlight it with your mouse. Doing this allows it to slide back and forth
across the formula. Once you're in the area you have to edit click to
unhighlight and edit the portion you need to.

Sounds weird. But when weird works who's gonna argue?

(e-mail address removed)
 
B

Biff

Click in the "Refers To" box, then hit <F2>.

Make sure you hit that F2 key before you start navigating with your
directional arrow keys!

If not, you'll be cussing!

Biff
 
R

Roger Govier

Very true <bg>

If it is a long formula, then I often do the editing in a cell, where it
is easier to see the whole formula at once.
Once the formula is set as required, Copy and Paste into the "Refers To"
box.
You won't have an option to Paste from the right click menu, but typing
Ctrl+V to paste will work.
 

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

Top