hi Peo Sjoblom
use F5 key to go to cell
ex. jump to sheet 2 cell a1 = press F5 -- type " sheet2!a1 " -- Enter
But I want jump to Actived cell in sheet ... what is reference sheet
and cell to type ?
--
mai


"Peo Sjoblom" เขียน:

Not possible using go to (F5)

--
Regards,

Peo Sjoblom

Portland, Oregon




"mongkolkorn" wrote in message
...
Thank for you answer.
but I want to use press key F5 and jump to other sheet ...,active cell in
other sheet .....

--
mai


"Pete" เขียน:

You could put this formula in cell A1 of Sheet 1:

=HYPERLINK(#'Sheet 10'!A10,"jump")

Note that there is an apostrophe after the # and before the !. This
will put the word "jump" in cell A1 and when you click this it will
take you to cell A10 of Sheet 10.

Hope this helps.

Pete