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