| I use this to move easily between pages in a large excel document.
Select the cell where you want the hyperlink to go and right click / select Hyperlink. Or select the cell and press Ctrl-k
In the window that appears:
In the left column select "Place in this document"
Text to display: Can be anything useful eg "Page2" if not greyed out. If it is greyed out the cell must be populated by something.
In, Type the cell reference: enter the cell co-ordinate on the destination page of where you want the cell highlighter / cursor to jump too.
In, Select a place in this document: select the name of which page you want to jump too. | 
Linear Mode
