Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA to create a new worksheet, and then target new worksheet | Excel Discussion (Misc queries) | |||
automatically close hyperlink with back button | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Worksheet Function - Find? | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |