creating hyperlinks

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

Guest

I want to create hyperlinks from one sheet to another in the same excel file.
I mean clicking on any data cell in one sheet should take me to another sheet
in the same excel file. Any Clues??
 
You will want to use bookmarks.

1) Find a spot in an Excel sheet you want your hyperlink to be.
2) Click insert->hyperlink; then select the bookmark button
3) From here, you can pick the exact Cell you want to link to

Excel will pick a silly name for it, but you can rename it by editing
the new link you just made.
 

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