ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Links to tabs within a spreadsheet (https://www.excelbanter.com/links-linking-excel/26915-links-tabs-within-spreadsheet.html)

Steve R.

Links to tabs within a spreadsheet
 
I know how to embed a link to an Excel spreadsheet into a Word document. But
is there a way to embed a link to a specific tab within the spreadsheet?

JE McGimpsey

Add an anchor. Specifically, to the hyperlink, append

#Sheet1!A1

so if your hyperlink target is

file://localhost/Users/jem/Documents/workbook1.xls

then add the tab name and a cell reference:

file://localhost/Users/jem/Documents/workbook1.xls#Sheet2!A1



In article ,
"Steve R." <Steve wrote:

I know how to embed a link to an Excel spreadsheet into a Word document. But
is there a way to embed a link to a specific tab within the spreadsheet?



All times are GMT +1. The time now is 09:46 AM.

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