| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Hyperlinks
I have a file that is a balance sheet and another file that contains
individual worksheets for each item on the balance sheet, e.g. Balance Sheet Items: - Assets - Depreciation - Liabilities That means there are worksheets in another file for each of those three items. How can I put a hyperlink to these items in the actual balance sheet so that when you click on them you are taken right to the specific worksheet in the other file? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003: Hyperlinks
Insert--Hyperlink.
Follow the instructions in the dialogue box. You could also use the HYPERLINK function but I find that rather confusing. -- Brevity is the soul of wit. "oceanmist" wrote: I have a file that is a balance sheet and another file that contains individual worksheets for each item on the balance sheet, e.g. Balance Sheet Items: - Assets - Depreciation - Liabilities That means there are worksheets in another file for each of those three items. How can I put a hyperlink to these items in the actual balance sheet so that when you click on them you are taken right to the specific worksheet in the other file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - Hyperlinks | Excel Discussion (Misc queries) | |||
| how do i open quattro pro 7.0 (.wb3) file in excel 2003? | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Why no XML in Excel 2003 with Office Standard? | Excel Discussion (Misc queries) | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Linear Mode
