Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating navigation buttons on a worksheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating navigation buttons on a worksheet
You can create Navigation buttons by using Drawing Objects and assigning
recorded macros to them. One way to get a drop down list is to use the Data Validation feature........ If you need assistance with either of these, post back and someone will help. Vaya con Dios, Chuck, CABGx3 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One worksheet to calulate different items simultaneously | Excel Worksheet Functions | |||
Creating a reference to a different worksheet | Excel Discussion (Misc queries) | |||
Min/Max/Close buttons have disappeared from worksheet window | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
Creating a new worksheet from a template | Excel Discussion (Misc queries) |