Hi everyone;
I don't play with excel a lot but thought i'd ask if it was possible to have one field remain as dynamic / active no matter what 'other' field is clicked on / selected.
so, i have a times table that i made and i was thinking that it would also be good to have one field show / provide the square root of whatever other field was clicked on
so, if i clicked on the interection of 5 x 20 (100) then there would be another field say on the left or bottom that was designated as the square root and showed the answer 10 as the square root of 100 (10).
is there such a thing in excel as this sort of dynamic updating for one specific (or more) field ??
perhaps even just a mouse-over option instead of actually clicking on a field to show the square root in the other field.
Thank you,
peter
I don't play with excel a lot but thought i'd ask if it was possible to have one field remain as dynamic / active no matter what 'other' field is clicked on / selected.
so, i have a times table that i made and i was thinking that it would also be good to have one field show / provide the square root of whatever other field was clicked on
so, if i clicked on the interection of 5 x 20 (100) then there would be another field say on the left or bottom that was designated as the square root and showed the answer 10 as the square root of 100 (10).
is there such a thing in excel as this sort of dynamic updating for one specific (or more) field ??
perhaps even just a mouse-over option instead of actually clicking on a field to show the square root in the other field.
Thank you,
peter