Hyperlink to spreadsheet

av8r · Feb 26th, 2002, 04:39 AM

How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.
P.S. I am trying to hyperlink from my website to a spreadsheet.

[ This Message was edited by: av8r on 2002-02-26 04:51 ]

Aladin Akyurek · Feb 26th, 2002, 04:43 AM

Quote:

On 2002-02-26 03:39, av8r wrote:
How can I hyperlink to a perticular sheet within a workbook? Thanks in advance.

=HYPERLINK(Data!A1,"Data")

entered in some cell in a worksheet, different from Data, which is the name of the worksheet of interest you want to hyperlink.

Mudface · Feb 26th, 2002, 04:53 AM

Or just choose Insert -Hyperlink from the menu, select your file in the top box (leave empty if it's within the same spreadsheet) and select the location within the file in the bottom box.

Chris Davison · Feb 26th, 2002, 07:39 AM

Quote:

On 2002-02-26 03:39, av8r wrote:
P.S. I am trying to hyperlink from my website to a spreadsheet.

if you want the HTML to hyperlink to a specific sheet in Excel : go to the sheet and name cell A1 "linktohere" or something appropriate...

then the HTML command will be

{A HREF="filename.xls#linktohere"}description{/A}

it follows the same basic logic as anchoring to another HTML document

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 04:39 AM	#1
av8r New Member Join Date: Feb 2002 Posts: 1	How can I hyperlink to a perticular sheet within a workbook? Thanks in advance. P.S. I am trying to hyperlink from my website to a spreadsheet. [ This Message was edited by: av8r on 2002-02-26 04:51 ]

Feb 26th, 2002, 04:53 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Or just choose Insert -Hyperlink from the menu, select your file in the top box (leave empty if it's within the same spreadsheet) and select the location within the file in the bottom box.