Tab to Certain Fields
 

I have a Worksheet where certain fields are filled out is it possible to
automatically move to the next field I want to populate without having to
physically click on the cell I want. Something like Tab? So for example if I
enter a value in A5 and the next field I want filled out is E14 it jumps to
it once a value is put in A5?

Thanks

Tab to Certain Fields
 

Hi John

Select A5 and E14. Go menu Format Cells, Protection and unselect Locked.

Now go menu Tools Protection Protect worksheet. Once protected then
tabbing moves between unlocked cells only, the others are write protected.

For your possible followup; can you set the tab order like A5, E14, B6, G2,
.... no, there is no easy or user friendly way to do that. Possible but very
awkward.

HTH. Best wishes Harald

"John" skrev i melding
...
I have a Worksheet where certain fields are filled out is it possible to
automatically move to the next field I want to populate without having to
physically click on the cell I want. Something like Tab? So for example if
I
enter a value in A5 and the next field I want filled out is E14 it jumps
to
it once a value is put in A5?

Thanks