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? |
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? |
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 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com