Excel 2003: Hyperlinks

O

oceanmist

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?
 
D

Dave F

Insert--Hyperlink.

Follow the instructions in the dialogue box. You could also use the
HYPERLINK function but I find that rather confusing.
 
Top