![]() |
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 ? ? ? ? |
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 ? ? ? ? |
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 ? ? ? ? |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com