If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking worksheet pages
Hi, is there a way to create a link so that clicking on a cell will
take me to a cell on another worksheet? I would like to set up a list on a page that can reference another sheet- even better would be if I could set up a link where hovering over a cell shows data from a range of cells on another page. Thanks. |
#2
|
|||
|
|||
linking worksheet pages
is there a way to create a link so that clicking on a cell will
take me to a cell on another worksheet? There are 2 types of link in Excel: hyperlinks which, as on a website, take you to another location, and formula links which bring data from another location. Hyperlinks can be created in two ways: - Insert Hyperlink Link to: Place in this document ... - using the HYPERLINK worksheet function Clicking on a cell containing a hyperlink will take you to the appropriate location . A formula link - e.g. =Sheet2!$B$2 - displays the data from that cell and, if you switch off Tools Options Edit Edit directly in cell, double-clicking the cell containing the link formula will take you to the source cell. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|