ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   hyperlink to another worksheet (https://www.excelbanter.com/excel-worksheet-functions/57054-hyperlink-another-worksheet.html)

billy boy November 23rd 05 09:19 PM

hyperlink to another worksheet
 
How do I add a button to a worksheet that when I click it, it will bring me
to a differnt worksheet? For example, I'm working on sheet 1 on line 150, I
would like to click a button to bring me to sheet 2 on line 150. Is this
possible?

Ken November 23rd 05 11:40 PM

hyperlink to another worksheet
 
You can create a link directly in a cell.

Right click the cell where you want the link.
Select Hyperlink.
Select "Place In This Document" on the left.
Select the sheet you want to link to.
Then specify the cell you want to link to (Optional).
Click OK.
The link will appear blue. Just click it.

"billy boy" wrote:

How do I add a button to a worksheet that when I click it, it will bring me
to a differnt worksheet? For example, I'm working on sheet 1 on line 150, I
would like to click a button to bring me to sheet 2 on line 150. Is this
possible?


billy boy November 25th 05 01:10 PM

hyperlink to another worksheet
 
Thank you for your answer. I appreciate it. Thanks again

"Ken" wrote:

You can create a link directly in a cell.

Right click the cell where you want the link.
Select Hyperlink.
Select "Place In This Document" on the left.
Select the sheet you want to link to.
Then specify the cell you want to link to (Optional).
Click OK.
The link will appear blue. Just click it.

"billy boy" wrote:

How do I add a button to a worksheet that when I click it, it will bring me
to a differnt worksheet? For example, I'm working on sheet 1 on line 150, I
would like to click a button to bring me to sheet 2 on line 150. Is this
possible?



All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com