Excel Hyperlink to internal destination

[Dalebopp]

Operating System: Mac OS X 10.5 (Leopard)

OK, I feel like an idiot having to post what should be, a very simple thing to do. However, I'm completely perplexed as to how to make a 'hyperlink' to another spot in the same file.

Example: I would like to link D17 (sheet 1) to F15 (sheet 2).

Now on the older versions of the software (currently using Microsoft Excel 2008 for Mac), it was SUPER easy to do this. The terrible part is, I have examples already embedded in the sheet, as I have e-mailed myself a version created on MS Excell 2003 (for Windows) at my office.

Can someone please clue me in as to what I'm doing wrong. All the help pages tell me to "follow the instructions", which of course, doesn't help my situation very much.

OK, be easy on me guys... I'm relatively new to Excel. I'm sure there's something very simple that I'm doing wrong, but it's just not as straight forward as I would have expected it to be (based on how easy it was to do in the older versions).

Thanks in advance for any help provided.

-Scott

 

[Bob Greenblatt]

Operating System: Mac OS X 10.5 (Leopard)

OK, I feel like an idiot having to post what should be, a very simple thing to
do. However, I'm completely perplexed as to how to make a 'hyperlink' to
another spot in the same file.

Example: I would like to link D17 (sheet 1) to F15 (sheet 2).

Now on the older versions of the software (currently using Microsoft Excel
2008 for Mac), it was SUPER easy to do this. The terrible part is, I have
examples already embedded in the sheet, as I have e-mailed myself a version
created on MS Excell 2003 (for Windows) at my office.

Can someone please clue me in as to what I'm doing wrong. All the help pages
tell me to "follow the instructions", which of course, doesn't help my
situation very much.

OK, be easy on me guys... I'm relatively new to Excel. I'm sure there's
something very simple that I'm doing wrong, but it's just not as straight
forward as I would have expected it to be (based on how easy it was to do in
the older versions).

Thanks in advance for any help provided.

-Scott

Select D17 on sheet 1. Then select Insert-hyperlink. Then click locate,
click the dropdown on cell reference, then select the sheet and enter the
cell.

 

[Dalebopp]

Bob,

I sincerely appreciate your help. I feel like a douche'... hah. I had actually gone to that exact screen, oh, maybe 50 times and kept clicking on the word (cell reference), as I thought that would work.

Anyhow, thanks for the very quick response. The format for asking questions, then getting them answered, is top-notch! This site has been a great wealth of information for me.

Thanks again!
-Scott