i want to insert a link to another sheet tab

[Noshorts]

I want to insert a link into a cell, in Excel, that, when clicked, will take
me to and display another sheet within ths same workbook. Can anybody help me
to achieve this action ? ? ? ?

 

[Don Guillett]

Have a look in help for HYPERLINK or create a macro with application.goto
sheet1!a1 and assign to a button or shape.

 

[Gord Dibben]

Right-click on the cell and select "Hyperlink"

From options pick "Within this document"

Chhose what yow wish.

Gord Dibben Excel MVP