can we create links within a spreadsheet?

[bigdan]

In my current spreadsheet it would really help to have shortcuts within the sheet.

For example when I'm at, say, C20 it would be nice to have a quick way of getting to F300.

Are there any buttons or something that I can put near C20 that would take me there?

I'd prefer to avoid VBA.

Thanks!

 

[MrTeeny]

Have a look at HYERLINK

=HYPERLINK(F300,"Goto F300")

 

[Eric W]

MrTeeny has the right idea, but HYPERLINK requires a file name with the cell address. You can use # as a shortcut for the current file, so the formula would be:

=HYPERLINK("#F300","Go to F300")

You can also use HYPERLINK as a shortcut to fully qualified web addresses "http:\\www.google.com".