Why do you wish to do this?

A workaround is to add a screen tip when creating the Hyperlink or when editing
it.

Just type whatever you want to see when you hover.

Could be the sheetname or "click me to jump to Sheet4"


Gord Dibben MS Excel MVP

On 18 Apr 2007 17:10:06 -0700, " wrote:

1) Is there a way to create a hyperlink that just references the sheet
and cell you want to jump to within the same workbook? i.e.:

'sheet1'!A1

When I go through the "add hyperlink" option and choose "place in
workbook," it adds the whole file name to the hyperlink: i.e.

file:///\\server1\folder\myfilename.xls - 'sheet1'A1

2) Is there a way to directly edit the hyperlink address so I can
delete the file name?

Thanks.

John