Linking cells in a worksheet to other worksheets in a workbook

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

Guest

I'd like to be able to link a cell in one worksheet to another worksheet, so
that when I click on the cell in the first worksheet, the other worksheet
opens up. I have a spreadsheet where the first page (worksheet) has a
listing of items contained in other tabs (worksheets). I'd like to be able
to click on the first worksheet "index" and have the appropriate worksheet
pop open with the contents of the index.

Thanks for your responses!
 
(In Excel 2003) Select a cell to which you would like to add a link. Select
Insert->Hyperlink. Click the "Place in this document" option. Select a
worksheet (or defined name). Click "OK"

Note: The format of the text in the cell may change (to blue underlined
text) but you can change the format without affecting the link.

Hope that helps
 
Maybe you could use the =hyperlink() worksheet function.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
 
Worked Great!! Thanks a million. I was looking at Hyperlink but didn't know
to go to the "Place in Document" option.
 
Dave,

Thanks for the reply. It helped.

Dave

Dave Peterson said:
Maybe you could use the =hyperlink() worksheet function.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Linking cells to worksheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
link to a specific worksheet of a workbook with many worksheets 1
Cell reference between worksheets 4
Sorting non-linked cells in a linked worksheet 1
Link one worksheet in a workbook to another worksheet in same work 1

Back
Top