i want to insert a link to another sheet tab

N

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 ? ? ? ?
 
D

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.
 
G

Gord Dibben

Right-click on the cell and select "Hyperlink"

From options pick "Within this document"

Chhose what yow wish.

Gord Dibben Excel MVP
 
Top