ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I create a link from a cell to take me to another worksheet? (https://www.excelbanter.com/excel-programming/419804-can-i-create-link-cell-take-me-another-worksheet.html)

MaryT

Can I create a link from a cell to take me to another worksheet?
 
I want to create a link from a cell in 2007 to take me directly to a
worksheet within the same workbook. For example, if I click on "Sacramento"
in Worksheet 1 it would take me to the worksheet Sacramento.

Lorne[_2_]

Can I create a link from a cell to take me to another worksheet?
 
Did you try the insert menu followed by the hyperlink button? It brings up
a window and one of the options is "another place in the same document". If
you select that you get a list of all available worksheets.


"MaryT" wrote in message
...
I want to create a link from a cell in 2007 to take me directly to a
worksheet within the same workbook. For example, if I click on
"Sacramento"
in Worksheet 1 it would take me to the worksheet Sacramento.





All times are GMT +1. The time now is 07:21 AM.

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