jumping to sheets?

[Guurt]

Hello All,

I have a workbook with 100 sheets and I often have to look something up on
random slides. How do I quickly get to a specific slide? For instance 'slide
50' causes me to click fifty times on the 1 step scroller either way (from
beginning or end).

The 'got to' or search function seems no option...?..

Thanx,
Guurt

 

[Roman]

Hi Guurt,
you could build a speciel sheet with "clickable" sheets names to jump
to them easy. Use this function to make it:

=HYPERLINK("#'sheetname'!a1";"your own text here")

I'v heard that this did not work in each version of excel but you might
be lucky!
R.