Can you use the hyperlink function to point to cell within same workbook?
I'm using Excel 2003.

I don't want to use Insert/Hyperlink feature because I have about 100
hyperlinks that I need to be able to easily edit - using find/replace (can't
do this with Insert/Hyperlink)

Here's a sample of what I've got:
=HYPERLINK('Test sheet'!A60,"return")

From another worksheet, click on the cell with "return" and then it should
take me to cell a60 in test sheet.

Thanks, Mary-Lou

A hyperlink to a location in the same workbook actually is a 'SubAddress',
and you can enter it this way:
=HYPERLINK"#'Sheet Name'!A55","To Sheet 'Sheet Name' Cell A55")

Note that the link starts with the # symbol, and that if the sheet's name
has spaces in it, you need to delimit the sheet name with single quote marks.

Hope this helps.

"PurpleMilk" wrote:

Can you use the hyperlink function to point to cell within same workbook?
I'm using Excel 2003.

I don't want to use Insert/Hyperlink feature because I have about 100
hyperlinks that I need to be able to easily edit - using find/replace (can't
do this with Insert/Hyperlink)

Here's a sample of what I've got:
=HYPERLINK('Test sheet'!A60,"return")

From another worksheet, click on the cell with "return" and then it should
take me to cell a60 in test sheet.

Thanks, Mary-Lou

Yes! That did the trick. Thank you very much.


"JLatham" wrote:

A hyperlink to a location in the same workbook actually is a 'SubAddress',
and you can enter it this way:
=HYPERLINK"#'Sheet Name'!A55","To Sheet 'Sheet Name' Cell A55")

Note that the link starts with the # symbol, and that if the sheet's name
has spaces in it, you need to delimit the sheet name with single quote marks.

Hope this helps.

"PurpleMilk" wrote:

Can you use the hyperlink function to point to cell within same workbook?
I'm using Excel 2003.

I don't want to use Insert/Hyperlink feature because I have about 100
hyperlinks that I need to be able to easily edit - using find/replace (can't
do this with Insert/Hyperlink)

Here's a sample of what I've got:
=HYPERLINK('Test sheet'!A60,"return")

From another worksheet, click on the cell with "return" and then it should
take me to cell a60 in test sheet.

Thanks, Mary-Lou