ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   links? (https://www.excelbanter.com/excel-discussion-misc-queries/252412-links.html)

Anne

links?
 
How do I set up a cell so that when you click on it, it directs you to an
explanation of the data on another worksheet?

Jacob Skaria

links?
 
--Right click on the cellHyperlinkFrom the left "Link to" icon list select
''Place in this document' Select the sheet name and enter the cell
reference..

--OR try the below formula to refer Sheet2 cell C3

=HYPERLINK("#Sheet2!C3","")

--
Jacob


"anne" wrote:

How do I set up a cell so that when you click on it, it directs you to an
explanation of the data on another worksheet?



All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com