Home |
Search |
Today's Posts |
#1
|
|||
|
|||
i want to insert a link to another sheet tab
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 ? ? ? ? |
#2
|
|||
|
|||
Have a look in help for HYPERLINK or create a macro with application.goto
sheet1!a1 and assign to a button or shape. -- Don Guillett SalesAid Software "Noshorts" wrote in message ... 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 ? ? ? ? |
#3
|
|||
|
|||
Right-click on the cell and select "Hyperlink"
From options pick "Within this document" Chhose what yow wish. Gord Dibben Excel MVP On Sat, 4 Dec 2004 10:55:03 -0800, "Noshorts" wrote: 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 ? ? ? ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
How do I insert a scroll bar into the excell sheet? | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
insert a bitmap to the background of a spread sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |