In Cell Cell reference change

[FredMcStaire]

I have several formulas that I use in data validation or other instances where the entire formula is not visible in one glance. If I want to update the formula, I need to navigate through it. ( no problems so far). The inconvenience arises when I try to navigate around with the arrow keys to a precise location in the formula. This often inadvertently results in a reference change.

Any advice on how to either 1) stop the arrows from making reference changes, or 2)making the data validation box bigger would be appreciated.

Thanks!

 

[Drrellik]

the data validation box at lease for a dropdown list is driven by the cell size. as for the arrow keys, go to the cell that has your formula, hit F2 to 'open/enter the formula. then you can hit the END or HOME keys to move to the front and back of a long formula and from there you should be able to use the arrow keys without any reference changes.

HTH

~DR

if that does not work. put a . in front of the = and it will not be looked at as a formula until you are done making changes then you can actually copy and paste without cell reference changes until you remove the .

 

[FredMcStaire]

Thank you Drrellik. Good workable suggestions. Sometimes it's those simple things in front of my face that elude me. ( and the hard ones that hide - they elude me too)