ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   i want to insert a link to another sheet tab (https://www.excelbanter.com/excel-worksheet-functions/7463-i-want-insert-link-another-sheet-tab.html)

Noshorts

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

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.

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




Gord Dibben

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