Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to edit Name Range formulas
I have some named ranges that are formulas. I need to edit the
formula. I go to InsertNameDefine and select the Named Range whose formula I want to edit. The formula appears in the Refers To box. Here's the problem. The box is not large enough to show the entire formula. Of course if I try to use any of the navigation keys in that box (Home, End, Arrows, etc.), it starts changing the formula. I tried copying the formula to a worksheet, editing the formula, then copying it back and saying Add. Does not work. So I have to meticulously cut into the formula, find where I want to edit, make the edit, then fix all of the stuff that got messed up when I was editing. I must be missing the easier way! tod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to edit Name Range formulas
when you select in the Refersto box hit F2 and you will be able to move with
the arrow keys. -- Regards, Tom Ogilvy tod wrote in message m... I have some named ranges that are formulas. I need to edit the formula. I go to InsertNameDefine and select the Named Range whose formula I want to edit. The formula appears in the Refers To box. Here's the problem. The box is not large enough to show the entire formula. Of course if I try to use any of the navigation keys in that box (Home, End, Arrows, etc.), it starts changing the formula. I tried copying the formula to a worksheet, editing the formula, then copying it back and saying Add. Does not work. So I have to meticulously cut into the formula, find where I want to edit, make the edit, then fix all of the stuff that got messed up when I was editing. I must be missing the easier way! tod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easy one - multipule formulas in one cell | New Users to Excel | |||
My spreadsheet SUM formulas stopped working. Is there any easy rea | Excel Discussion (Misc queries) | |||
Easy question - copying worksheet and keeping formulas | Excel Discussion (Misc queries) | |||
Formulas an easy explanation | New Users to Excel | |||
Copying Formulas from One Worksheet to Another -- Very Easy Questi | New Users to Excel |