Creating navigation buttons on a worksheet
Maybe by using a hyperlink:
Insert|hyperlink
or
using the =hyperlink() worksheet function:
David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
ryan_dude wrote:
Hi
I'm trying to link togethor different pages on excel so i can navigate to
them from each page.
Also does anyone know how to create a drop down menu in excel?
Many Thanks in advance
Ryan
--
Dave Peterson
|