Not inserting cell references when navigating forms.

Hi All,

To someone this is gonna be an easy one I'm quite sure. Seems trivial but I use Excel for hours every day as part of my work and it's a regular annoyance.

Easier explained by example, imagine I have a cell with validation and I need to add to my list. My list is Cat, Dog, Frog, Parrot and I need to add Elephant. So I tab down to Source, I want to right arrow to after Dog and type Elephant, but as soon as I hit the right arrow key it replaces the full list with an absolute reference to the selected cell. Is there any way I can get this to not happen so I can instead use the arrow keys to edit the text in the same manner as when composing this text.

Cheers,

DC

When I update a data validation source, I insert a cell right above the last item in the list and enter the value there. This inserts the cell within the range, and it will continue to include the original cells, plus the one you just inserted.

If they need to be in a particular order, you can just type the original last value (Dog) in the inserted cell, then put the new value (Elephant) where the original last value (Dog) was.