hyperlink to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top