I'm afraid what you are describing sounds like a hyperlink (I don't know how
you can avoid it!) however, there are numerous ways to create hyperlinks.

One quick way would be to have a list of cell address in A2:A10. Then, your
formula would be:
=HYPERLINK("'Sheet2'!&A2,A2)

You could then copy this down to quickly create hyperlinks to the other
destinations.

If this isn't what you are looking for, perhaps you could describe in more
detail exactly what it is you are trying to accomplish.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"SK" wrote:

Hi, Coudl anyone please help me to be able to click the cell which then opens
its destination which is on a different tab. I am aware i may use Hyperlink
but i am looking for an alternate as I would need this for many cells and
doing hyperlink for each would be too time consuming.
Thanks in advance.