Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link worsheets in Excel
In word, your able to go to a page when clicking on a page# when creating a
table of contents. For example, I click on page 10, it brings me directly to that page. Can Excel do the same. For example, from a main worksheet, can I click on a account# from a list and go to that particular worksheet for more details. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link worsheets in Excel
Right click on the cell where you have written the word....Hyperlink...under
'Link To:' click on 'Place in this document'....now u will see a list of all the sheets that you have in that workbook..select the sheet you wanna link to..click OK..you can also go to a particular by changing A1 to something else. Does that work? Gary "Djasabe" wrote in message ... In word, your able to go to a page when clicking on a page# when creating a table of contents. For example, I click on page 10, it brings me directly to that page. Can Excel do the same. For example, from a main worksheet, can I click on a account# from a list and go to that particular worksheet for more details. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link worsheets in Excel
correction : you can also go to a particular CELL by changing A1 to
something "Gary" wrote in message ... Right click on the cell where you have written the word....Hyperlink...under 'Link To:' click on 'Place in this document'....now u will see a list of all the sheets that you have in that workbook..select the sheet you wanna link to..click OK..you can also go to a particular by changing A1 to something else. Does that work? Gary "Djasabe" wrote in message ... In word, your able to go to a page when clicking on a page# when creating a table of contents. For example, I click on page 10, it brings me directly to that page. Can Excel do the same. For example, from a main worksheet, can I click on a account# from a list and go to that particular worksheet for more details. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me link one cell to another. | Excel Worksheet Functions | |||
Link in Excel not working | Excel Discussion (Misc queries) | |||
how do i set up a link between one excel cell from an access cell | Excel Discussion (Misc queries) | |||
most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |