Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
If a very large formula is required for a named range, how does one go about
editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
Before trying to move the cursor press F2, that way you are in edit mode
-- Regards, Peo Sjoblom "Rich" wrote in message ... If a very large formula is required for a named range, how does one go about editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
Rich, I used to have this same problem. I found it was easier to use the
End key to go to the end, then use the left arrow to go back to where I wanted to make changes. Somebody else might have a better insight into this. James "Rich" wrote in message ... If a very large formula is required for a named range, how does one go about editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
Rich
It is awkward, you can use the mouse to move to visible portions of the formula but not beyond. On a blank sheet, Press F3 to open the name dialog box and choose list - this will list each range name and formulas and will help you to edit one. Regards Peter "Rich" wrote: If a very large formula is required for a named range, how does one go about editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
Thanks Peo, that works great...what a relief.
Will try the other suggestions as well. Thanks all. "Peo Sjoblom" wrote: Before trying to move the cursor press F2, that way you are in edit mode -- Regards, Peo Sjoblom "Rich" wrote in message ... If a very large formula is required for a named range, how does one go about editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit the 'Refers to:' box on the Define Name dialogue
F2 will put the cursor in "edit" mode (rather than insert/point-to mode).
You can then use arrow keys to move around safely. HTH, "Rich" wrote in message ... If a very large formula is required for a named range, how does one go about editing it on the Define Name dialogue? I've been writing the formula in notepad, then pasting the whole thing into the text box. Every time I try to move the cursor along in the text box with the arrow keys, Excel thinks I am tying to add data to the formula when all I really want to do is see the parts of the formula beyond the edge of the text box. The Define Name panel cannot be sized to allow the whole formula to be seen. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Names in refers to field of Define Name | Excel Discussion (Misc queries) | |||
Add Edit/Define Range Name to right click on cell | Excel Discussion (Misc queries) | |||
Can't find Edit, links dialogue box to break the link | Excel Discussion (Misc queries) | |||
Same Name refers to local ranges | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |